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.An advantage of the database management approach is
Your Answer:Correct
Your Answer:Incorrect
Question 2 of 30
Q-2.Which of the following is a legal expression in SQL?
Your Answer:Correct
Your Answer:Incorrect
Question 3 of 30
Q-3.The natural join is equal to :
Your Answer:Correct
Your Answer:Incorrect
Question 4 of 30
Q-4.Which of the following operations need the participating relations to be union compatible?
Your Answer:Correct
Your Answer:Incorrect
Question 5 of 30
Q-5.In the architecture of a database system external level is the
Your Answer:Correct
Your Answer:Incorrect
Question 6 of 30
Q-6.E-R model uses this symbol to represent weak entity set ?
Your Answer:Correct
Your Answer:Incorrect
Question 7 of 30
Q-7.A B-tree of order m has maximum of _____________ children
Your Answer:Correct
Your Answer:Incorrect
Question 8 of 30
Q-8.The file organization that provides very fast access to any arbitrary record of a file is
Your Answer:Correct
Your Answer:Incorrect
Question 9 of 30
Q-9.It is better to use files than a DBMS when there are
Your Answer:Correct
Your Answer:Incorrect
Question 10 of 30
Q-10.Which of the following is another name for weak entity?
Your Answer:Correct
Your Answer:Incorrect
Question 11 of 30
Q-11.Hierarchical model is also called
Your Answer:Correct
Your Answer:Incorrect
Question 12 of 30
Q-12.Which of the following database object does not physically exist?
Your Answer:Correct
Your Answer:Incorrect
Question 13 of 30
Q-13.‘AS’ clause is used in SQL for
Your Answer:Correct
Your Answer:Incorrect
Question 14 of 30
Q-14.In an E-R diagram attributes are represented by
Your Answer:Correct
Your Answer:Incorrect
Question 15 of 30
Q-15.A DBMS query language is designed to
Your Answer:Correct
Your Answer:Incorrect
Question 16 of 30
Your Answer:Correct
Your Answer:Incorrect
Question 17 of 30
Q-17.It is possible to define a schema completely using
Your Answer:Correct
Your Answer:Incorrect
Question 18 of 30
Q-18.The language used in application programs to request data from the DBMS is referred
to as the
Your Answer:Correct
Your Answer:Incorrect
Question 19 of 30
Q-19.The RDBMS terminology for a row is
Your Answer:Correct
Your Answer:Incorrect
Question 20 of 30
Q-20.The way a particular application views the data from the database that the application
uses is a
Your Answer:Correct
Your Answer:Incorrect
Question 21 of 30
Q-21.The relational model feature is that there
Your Answer:Correct
Your Answer:Incorrect
Question 22 of 30
Q-22. What is a relationship called when it is maintained between two entities?
Your Answer:Correct
Your Answer:Incorrect
Question 23 of 30
Q-23.A primary key is combined with a foreign key creates
Your Answer:Correct
Your Answer:Incorrect
Question 24 of 30
Q-24._____________ function divides one numeric expression by another and returns the
remainder
Your Answer:Correct
Your Answer:Incorrect
Question 25 of 30
Your Answer:Correct
Your Answer:Incorrect
Question 26 of 30
Q-26.Which of the following operation is used if we are interested in only certain columns of a
table?
Your Answer:Correct
Your Answer:Incorrect
Question 27 of 30
Q-27.Relational Algebra is
Your Answer:Correct
Your Answer:Incorrect
Question 28 of 30
Q-28.In E-R diagram generalization is represented by
Your Answer:Correct
Your Answer:Incorrect
Question 29 of 30
Q-29.SET concept is used in :
Your Answer:Correct
Your Answer:Incorrect
Question 30 of 30
Q-30.Which database level is closest to the users?
Your Answer:Correct
Your Answer:Incorrect