CS403 Quiz No.1 Shared by Qudsia (Solved)

Question # 1 of 10 ( Start time: 09:00:12 PM ) Total Marks: 1
ERD is a ____ data model.
Select correct option:
Graphical
Textual
Semantic           (Correct)
Syntax


Question # 2 of 10 ( Start time: 09:00:59 PM ) Total Marks: 1
Each table must have a ____ key.
Select correct option:
primary           (Correct)
secondary
logical
foreign


Question # 3 of 10 ( Start time: 09:01:28 PM ) Total Marks: 1
A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a ____.
Select correct option:
superkey
candidate key
primary key
secondary key


Question # 4 of 10 ( Start time: 09:02:38 PM ) Total Marks: 1
Which of the following constraints enforces entity integrity?
Select correct option:
PRIMARY KEY
FOREIGN KEY
CHECK
NOT NULL          (Correct)


Question # 5 of 10 ( Start time: 09:03:42 PM ) Total Marks: 1
Any combination of attributes with super key is ____
Select correct option:
Primary Key
Foreign Key
Super Key           (Correct)
Candidate Key


Question # 6 of 10 ( Start time: 09:04:14 PM ) Total Marks: 1
Which model operates at the lowest level of abstraction?
Select correct option:
conceptual
internal
external
physical


Question # 7 of 10 ( Start time: 09:05:14 PM ) Total Marks: 1
The most widely used conceptual model is the ____ model.
Select correct option:
implementation
ER
Object Oriented
internal


Question # 8 of 10 ( Start time: 09:06:37 PM ) Total Marks: 1
The entity relationship diagram is used to graphically represent the ____ database model.
Select correct option:
condensed
physical
logical           (Correct)
conceptual


Question # 9 of 10 ( Start time: 09:07:46 PM ) Total Marks: 1
In which stage of the database development process logical design is created?
Select correct option:
Requirement analysis
Database design           (Correct)
Physical design
Implementation


Question # 10 of 10 ( Start time: 09:09:11 PM ) Total Marks: 1
Which tool is used to identify relationship between entities?
Select correct option:
Cross Reference Matrix
Sub-type discriminator
DFD           (Correct)
None of the above