CS403 - Database Management Systems Quiz # 1 will start from Tuesday, 16th Jun, 2015 and will remain open for two days the last day will be Wednesday, 17th Jun, 2015.

[Ahmad]

Quiz No.1	Dated: Jun 09, 15
Dear Students,   Quiz # 1 will start from Tuesday, 16th Jun, 2015 and will remain open for two days the last day will be Wednesday, 17th Jun, 2015. The lectures included in this quiz will be from Lecture # 1 to Lecture # 18.   Read the following instructions carefully before attempting the Quiz.   Quiz will be based upon Multiple Choice Questions. You have to attempt the quiz online. You can start attempting the quiz any time within given date(s) of a particular subject by clicking the link for Quiz in LMS. It will be opened only for Two days (48 Hours). All overseas students should manage their quiz time according to Pakistan Standard Time (PST). The time to attempt the Quiz is limited. Once you login to attempt the quiz, the countdown will start and you have to complete the quiz in given amount of time. So always keep an eye on the remaining time. Attempting quiz is unidirectional. Once you move forward to the next question, you cannot come back to the previous one. Therefore before moving to the next question, make sure that you have selected the best option. If due to any reason, access to internet is lost (like power failure or disconnection of internet), you will be able to attempt the quiz again from the position where you left in last attempt. But remember that you have to complete the quiz before expiry of the deadline.   If any student failed to attempt the quiz in given time then no re-take or offline quiz will be held.

[Maximas]

[Maximas]

[Maximas]

[+ Ijaz]

Quiz #1 CS403 DBMS Lecture 1-18

Spring 2015

 

Data about data is database
Select correct option:

True                            
False   (Data about data is data meta)
Partially True
None of the Above

 

Which of the following might be represented with a multivalued attribute? 
Select correct option: 

person's name 

class location 
bank account balance 
book title

The entity relationship diagram is used to graphically represent the __ database model. 
Select correct option: 

condensed 
physical 
logical 
conceptual

 

Which levels are mostly used for Detailed DFD?
Select correct option:

Level-0, Level-1
Level-1, Level-2
Level-2, Level-3
Level-3, Level-4

Which of the following tool is used to design conceptual database design?
SQL
MS Access
Oracle
This model is independent of any tool

 

Database application is a program which is used for performing certain operation such as

Insertion of data

Extraction of data

Updating data

All

 

Incase of Context-level Diagram, the system is represented by

Select correct option:

One process atleast   

Two processes atleast

One process only

Any number of processes

 

 

Free standing data dictionary is created by?
Ans: Case tools

 

7. Which of the following is true regarding foreign keys?

There can only be one foreign key in a relation

There can be as many foreign keys as needed

Foreign key is not a super key

Each table in database must have a foreign key

 

 

Within a table, each primary key value __.
Select correct option:

is a minimal super key
is always the first field in each table
must be numeric
must be unique