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.which of the following is record based logical model?
Your Answer:Correct
Your Answer:Incorrect
Question 2 of 30
Q-2.TrAnsaction processing is associated with everything below except
Your Answer:Correct
Your Answer:Incorrect
Question 3 of 30
Q-3.In E-R Diagram relationship type is represented by
Your Answer:Correct
Your Answer:Incorrect
Question 4 of 30
Your Answer:Correct
Your Answer:Incorrect
Question 5 of 30
Your Answer:Correct
Your Answer:Incorrect
Question 6 of 30
Q-6.The result of the UNION operation between R1 and R2 is a relation that includes
Your Answer:Correct
Your Answer:Incorrect
Question 7 of 30
Your Answer:Correct
Your Answer:Incorrect
Question 8 of 30
Q-8._________ is a virtual table that draws its data from the result of an SQL SELECT statement.
Your Answer:Correct
Your Answer:Incorrect
Question 9 of 30
Q-9.In a relational model, relations are termed as
Your Answer:Correct
Your Answer:Incorrect
Question 10 of 30
Q-10.The method in which records are physically stored in a specified order according to a key
field in each record is
Your Answer:Correct
Your Answer:Incorrect
Question 11 of 30
Q-11.The physical location of a record is determined by a mathematical formula that trAnsforms
a file key into a record location is :
Your Answer:Correct
Your Answer:Incorrect
Question 12 of 30
Q-12.The way a particular application views the data from the database that the application
uses is a
Your Answer:Correct
Your Answer:Incorrect
Question 13 of 30
Q-13.An entity set that does not have sufficient attributes to form a primary key is a
Your Answer:Correct
Your Answer:Incorrect
Question 14 of 30
Q-14.The language which has recently become the defacto standard for interfacing application
programs with relational database system is
Your Answer:Correct
Your Answer:Incorrect
Question 15 of 30
Q-15.Which of the operations constitute a basic set of operations for manipulating relational
data?
Your Answer:Correct
Your Answer:Incorrect
Question 16 of 30
Q-16.In E-R Diagram relationship type is represented by
Your Answer:Correct
Your Answer:Incorrect
Question 17 of 30
Q-17.Count function in SQL returns the number of
Your Answer:Correct
Your Answer:Incorrect
Question 18 of 30
Q-18.Relational calculus is a
Your Answer:Correct
Your Answer:Incorrect
Question 19 of 30
Q-19._____________ function divides one numeric expression by another and returns the
remainder
Your Answer:Correct
Your Answer:Incorrect
Question 20 of 30
Q-20.Related fields in a database are grouped to form a
Your Answer:Correct
Your Answer:Incorrect
Question 21 of 30
Q-21.In an E-R diagram an entity set is represent by a
Your Answer:Correct
Your Answer:Incorrect
Question 22 of 30
Q-22.Which of the following is a legal expression in SQL?
Your Answer:Correct
Your Answer:Incorrect
Question 23 of 30
Q-23.The method in which records are physically stored in a specified order according to a key
field in each record is
Your Answer:Correct
Your Answer:Incorrect
Question 24 of 30
Q-24.Which of the following is an advantage of view?
Your Answer:Correct
Your Answer:Incorrect
Question 25 of 30
Q-25.A relational database developer refers to a record as
Your Answer:Correct
Your Answer:Incorrect
Question 26 of 30
Q-26.Which of the following is another name for weak entity?
Your Answer:Correct
Your Answer:Incorrect
Question 27 of 30
Q-27.A set of possible data values is called
Your Answer:Correct
Your Answer:Incorrect
Question 28 of 30
Q-28.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 29 of 30
Q-29.In case of entity integrity, the primary key may be
Your Answer:Correct
Your Answer:Incorrect
Question 30 of 30
Q-30.Data independence meAns
Your Answer:Correct
Your Answer:Incorrect