Scribd
Upload
161 views6 pages

Information Systems Department: Imam Mohammad Ibn Saud Islamic University College of Computer and Information Sciences

1. The document is an exam for a database course consisting of 5 questions. 2. It provides instructions for students to write their name, answer all questions within the time limit using the provided tables to write SQL statements. 3. The questions involve creating table structures, updating a record, using nested queries, aggregating data by groups, and performing joins.

Uploaded by

محمد الحسن
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
161 views6 pages

Information Systems Department: Imam Mohammad Ibn Saud Islamic University College of Computer and Information Sciences

1. The document is an exam for a database course consisting of 5 questions. 2. It provides instructions for students to write their name, answer all questions within the time limit using the provided tables to write SQL statements. 3. The questions involve creating table structures, updating a record, using nested queries, aggregating data by groups, and performing joins.

Uploaded by

محمد الحسن
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 6

Imam Mohammad Ibn Saud Islamic University

College of Computer and Information Sciences


Information Systems Department
Course Title: Introduction to Databases
Course Code: IS 220
Course Instructor: Female: Dr. Hala Alrumaih
Male: Dr. Yasser Kotb
Exam: Quiz#2
Semester: Spring 2022
Date: 21-04-2022
Duration: 75 Minutes
Marks: 5 Marks
Privileges: ☐ Open Book ☐ Open Notes
☐ Calculator Permitted ☐ Laptop Permitted

Student Name (in English):

Student ID:

Section No.:

Instructions:
1. Answer All questions; there are Five questions in Two pages.
2. Write your name on each page of the exam paper.
3. Write your answers directly on the question sheets. Use the ends of the question pages for
rough work or if you need extra space for your answer.
4. If information appears to be missing from a question, make a reasonable assumption, state
your assumption, and proceed.
5. No questions will be answered by the invigilator(s) during the exam period.

Official Use Only


Question Student Marks Question Marks

1 1
2 1
3 1
4 1
5 1

Total 5

Student Name (in English): ________________________________________ Student ID: ___________________________

Imam University | CCIS | Doc. No. 006-02-20170316 Page 1 of 6


Question 1: To be answered in (50) Minutes [ ] / _5_ Marks

Question: Write the suitable SQL statement to answer the following questions based on the following tables:

1. Write the DDL statement for defining the three tables (Branch, Staff, and
Property).

Imam University | CCIS | Doc. No. 006-02-20170316 Page 2 of 6


Student Name (in English): ________________________________________ Student ID: ___________________________

2. Change Property’s (PNo= 101) type to house with 5 rooms.

3. By using Nesting Query, Retrieve Name and Salary of staff who works in Riyadh

4. Retrieve number of property under each type.

5. List the name of staff, the branch they work in and the type of property they
manage. (Use join)

Imam University | CCIS | Doc. No. 006-02-20170316 Page 3 of 6


Q2

Imam University | CCIS | Doc. No. 006-02-20170316 Page 4 of 6


Q3 .

Imam University | CCIS | Doc. No. 006-02-20170316 Page 5 of 6


Q4 Q5

Imam University | CCIS | Doc. No. 006-02-20170316 Page 6 of 6

You might also like