MCQ 1 To duplicate a controls formatting you can use ________________.

Correct Answer Choice C Painter
See Answer

MCQ 2 In table design view, what are the first column of buttons used for?

Correct Answer Choice C Both of above
See Answer

MCQ 3 Which of the following statement is true?

Correct Answer Choice C In an indexed field you may or may not enter duplicate value depending upon setting
See Answer

MCQ 4 A composite key is

Correct Answer Choice C Made up of two or more fields to uniquely identify records
See Answer


MCQ 5 Which of the following is not a database application?

Correct Answer Choice B Flash
See Answer

MCQ 6 The report footer section is most useful for displaying

Correct Answer Choice A Grand totals
See Answer

MCQ 7 What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?

Correct Answer Choice B Instance
See Answer

MCQ 8 The database schema is written in

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


MCQ 9 Transaction processing is associated with everything below except

Correct Answer Choice C confirming an action or triggering a response
See Answer

MCQ 10 The method of access which uses key transformation is known as

Correct Answer Choice B hash
See Answer

MCQ 11 Which of the following is an advantage of view?

Correct Answer Choice D All of the above
See Answer

MCQ 12 Which of the operations constitute a basic set of operations for manipulating relational data?

Correct Answer Choice C Relational algebra
See Answer


MCQ 13 A primary key is combined with a foreign key creates

Correct Answer Choice A Parent-Child relationship between the tables that connect them
See Answer

MCQ 14 A data manipulation command the combines the records from one or more tables is called

Correct Answer Choice C JOIN
See Answer

MCQ 15 In E-R diagram generalisation is represented by

Correct Answer Choice D Triangle
See Answer

MCQ 16 Which of the following is not Constraint in SQL?

Correct Answer Choice D Union
See Answer


MCQ 17 Which of the following is a sql AGGREGATE Function

Correct Answer Choice B AVG
See Answer

MCQ 18 The COUNT function in SQL returns the number of ______________.

Correct Answer Choice A Values
See Answer

MCQ 19 What is the full form of sql?

Correct Answer Choice B Structured Query Language
See Answer

MCQ 20 A table joined with itself is called

Correct Answer Choice B Self Join
See Answer


MCQ 21 SET concept is used in

Correct Answer Choice A Network Model
See Answer

MCQ 22 ___________ produces the relation that has attributes of R1 and R2

Correct Answer Choice A Cartesian product
See Answer

MCQ 23 Cartesian product in relational algebra is

Correct Answer Choice B A Binary operator
See Answer

MCQ 24 The subset of a super key is a candidate key under what condition?

Correct Answer Choice A No proper subset is a super key
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