MCQ 1 Which of the following is not a type of relationship that can be applied in access database.

Correct Answer Choice D All of the above can be applied
See Answer

MCQ 2 How to achieve AND effect when you are entering criteria in a query design window.

Correct Answer Choice B Write criteria values horizontally
See Answer

MCQ 3 How to create a relationship between two tables in database.

Correct Answer Choice A Drag the primary key of a table into foreign key of another table
See Answer

MCQ 4 The task of arranging data in order is called

Correct Answer Choice B Sorting
See Answer

MCQ 5 Validation Rule in a field will

Correct Answer Choice A Checks the value entered when user leaves the field
See Answer

MCQ 6 For a weak entity set to be meaningful, it must be associated with another entity set, called the?

Correct Answer Choice A Identifying set
See Answer

MCQ 7 Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

Correct Answer Choice A Candidate key
See Answer

MCQ 8 Which of the following makes the transaction permanent in the database?

Correct Answer Choice B Commit
See Answer

MCQ 9 A deadlock exists in the system if and only if the wait-for graph contains a ___________

Correct Answer Choice A Cycle
See Answer

MCQ 10 Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is

Correct Answer Choice D How many more data items the transaction needs for it to complete
See Answer

MCQ 11 Which one of the following attribute can be taken as a primary key?

Correct Answer Choice C Id
See Answer

MCQ 12 You have field Gender of type Byte Number. How to limit its value to 0 and 1 only?

Correct Answer Choice C By defining validation rule
See Answer

MCQ 13 In table design view, which key can be used to switch between the field names and properties panels?

Correct Answer Choice D F6
See Answer

MCQ 14 Microsoft Access is an

Correct Answer Choice A Relational Database Management System (RDBMS)
See Answer

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

Correct Answer Choice C AND
See Answer

MCQ 16 Each record is constituted by a number of individual data items which are called

Correct Answer Choice A Fields
See Answer

MCQ 17 Which object is used to create a form?

Correct Answer Choice A Tables and Queries
See Answer

MCQ 18 Which tool do you use to create a query object?

Correct Answer Choice C Simple query wizard
See Answer

MCQ 19 How to make a date field DOB store the dates format like "2002/10/17".

Correct Answer Choice B By setting the format property to "yyyy/mm/dd"
See Answer

MCQ 20 Which control types is most often associated with a bound control?

Correct Answer Choice C Text box
See Answer

MCQ 21 A database language concerned with the definition of the whole database structure and schema is ___________.

Correct Answer Choice C DDL (Data Definition Language)
See Answer

MCQ 22 HSAM stands for ___________.

Correct Answer Choice A Hierarchic Sequential Access Method
See Answer

MCQ 23 Which of the following is the DBMS type

Correct Answer Choice D All of the Above
See Answer

MCQ 24 Relationship can be establish between two tables by

Correct Answer Choice A Drag Primary key of a table into Foreign key of another table
See Answer

MCQ 25 If you were collecting and storing information about your music collection, an album would be considered a(n) _______________.

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