MCQ 1 Database Management Systems are featured with

Correct Answer Choice B The ability to store large amount of data to facilitate easy update, sort and retrieval
See Answer

MCQ 2 Which of the following may not be a database?

Correct Answer Choice C A presentation created in Microsoft Power Point
See Answer

MCQ 3 What do you call a collection of records matching parameters of a query?

Correct Answer Choice D Dynaset
See Answer

MCQ 4 Which query do you use to answer the question "What is the average salary of the employees"?

Correct Answer Choice C Select query
See Answer


MCQ 5 A ________________ consists of a sequence of query and/or update statements.

Correct Answer Choice A Transaction
See Answer

MCQ 6 _______________ rollback requires the system to maintain additional information about the state of all the running transactions.

Correct Answer Choice B Partial
See Answer

MCQ 7 What does Rollback do?

Correct Answer Choice A Undoes the transactions
See Answer

MCQ 8 A database object in MS Access that stores a question about the data in database?

Correct Answer Choice C Query
See Answer


MCQ 9 If you need to edit a relationship, you can do.

Correct Answer Choice C Both of above
See Answer

MCQ 10 In an E-R diagram an entity set is represent by a

Correct Answer Choice A rectangle
See Answer

MCQ 11 The relational model feature is that there

Correct Answer Choice B is much more data independence than some other database models.
See Answer

MCQ 12 Which of the following is correct.

Correct Answer Choice D None of the these
See Answer


MCQ 13 Which of the following is a valid SQL type?

Correct Answer Choice D All of the above
See Answer

MCQ 14 Which of the following operations need the participating relations to be union compatible?

Correct Answer Choice D All of the above
See Answer

MCQ 15 It is better to use files than a DBMS when there are

Correct Answer Choice B Multiple users wish to access the data.
See Answer

MCQ 16 Which of the following operation is used if we are interested in only certain columns of a table?

Correct Answer Choice A PROJECTION
See Answer


MCQ 17 The conceptual model is

Correct Answer Choice D independent of both hardware and software
See Answer

MCQ 18 Which one of the following statements is false?

Correct Answer Choice B Data elements in the database can be modified by changing the data dictionary.
See Answer

MCQ 19 In the architecture of a database system external level is the

Correct Answer Choice D view level
See Answer

MCQ 20 In an E-R diagram attributes are represented by

Correct Answer Choice C ellipse
See Answer


MCQ 21 Related fields in a database are grouped to form a

Correct Answer Choice B data record
See Answer

MCQ 22 An entity set that does not have sufficient attributes to form a primary key is a

Correct Answer Choice B weak entity set
See Answer

MCQ 23 The deadlock state can be changed back to stable state by using _______________ statement.

Correct Answer Choice B Rollback
See Answer

MCQ 24 The Rectangles divided into two parts represents

Correct Answer Choice A Entity set
See Answer


MCQ 25 The entity relationship set is represented in E-R diagram as

Correct Answer Choice D Diamond
See Answer

Advantages Of NCERT, CBSE & State Boards Solutions For All Subjects

  • All the NCERT Solutions have been prepared by academic experts having 10+ years of teaching experience.
  • They have prepared all the solutions in simple and easy language, so that each and every student can understand the concepts easily.
  • All the solutions have been explained step to step wise in details with better explainations.
  • Students can also use these question and answers for your assignments and in homework help.
  • All the solutions have been explained in detail and the answers have been compiled in a step-wise manner.
  • All the question and asnwers are commonly prepared according to the Latest Syllabus of Board Education and Guidelines.
  • Students can know about the various types of questions asked in the exams with the help of these solutions.

Top Course Categories