Past Papers Data Base Management System

[OBJECTIVE]

Subject: Data Base Management System

Time Allowed: 10 Minutes

Maximum Marks: 10

NOTE: Attempt this Paper on this Question Sheet only. Please encircle the correct option. Division of marks is given in front of each question. This Paper will be collected back after expiry of time limit mentioned above.

 

Part-I Encircle the right answer, cutting and overwriting is not allowed. (1×10=10)

1. What is full form of SQL Statement
a) Structuring Query List b) Structure Query Language
c) Simple Query Language d) None of the above
2. Which operator perform Pattern matching
a) Between b) Liked
c) Exists operator d) None of the above
3. You can add a new row using SQL in a database with the following?
a) ADD b) Delete

c) Alter d) Remove
4. Which statement is wrong about PRIMARY KEY constraint in SQL?
a) The primary key uniquely identifies each record
b) Primary key can be made based on multiple columns
c) Primary key must be made of any single column .
d) Primary key must contain a unique value .
5. In existing table alter table statement is used to
a) Delete Column b) Delete Constraint
c) Delete Columns d) All of the above
6. Wrong statement about the ORDER BY keyword is
a) Used to sort the result-set in ascending or descending order
b) The ORDER BY keyword sorts the records in ascending order by default.
c) The ORDER BY keyword sorts the records in ascending order by default.
d) To sort the records in ascending order, use the ASC keyword.
7. If you want to allow age of-a person < 55 in the column Age of table Person, then which constraint will be applied to AGE column?
a) Default b) Check
c) Not Null d) None
8. To give a temporary name to a table, or a column in a table for more readability, what is used?
a} SQL Wild Card b) SQL Aliases
c) SQL LIKES d) SQL Comments
9. Logical operators used in SQL are
a) AND, OR, NOT b) && li, ;
c) #,$,% d) None of above
10. To specify the number of records to return, which keyword is used –
a) FIRST b) TOP
c) START d) ROW

[SUBJECTIVE]

Subject: Data Base Management System

Time Allowed: 2 Hours 45 Minutes

Maximum Marks: 50

NOTE: ATTEMPT THIS (SUBJECTIVE) ON THE SEPARATE ANSWER SHEET PROVIDED.

Part-II Give short answers of the following:. (4×5=20)

Q#1: What is the difference between Sequential file system and Index Sequential File system?

Q#2: Explain the concept of Entity and Relationship

Q#3: What is meant by Referential Integrity? –

Q#4: What is the concept of Primary Key, Composite Primary Key and Foreign key?

Q#5: What is the concept of ACID properties of Transaction Processing?

 

 

Part-III Give brief answers of the following. (3×10=30)

Q#1: Normalize the Given Table up to 3NF

INV #                     Date                      Customer ID       Customer Name               Product No         Description        Price

1                              2 Dec                     C1                           Ali & Co                                                P1                           Shirt                       500

2                              4 Dec                     C1                           Ali & Co                                                P2                           Pent                      1000

Q#2: What is the concept of Master Detail Tables explain with example?

Q#3: What is data mining explain with example?

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.