Computer Textbook MCQ Solutions Class 11 

CH-11: Retrieving Data Using Tables

1.       The result of a select query is generally represented as which of the following components?

a.       Table

b.      Query

c.       Constraint

d.      Relation

2.       Which of the following feature of Base is used to retrieve specific information from the database?

a.       Table

b.      Query

c.       Form

d.      Report

3.       Which of the following is not an aggregate function?

a.       Square root

b.      Sum

c.       Min

d.      Max

4.       Which of the following is used to group the result of a query?

a.       Order by

b.      Group by

c.       Arrange by

d.      Set of

5.       Which of the following statement is false?

a.       Query can be stored as an object in database and reused.

b.      Query is written to be used only once.

c.       Query cannot be created using wizard.

d.      Query cannot be written on a query.

6.       What is an alias?

a.       Alias is creation of duplicate query.

b.      Alias is used to give meaningful name to fields selected in a query.

c.       Alias is used to print query.

d.      Alias is nowhere related to query.

7.       Which delimiter is used to surround the text in a query criterion?

a.       “ (double quote)

b.      ‘(single quote)

c.       $ (dollar)

d.      # (hash)

8.       Which of the following operator is used with wild card character?

a.       Like

b.      is

c.       equal

d.      =

9.       Which of the following operator is used as wild card character in Base?

a.       &

b.      +

c.       –

d.      * 

10.   Which query, when run, displays a dialog box asking to enter the value to match the criteria for retrieving the data?

a.       Select Query

b.      Insert Query

c.       Parameter Query

d.      Update query

11.   The Parameter name in parameter query is preceded by which symbol?

a.       Comma

b.      Colon

c.       Question mark

d.      Explanation mark

12.   SQL stands for?

a.       Simple Query Language

b.      Structured Query Language

c.       Simple Question for large databases

d.      Structured queries for large databases