MCQ 1 Which of the following gives a logical structure of the database graphically?

Correct Answer Choice A Entity-relationship diagram
See Answer

MCQ 2 Query can be use to select data from

Correct Answer Choice C Both A and B
See Answer

MCQ 3 Which tool is used to generate printout of a table's structure?

Correct Answer Choice C Documenter
See Answer

MCQ 4 Which do you click to display the table’s primary key and indexes in a separate window?

Correct Answer Choice A indexes button
See Answer


MCQ 5 Which query do you use for "Which employees earn more than Rs.5000 a month"?

Correct Answer Choice C Select query
See Answer

MCQ 6 What is the result of the query "Select * from customer where c_id>10 and c_id<100".

Correct Answer Choice D Display all customers with c_id from 11 to 99
See Answer

MCQ 7 After creating the table which of the following is correct?

Correct Answer Choice D Fields can added and deleted as needed
See Answer

MCQ 8 Primary key is

Correct Answer Choice D All of the above
See Answer


MCQ 9 The basic elements of a form or a report are called

Correct Answer Choice A Controls
See Answer

MCQ 10 In a table to insert User's Voice, Data field should be

Correct Answer Choice A OLE Object
See Answer

MCQ 11 We indicate roles in E-R diagrams by labeling the lines that connect ________________ to ______________.

Correct Answer Choice D diamond, rectangle
See Answer

MCQ 12 You can automatically include all of the field in a table in a query by ______________ a strike that appear list box in query design view.

Correct Answer Choice C Double clicking
See Answer


MCQ 13 What does the show check box in query design window indicate?

Correct Answer Choice B It indicates whether the field is to be displayed in query result or not
See Answer

MCQ 14 Which of the following database object hold data?

Correct Answer Choice D Tables
See Answer

MCQ 15 A __________ enables you to view data from a table based on a specific criterion.

Correct Answer Choice B Query
See Answer

MCQ 16 It is a sign or symbol that specifies, operator, and values that produce a result is an __________________.

Correct Answer Choice A operator
See Answer


MCQ 17 What is the maximum length a text field can be?

Correct Answer Choice B 255
See Answer

MCQ 18 If you write criteria values vertically (one in a row) it will mean.

Correct Answer Choice A OR conditions
See Answer

MCQ 19 Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called.

Correct Answer Choice D Primary key
See Answer

MCQ 20 How many relations may exist between tables in databases?

Correct Answer Choice B 3
See Answer


MCQ 21 Which is not a view for displaying a report object?

Correct Answer Choice A Datasheet view
See Answer

MCQ 22 What is an intersection of a row and a column?

Correct Answer Choice C Cell
See Answer

MCQ 23 Collection of related records in a database is known as

Correct Answer Choice C Table
See Answer

MCQ 24 A database can be best described as

Correct Answer Choice A Organized collection of data
See Answer


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

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