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 foreign key is equal to the candidate key in some row of the primary table, or else has no value (the NULL value.). This rule is called a ______ between the two tables.
Your Answer:Correct
Your Answer:Incorrect
Question 2 of 30
Q-2.An entity is represented by set of ___________
Your Answer:Correct
Your Answer:Incorrect
Question 3 of 30
Q-3.If we want to include attributes from two different relations, which of the following operations is needed?
Your Answer:Correct
Your Answer:Incorrect
Question 4 of 30
Q-4.For example Loan-number attribute for a specific loan entity set is referred to as
Your Answer:Correct
Your Answer:Incorrect
Question 5 of 30
Q-5.Which of the following Statements stands true for Left outer-join?
The left outer join takes all tuples in the left relation that did not match with any tuple in the right relation, pads the tuples with null values for all other attributes from the right relation, and add them to the result of the natural join. It pads tuples from the right relation that did not match any from the left relation with nulls and adds them to the result of the natural join. it pads tuples from the left relation that did not match any from the right relation,as well as tuples from the right relation that did not match any from the left relation,abd adding them to the result of join It takes all tuples in the right relation that did not match with any tuple in the right relation, pads the tuples with null values for all other attributes from the right relation, and add them to the result of the natural join.
Your Answer:Correct
Your Answer:Incorrect
Question 6 of 30
Q-6.SQL is based on______
Your Answer:Correct
Your Answer:Incorrect
Question 7 of 30
Q-7.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 8 of 30
Q-8.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 9 of 30
Q-9.Which of the following operation that allows us to combine certain selections and a Cartesian product into one operation?
Your Answer:Correct
Your Answer:Incorrect
Question 10 of 30
Q-10.The purpose of the foreign key is to identify a particular row of ___________.
Your Answer:Correct
Your Answer:Incorrect
Question 11 of 30
Q-11.Which of the following Statements stands true for Full outer-join?
The left outer join takes all tuples in the left relation that did not match with any tuple in the right relation, pads the tuples with null values for all other attributes from the right relation, and add them to the result of the natural join. It pads tuples from the right relation that did not match any from the left relation with nulls and adds them to the result of the natural join. it pads tuples from the left relation that did not match any from the right relation, as well as tuples from the right relation that did not match any from the left relation, and adding them to the result of join It takes all tuples in the right relation that did not match with any tuple in the right relation, pads the tuples with null values for all other attributes from the right relation, and add them to the result of the natural join.
Your Answer:Correct
Your Answer:Incorrect
Question 12 of 30
Q-12.A_______is a set of one or more attributes that, taken collectively; allow us to identify uniquely an entity in the entity set.
Your Answer:Correct
Your Answer:Incorrect
Question 13 of 30
Q-13.The select, project and rename operations are called____
Your Answer:Correct
Your Answer:Incorrect
Question 14 of 30
Q-14.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 15 of 30
Q-15.Double ellipses represents_____
Your Answer:Correct
Your Answer:Incorrect
Question 16 of 30
Q-16.Which of the following operation behave just like join operations except on tuples that do not occur in the join results?
Your Answer:Correct
Your Answer:Incorrect
Question 17 of 30
Q-17.Which of the following describe the logical design of the database?
Your Answer:Correct
Your Answer:Incorrect
Question 18 of 30
Q-18.Consider the entity relationship which consists of two entity sets, customer and loan, related through a binary relationship set borrower. An undirected line (--) from the relationship set borrower to the entity set loan specifies that borrower is either a __________ or __________relationship set from customer to loan.
Your Answer:Correct
Your Answer:Incorrect
Question 19 of 30
Q-19.A Database schema, along with primary key and foreign key dependencies, can be depicted pictorially by _________
Your Answer:Correct
Your Answer:Incorrect
Question 20 of 30
Q-20.Which of the following are the fundamental operations in the Relational Algebra?
Your Answer:Correct
Your Answer:Incorrect
Question 21 of 30
Q-21.The Project operation selects tuples with some attributes that we wish to include but some attribute we do not want to include in the final relation. We use the lowercase______ to denote Project operation.
Your Answer:Correct
Your Answer:Incorrect
Question 22 of 30
Q-22.For each attribute in the table, there is set of permitted values, called the _____of that Attribute.
Your Answer:Correct
Your Answer:Incorrect
Question 23 of 30
Q-23.Consider an employee entity set with the attribute phone-number, attribute phone-number is a ________
Your Answer:Correct
Your Answer:Incorrect
Question 24 of 30
Q-24.__________ is the snapshot of the relation at a particular time. It consists of the data which is present inside the relation at a particular instance of time. Duplicate row entries are not allowed in the _____. Though in SQL, duplicate rows are allowed in the table.
Your Answer:Correct
Your Answer:Incorrect
Question 25 of 30
Q-25.For a binary relationship set R between entity sets A and B,the Mapping Cardinality is MANY to ONE if
Your Answer:Correct
Your Answer:Incorrect
Question 26 of 30
Q-26.For each attributes, there is set of permitted values called______
Your Answer:Correct
Your Answer:Incorrect
Question 27 of 30
Q-27.For a weak entity set to be meaningful, it must be associated with another entity set called the ___________
Your Answer:Correct
Your Answer:Incorrect
Question 28 of 30
Q-28.The Domain relational calculus is a ___________Query Language.
Your Answer:Correct
Your Answer:Incorrect
Question 29 of 30
Q-29.Datalog is based on______
Your Answer:Correct
Your Answer:Incorrect
Question 30 of 30
Q-30.The Relationship sets that involve two entity sets in known as___
Your Answer:Correct
Your Answer:Incorrect