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
2nd woh jiss ko tum ney har dukh me pukaara hoo (Mother)
--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
To post a new message on this group, send email to vuZs@googlegroups.com
Message Posting Rules: http://vuzs.net/faq/4795-vuzs-google-groups-basic-rules-for-posting-messages.html
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email to vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
No comments:
Post a Comment