MCQ 1 Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

Correct Answer Choice B ID
See Answer

MCQ 2 The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called _____________.

Correct Answer Choice B Referencing relation
See Answer

MCQ 3 In order to undo the work of transaction after last commit which one should be used?

Correct Answer Choice C Rollback
See Answer

MCQ 4 Transaction processing is associated with everything below except

Correct Answer Choice A Conforming an action or triggering a response
See Answer


MCQ 5 Which of the following is used to get back all the transactions back after rollback?

Correct Answer Choice C Flashback
See Answer

MCQ 6 In case of entity integrity, the primary key maybe

Correct Answer Choice A Not Null
See Answer

MCQ 7 In case of any shut down during transaction before commit which of the following statement is done automatically?

Correct Answer Choice C Rollback
See Answer

MCQ 8 The deadlock in a set of a transaction can be determined by

Correct Answer Choice A Read-only graph
See Answer


MCQ 9 An entity set that does not have sufficient attributes to form a primary key is termed a _____________.

Correct Answer Choice C Weak entity set
See Answer

MCQ 10 After right click the field selector button, which do you choose to delete a field in design view?

Correct Answer Choice B Delete rows
See Answer

MCQ 11 How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data

Correct Answer Choice B Look up Wizard
See Answer

MCQ 12 Which is not a view to display a table in Access?

Correct Answer Choice D None of above
See Answer


MCQ 13 DCL (Data Control Language) provides commands to perform actions like.

Correct Answer Choice C Authorizing access and other control over database
See Answer

MCQ 14 What do you mean by one to many relationship between Student and Class table?

Correct Answer Choice A One student can have many classes
See Answer

MCQ 15 An organized collection of logically related data is known as

Correct Answer Choice C Database
See Answer

MCQ 16 Which of the following is invalid field name?

Correct Answer Choice A Student.Address
See Answer


MCQ 17 A system is in a ___________________ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.

Correct Answer Choice C Deadlock
See Answer

MCQ 18 Relational calculus is a

Correct Answer Choice B Non- Procedural language.
See Answer

MCQ 19 DML is provided for

Correct Answer Choice C Manipulation & processing of the database
See Answer

MCQ 20 Which one of the following cannot be taken as a primary key?

Correct Answer Choice D Street
See Answer


MCQ 21 The DBMS language component which can be embedded in a program is

Correct Answer Choice B The data manipulation language (DML)
See Answer

MCQ 22 The method in which records are physically stored in a specified order according to a key field in each record is

Correct Answer Choice A hash
See Answer

MCQ 23 An advantage of the database management approach is

Correct Answer Choice C data is integrated and can be accessed by multiple programs.
See Answer

MCQ 24 Which leads you through the process of creating a table?

Correct Answer Choice A Wizard
See Answer


MCQ 25 In a datasheet, what does each column represent?

Correct Answer Choice B Field
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