MCQ 1 Which of the field has width 8 bytes?

Correct Answer Choice C Date/Time
See Answer

MCQ 2 What is the size of Yes, No field?

Correct Answer Choice A 1 bit
See Answer

MCQ 3 Which key is uniquely identifies each record?

Correct Answer Choice A Primary Key
See Answer

MCQ 4 When you create or open the MS Access database file, command center of access file that appears

Correct Answer Choice D Switchboard
See Answer


MCQ 5 If your entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

Correct Answer Choice D Select the third row in table design view then Delete it.
See Answer

MCQ 6 Which field type will you select when creating a new table if you require to enter long text in that field?

Correct Answer Choice B Memo
See Answer

MCQ 7 To create queries in Access, what steps you do.

Correct Answer Choice D All of the above
See Answer

MCQ 8 What is a form in MS Access?

Correct Answer Choice B It is an input screen designed to make the viewing and entering data easier
See Answer


MCQ 9 It is a database object to view, change, and analyze data in different ways.

Correct Answer Choice A query
See Answer

MCQ 10 Both conditions display on the same row in the design grid when _________________ operator is in use.

Correct Answer Choice C AND
See Answer

MCQ 11 Which of the following is not a field type in Access?

Correct Answer Choice D Lookup Wizard
See Answer

MCQ 12 A search value can be an exact value or it can be.

Correct Answer Choice C Wild card character
See Answer


MCQ 13 Which of the following is not a database object in MS Access?

Correct Answer Choice D Relationship
See Answer

MCQ 14 Which of the following expresses correct order?

Correct Answer Choice A Characters, Fields, Records, Tables, Files, Databases
See Answer

MCQ 15 The complete information about an entity in a database is called

Correct Answer Choice D Record
See Answer

MCQ 16 In a datasheet, what does each row represent?

Correct Answer Choice A Record
See Answer


MCQ 17 In databases, Locking level is also called as

Correct Answer Choice A Granularity
See Answer

MCQ 18 To create primary key for a table when in design view

Correct Answer Choice C Click the Primary Key button in Design ribbon when the cursor is in required field
See Answer

MCQ 19 What is the full form of SQL?

Correct Answer Choice C Structured Query Language
See Answer

MCQ 20 Which of the following is not a view for interacting with a form object?

Correct Answer Choice D Layout view
See Answer


MCQ 21 A ____________ is a unit of information in a _____________.

Correct Answer Choice B field, record
See Answer

MCQ 22 Which type of field is incremented automatically?

Correct Answer Choice B AutoNumber
See Answer

MCQ 23 Which data type is better to use for storing phone number in the following format - 111-2-1234567?

Correct Answer Choice A Text
See Answer

MCQ 24 What is the purpose of indexing?

Correct Answer Choice B To speedup data search
See Answer


MCQ 25 What do you call a primary key field included in another table?

Correct Answer Choice A Foreign key
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