[VUSR] 65444 CS403 - Quiz No.2 May 03, 2012

CS403 – DataBase Management System

Quiz no 2May 03-,2012

Solved by   

4FUNKAR &Team

 

In an ERD, the focus is on the __ and the relationships between them. 
Select correct option: 

attributes 
entities 
keys 
indexes

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

condensed 
physical 
logical 
conceptual

 Anwar: in "One to One Relationship" One instance of first entity type is mapped with two instances of second entity type 
Select correct option: 

true 
false

: "Select" and "project" are the examples of 
Select correct option: 

Unary operations 
Binary operations 
Ternary operations 
All of above

 If A -> B and A -> C, then A -> BC The Inference Rule applies is; 
Select correct option: 

Union 
Decomposition 
Augmentation 
Reflexivity

 

 

Unary operations involves 
Select correct option: 

Only one relation 
Only two relations 
More than two relations 
Not more than five relations

 

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

person's name 
class location 
bank account balance 
book title

 

 

in "many to many relationship" one instance of first entity can be mapped with many instances of second entity 
Select correct option: 

true 
false

Quiz Start Time: 04:03 PM 
Time Left 89
sec(s) 
Question # 1 of 8 ( Start time: 04:03:58 PM ) Total Marks: 1
Which of the following might be represented with a single-valued attribute?
Select correct option:
person's phone number
car's color
employee's educational background
computer's processor speed

Quiz Start Time: 04:03 PM 
Time Left 89
sec(s) 
Question # 2 of 8 ( Start time: 04:04:11 PM ) Total Marks: 1
Binary relationships are those, which are established between
Select correct option:
One entity type
Two entity type
Three entity type
Unlimited entities

Quiz Start Time: 04:03 PM 
Time Left 89
sec(s) 
Question # 3 of 8 ( Start time: 04:04:42 PM ) Total Marks: 1
_____ is same as Equi-Join with a slight difference.
Select correct option:
Natural Join
Semi Join
Outer Join
Theta Join

Quiz Start Time: 04:03 PM 
Time Left 88
sec(s) 
Question # 4 of 8 ( Start time: 04:05:05 PM ) Total Marks: 1
"Select" and "project" are the examples of
Select correct option:
Unary operations
Binary operations
Ternary operations
All of above

Time Left 88
sec(s) 
Question # 5 of 8 ( Start time: 04:05:24 PM ) Total Marks: 1
Relational Calculus is a ___________ relational data manipulation language.
Select correct option:
Procedural, Informal
Non-Procedural, Informal
Procedural, Formal
Non-Procedural, Formal

Quiz Start Time: 04:03 PM 
Time Left 89
sec(s) 
Question # 6 of 8 ( Start time: 04:05:49 PM ) Total Marks: 1
In "One to Many" cardinality one instance of a relation is mapped with
Select correct option:
many instances of second entity type
One instance of second entity type
Primary key of 2 relations
none of above

Quiz Start Time: 04:03 PM 
Time Left 89
sec(s) 
Question # 7 of 8 ( Start time: 04:06:08 PM ) Total Marks: 1
Atomicity is a feature of ____.
Select correct option:
1NF
2NF
3NF
BCNF

 

Quiz Start Time: 04:03 PM 
Time Left 89
sec(s) 
Question # 8 of 8 ( Start time: 04:06:29 PM ) Total Marks: 1
A __ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
Select correct option:
strong
Weak
Business
Relationship

 

--
Zindagi mein 2 Logo ka buhat khayal rahkoooo

Ist woh jiss ney tumhari jeet ke Liye buhat kuch hara hoo (Father)

2nd woh jiss ko tum ney har dukh me pukaara hoo (Mother)

Regards, 

Umair Saulat

--
Please visit http://vusr.net for Old and Latest Papers, Assignments, Quiz and GDBs.
 
http://VUSR.net The ultimate VU Study Resource
 
You received this message because you are subscribed to the Google
Groups "VUSR" group.
 
 
To unsubscribe
vusr+unsubscribe@googlegroups.com
To Visit Group Home Page
http://groups.google.com/group/vusr?hl=en?hl=en