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.Suppose we want to list all loan numbers and the amount of the loans, but do not care about the branch name. Which of the following operation allows us to produce this relation?
Your Answer:Correct
Your Answer:Incorrect
Question 2 of 30
Q-2.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 3 of 30
Q-3.An expression {<X1,X2,….Xn > | P(X1,X2,….Xn)} , Where X1,X2,….Xn represent Domain variable. P represents a formula composed of atoms. This expression is of the of the following?
Your Answer:Correct
Your Answer:Incorrect
Question 4 of 30
Q-4.Double ellipses represents_____
Your Answer:Correct
Your Answer:Incorrect
Question 5 of 30
Q-5.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 6 of 30
Q-6.The select operation selects tuples that satisfy a given predicate. We use the lowercase______ to denote selection
Your Answer:Correct
Your Answer:Incorrect
Question 7 of 30
Q-7.An Attribute takes a ________value when an entity does not have a value for it.
Your Answer:Correct
Your Answer:Incorrect
Question 8 of 30
Q-8.Which of the following operation, denoted by cross (×), allows to combine the information from any two relation.
Your Answer:Correct
Your Answer:Incorrect
Question 9 of 30
Q-9.Which of the following operation allows us to find the tuples that are in one relation but are not in another relation?
Your Answer:Correct
Your Answer:Incorrect
Question 10 of 30
Q-10.An ER diagram can express the overall __________of a database graphically
Your Answer:Correct
Your Answer:Incorrect
Question 11 of 30
Q-11.A______is a set of relationships of the same type among several entities
Your Answer:Correct
Your Answer:Incorrect
Question 12 of 30
Q-12.Which of the following Statements stands true for Right 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 13 of 30
Q-13.Suppose we wish to find all customers who have both a loan and an account. Which of the following operation allows us to produce this relation?
Your Answer:Correct
Your Answer:Incorrect
Question 14 of 30
Q-14.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 15 of 30
Q-15.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 16 of 30
Q-16.An Entity is a________________
Your Answer:Correct
Your Answer:Incorrect
Question 17 of 30
Q-17.Double Line indicate_____
Your Answer:Correct
Your Answer:Incorrect
Question 18 of 30
Q-18.Natural join operation is denoted by symbol____
Your Answer:Correct
Your Answer:Incorrect
Question 19 of 30
Q-19.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 20 of 30
Q-20.Which of the following describes the relation name (table name), attributes, and their names?
Your Answer:Correct
Your Answer:Incorrect
Question 21 of 30
Q-21.The Relationship sets that involve two entity sets in known as___
Your Answer:Correct
Your Answer:Incorrect
Question 22 of 30
Q-22.The mathematical terms relation and tuples are referred to as?
Your Answer:Correct
Your Answer:Incorrect
Question 23 of 30
Q-23.For each attributes, there is set of permitted values called______
Your Answer:Correct
Your Answer:Incorrect
Question 24 of 30
Q-24.The select, project and rename operations are called____
Your Answer:Correct
Your Answer:Incorrect
Question 25 of 30
Q-25.__________ 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 26 of 30
Q-26.Which of the following take a collection of values and return a single value as a result?
Your Answer:Correct
Your Answer:Incorrect
Question 27 of 30
Q-27.Which of the following describe the snapshot of the data in the database at a given instant in time?
Your Answer:Correct
Your Answer:Incorrect
Question 28 of 30
Q-28.QBE is based on______
Your Answer:Correct
Your Answer:Incorrect
Question 29 of 30
Q-29.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 30 of 30
Q-30.Diamond Represents______
Your Answer:Correct
Your Answer:Incorrect
Practice More Online Tests