Home / 11th(ENG) - GSEB Board / Reading Mode

📖 Reading Mode: 11th(ENG) - GSEB Board

Chapter: Retrieving Data Using Queries • Total: 12 MCQs

MCQ 1 Defining Query

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

A Table
B Query
C Constraint
D Relation
MCQ 2 Defining Query

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

A Table
B Query
C Form
D Report
MCQ 3 Defining Query

Which of the following is not aggregate function?

A Square root
B Sum
C Min
D Max
MCQ 4 Defining Query

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
MCQ 5 Defining Query

Which of the following statement is true?

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.
MCQ 6 Defining Query

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.
MCQ 7 Defining Query

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

A “ (double quote)
B ‘(single quote)
C $ (dollar)
D # (hash)
MCQ 8 Defining Query

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

A Like
B is
C equal
D =
MCQ 9 Defining Query

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

A &
B +
C –
D *
MCQ 10 Defining Query

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
MCQ 11 Defining Query

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

A Comma
B Colon
C Question mark
D Explanation mark
MCQ 12 Defining Query

SQL stands for?

A Simple Query Language
B Structured Query Language
C Simple Question for large databases
D Structured queries for large databases