CS403 Database Management Final Paper 23 February 2013

Total Questions: 52

Total Marks: 80

Total MCQs: 40 (Each of 1 Mark)

Total Short Questions: 4 (Each of 2 Mark)

Total Short Questions: 4 (Each of 3 Mark)

Total Long Questions: 4 (Each of 5 Mark)

Q1: write down the alternative name of browser base form? 2 marks

Q2: Different classification of indexes? 2 Marks

Q3: List down any two problems which may come up if the concurrency is not controlled properly? 2 marks ( handout page 307)

Q4: In three schema architecture, External schema is responsible for data storage on hard disk. Correct and justify it. 3 marks

Q5: Create view named “Product_list” on product table which will show all the columns? 3 marks

Q6: Describe the importance of Data link properties tool in designing form by using MS Access? 3 marks

Q7: In recovery procedure, transaction ended before the check points are redone. Correct it and justify? 3 marks

Q8: Draw cross Reference matrix? 5 marks diagram was given

Q9: Deadlock is a serious threat for the concurrent transaction; shortly explain the approach which is used to detect the deadlock by DBMS? 5 marks

Q10: Rehashing is better than chaining in term of time. (Rehashing and chaining collision resolution technique in hashing). Justify it ? 5 Marks

Another Paper:

(2 marks Questions)

1-      Write any two benefits of using “VIEWS”?

2-      Write down basic disadvantages of using Indexes?

3-      Identify the main difference between Intersection and Set difference operations.

4-      Which clause is used to sort the records in the result set?

 

(3 marks Questions)

 

5-      STUDENT table is given below; Write a SQL query to get all student names along with father names and address, which belongs to Lahore city.  STUDENT (stu_id, stu_name, father_name, address, city, phone_no)

 

6-      Create a unique index named ‘ IndexNum’ on the ‘CustName’ column of the table ‘Customer’.

 

7-      Create a view named “STUDENT-IDs” on STUDENT table which will only show the ST-ID in ascending order

                    STUDENT (ST-ID, ST-NAME, ST-CLASS)

 

8-      Employee

Emp-ID

Emp-Name

City

1 ABC Lahore
2 DEF Islamabad
3 GHI Lahore
4 JKL Karachi

 

Dept-Head

Head-ID

Dept-Name

1 HR Dept
3 Accounts Dept

 

Employee X (Join) Dept-Head

The given algebra expression has following output / resultant table.

 

Resultant Table

Emp-ID

Emp-Name

City

Dept-Name

1 ABC Lahore HR Dept
3 GHI Lahore Accounts Dept

 

Find that the said scenario is an example of which Join Type. Also define that particular join type.

[Theta Join, Equi Join, Natural Join, Semi Join, Left Outer Join]

(5 marks Questions)

 

9-      Student-Record (stu_id, COURSE_ID, SEM_NO, MIDTERM_MARKS, fINALTERM_MARKS)

 

Write a SQL query on Student-Record table to get record of all students who’s MIDTERM_MARKS are greater than 20 and FINALTERM_MARKS are not less than 30.

 

10-  Analyze the statements given below and identify each statement as correct or incorrect. Justify your answer in either case.

 

  1. In Recovery Procedure, the transactions that have a begin entry but does not have commit or rollback entry, are Redone.

 

  1. “Check point” is an entry in the data dictionary.

 

11-  If we have two tables Table 1 and Table 2. Table 1 and Table 2 have same attributes and same records in them. Consider, we have 20 indexes on Table 1 and 14 indexes on Table 2. In Index Sequential File, we want to perform three operations (Insertion, Updation and Searching) on values in both tables. Keeping in mind, the scenario above; analyze the statements given below and identify as correct or incorrect.

 

A – Time to insert value in Table 1 is greater than in Table 2.

B – Time to update value in Table 2 is greater than in Table 1.

C – Time to retrieve data from Table 1 is less than Table 2.

 

 

12-  Find out the Cartesian product (A X B) of the given pair of sets. Also find out any two relations from the set A X B

 

A=>Days_in_Week

B=>Shifts

 

A = {Monday, Tuesday, Wednesday, Thursday, Friday}

B= {Shift-1, Shift-2, Shift-3}.

 

DOWNLOAD SOLUTION HERE
loading...