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