With each visit of this Database Management System online Quiz / Practice Test, the list of MCQs / Objective Questions presented will be different, offering you a diverse set of practice opportunities. This variability encourages you to practice extensively, refining the accuracy of your answers and your overall grasp of the content. By utilizing this resource, you can hone your skills and become more adept at managing time constraints during actual exams.
Test Instructions Question type Randomized MCQs.Changes every time you visit the test Total Number of Questions 30 Time Limit 20 Minutes Points 1 Point for each Question
Remaining Time: 0 MINUTES
0 of 30 questions completed
Questions:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Information
You have already completed the test before. Hence you can not start it again.
0 of 30 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0 )
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Question 1 of 30
Q-1.The Binary operation Union, denoted, as in the set theory by _____
Your Answer:Correct
Your Answer:Incorrect
Question 2 of 30
Q-2.______ is the restrictions imposed to maintain the data integrity of the database
Your Answer:Correct
Your Answer:Incorrect
Question 3 of 30
Q-3.Which of the following take a collection of values and return a single value as a result?
Your Answer:Correct
Your Answer:Incorrect
Question 4 of 30
Q-4.A Database schema, along with primary key and foreign key dependencies, can be depicted pictorially by _________
Your Answer:Correct
Your Answer:Incorrect
Question 5 of 30
Q-5.A___ in a table represents a relationship among a set of values.
Your Answer:Correct
Your Answer:Incorrect
Question 6 of 30
Q-6.An entity is represented by set of ___________
Your Answer:Correct
Your Answer:Incorrect
Question 7 of 30
Q-7.An entity set that has attributes to form a primary key; such an entity set is termed as______
Your Answer:Correct
Your Answer:Incorrect
Question 8 of 30
Q-8.QBE is based on______
Your Answer:Correct
Your Answer:Incorrect
Question 9 of 30
Q-9.__________is a set of entities of same type that share the same properties or attributes.
Your Answer:Correct
Your Answer:Incorrect
Question 10 of 30
Q-10.The number of Entity sets that participate in a relationship set is know as ____________ of Relationship
Your Answer:Correct
Your Answer:Incorrect
Question 11 of 30
Q-11.An Edge between a entity set and a binary relationship set can have an associated minimum and maximum cardinality, shown in the form of l and h, where l is the minimum and h is the maximum cardinality. What a Maximum Cardinality value of 1 indicates?
Your Answer:Correct
Your Answer:Incorrect
Question 12 of 30
Q-12.Which of the following statements stands true? I.A Relational database consists of collection of AttributesII.A Relational Database consists of collections of TablesIII.A relational Database consists of collections of ColumnsIV.A relational Database consists of collections of Rows
Your Answer:Correct
Your Answer:Incorrect
Question 13 of 30
Q-13.Which of the following structure represent the entity sets?
Your Answer:Correct
Your Answer:Incorrect
Question 14 of 30
Q-14.An entity set may not have sufficient attributes to form a primary key; such an entity set is termed as______
Your Answer:Correct
Your Answer:Incorrect
Question 15 of 30
Q-15.Which of the following describe the logical design of the database?
Your Answer:Correct
Your Answer:Incorrect
Question 16 of 30
Q-16.Which of the following symbol can be used for Assignment operation in the relational algebra expression?
Your Answer:Correct
Your Answer:Incorrect
Question 17 of 30
Q-17.The Relationship sets that involve two entity sets in known as___
Your Answer:Correct
Your Answer:Incorrect
Question 18 of 30
Q-18.Dashed ellipses represents_____
Your Answer:Correct
Your Answer:Incorrect
Question 19 of 30
Q-19.We shall use the term ________ to denote a candidate key that is chosen by the database designer as the principal means of identifying entities within in an entity set.
Your Answer:Correct
Your Answer:Incorrect
Question 20 of 30
Q-20.Which of the following is the Binary Operations?
Your Answer:Correct
Your Answer:Incorrect
Question 21 of 30
Q-21.A Super keys for which no proper subset is a super key. Such a minimal Super keys are called _______
Your Answer:Correct
Your Answer:Incorrect
Question 22 of 30
Q-22.An Edge between a entity set and a binary relationship set can have an associated minimum and maximum cardinality, shown in the form of l and h, where l is the minimum and h is the maximum cardinality. What a minimum Cardinality value of 1 indicates?
Your Answer:Correct
Your Answer:Incorrect
Question 23 of 30
Q-23.Ellipses represent_________
Your Answer:Correct
Your Answer:Incorrect
Question 24 of 30
Q-24.Which of the following operation, denoted by cross (×), allows to combine the information from any two relation.
Your Answer:Correct
Your Answer:Incorrect
Question 25 of 30
Q-25.In a Entity sets Customer and Loan, an Attribute name consisting of first-name ,middle-name, and last-name. An Attribute name is _______
Your Answer:Correct
Your Answer:Incorrect
Question 26 of 30
Q-26.The table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table.
Your Answer:Correct
Your Answer:Incorrect
Question 27 of 30
Q-27.For a binary relationship set R between entity sets A and B, the Mapping Cardinality is MANY to MANY if
Your Answer:Correct
Your Answer:Incorrect
Question 28 of 30
Q-28.For a Binary relationship set R between entity sets A and B,the ________ express the number of entities to which another entity can be associated.
Your Answer:Correct
Your Answer:Incorrect
Question 29 of 30
Q-29.______ should not contain NULL value in its Attribute value.
Your Answer:Correct
Your Answer:Incorrect
Question 30 of 30
Q-30.Which of the following uses domain variable that take on values from an attributes domain, rather that values for an entire tuple.?
Your Answer:Correct
Your Answer:Incorrect