NEW
Font size
WorksheetsDBMS Quiz1
Total questions: 10
Worksheet time: 5mins
The Data Model that describes how the data is actually stored is:
internal model
external model
logical model
none of these
Data about data is normally termed as:
Directory
Data Bank
Meta data
none of these
One of the following is a valid Record based data model
Object Oriented model
Relational model
ER Model
None of these
Collection of information stored in a Database at a particular moment is:
View
Schema
instance
None of these
An Association between Student and a course is:
1:1 relationship
1:M relationship
M:N relationship
None of these
An entity set that does not have sufficient attributes to form a Primary key is a:
Strong Entity set
Weak entity set
Simple entity set
Primary entity set
The users who use the easy to use menu are called:
Sophisticated end users
Naive users
Stand alone users
Casual End users
Suppose relation R(A,B,C,D,E) has the following functional dependencies:
A -> B
B -> C
BC -> A
A -> D
E -> A
D -> E
A
E
B,C
D
The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into:
employee1 (ID, name)
employee2 (name, street, city, salary)
Lossless decomposition
Lossless-join decomposition
All of the mentioned
None of the mentioned
Which of the following is not Armstrong’s Axiom?
Reflexivity rule
Transitivity rule
Pseudotransitivity rule
Augmentation rule
