loading...

CS403 VU Solved Quiz No. 1 Spring 2012

Question # 1 of 10 ( Start time: 08:56:04 PM ) Total Marks: 1

Which of the following constraints enforces entity integrity?
Select correct option:

PRIMARY KEY
FOREIGN KEY
CHECK
NOT NULL

Quiz Start Time: 08:56 PM Time Left 89

 

Question # 2 of 10 ( Start time: 08:57:21 PM ) Total Marks: 1
Data about data is database
Select correct option:

True
False
Partially True
None of the Above

Quiz Start Time: 08:56 PM Time Left 84

 

Question # 3 of 10 ( Start time: 08:58:29 PM ) Total Marks: 1
Which of the following is NOT a component of a DFD?
Select correct option:

Dataflow
Datastore
External entities
Relationship between external entities

Quiz Start Time: 08:56 PM Time Left 72

 

Question # 4 of 10 ( Start time: 08:59:33 PM ) Total Marks: 1
Which of the following describes a database system?
Select correct option:

A collection of stored operational data used by the application system of some particular enterprise
A shared collection of logically related data (and a description of this data) designed to meet the information needs of an organisation
A collection of stored data organised in such a way that all user requirements are satisfied by the database. In general there is only one copy of each item of data although there may be controlled repetition of some data.
All of the above

Quiz Start Time: 08:56 PM Time Left 89

 




Question # 5 of 10 ( Start time: 09:00:14 PM ) Total Marks: 1
Which of the following describes the job of a database administrator?
Select correct option:

Development, implementation operation of the physical database
Creation of the system catalog
Monitoring and controlling database security and authorization: Setting up controls to ensure the quality and integrity of data
All of the above

Quiz Start Time: 08:56 PM Time Left 88

 

Question # 6 of 10 ( Start time: 09:00:34 PM ) Total Marks: 1
A________is used to maintain a connection between the users of the database system.
Select correct option:

mail server
file server
client-server
none of the given

Quiz Start Time: 08:56 PM Time Left 88

 

Question # 7 of 10 ( Start time: 09:01:13 PM ) Total Marks: 1
A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity. True or false?
Select correct option:

True
False
Partially True
None of the given

Quiz Start Time: 08:56 PM Time Left 88

 

Question # 8 of 10 ( Start time: 09:01:36 PM ) Total Marks: 1
Which of the following is INCORRECT statement concerning the database design process?
Select correct option:

During requirements collection and analysis phase, one can gather the data requirements of database users.
By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.
Transformation of the high level data model into the implementation data model is called logical design or data model mapping.

During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.

 

Quiz Start Time: 08:56 PM Time Left 89

 

Question # 9 of 10 ( Start time: 09:01:59 PM ) Total Marks: 1
Which model operates at the lowest level of abstraction?
Select correct option:

conceptual
internal
external
physical

Quiz Start Time: 08:56 PM Time Left 90

 

Question # 10 of 10 ( Start time: 09:02:18 PM ) Total Marks: 1
A table can be logically connected to another table by defining a ____.
Select correct option:

hyperlink
common attribute
primary key
superkey

DOWNLOAD SOLUTION HERE
loading...