CBSE Class 11 Computer Science Retrieve Data Using Queries MCQs

Question : ______ calculations helps in performing calculations on group of records.

a) Absolute

b) Predefined

c) Calculations

d) Custom

Answer : Predefined

Question : In the '_____' row of the query design grid, the drop down menu contains predefined functions like sum, average, count.

a) Function

b) Maximum

c) Criterion

d) Field

Answer : Function

Question : The functions like count, sum etc are used only for________ purpose only.

a) Result

b) Calculation

c) Performing

d) Display

Answer : Display

Question : ________ queries are designed to accept values from the user at run time.

a) Special

b) Fixed

c) Parameter

d) Retrieving

Answer : Parameter

Question : All queries, other than Parameter query have ____ criterion.

a) Special

b) Fixed

c) Temporary

d) Displayed

Answer : Fixed

Question : Creating a table in Base using _______ gives more flexibility and control.

a) SQL

b) Design View

c) Wizard

d) Functions

Answer : SQL

Question : ______ is a standard language used to query a relational database.

a) SQL

b) Design View

c) Wizard

d) Functions

Answer : SQL

Question : The SQL queries are in the form of _______

a) Commands

b) Statements

c) List

d) Functions

Answer : Statements

Question : The SQL option can be found under _______ menu.

a) File

b) Edit

c) Tools

d) Help

Answer : Tools

Question : The dialog box for writing SQL statements is called _______.

a) Text for SQL Commands dialog box

b) Execute SQL Statement dialog box

c) Statements for SQL dialog box

d) Command to Execute dialog box

Answer : Execute SQL Statement dialog box

Question : The above dialog box gets opened with a cursor blinking under the label _______.

a) Text for SQL commands

b) Execute SQL statement

c) Statements for SQL

d) Command to execute

Answer : Command to execute

Question : In SQL language attention has to be paid to quote signs, capitalization and ________ to avoid errors.

a) Symbols

b) Punctuation marks

c) Syntax

d) Special signs

Answer : Syntax

Question : The SQL statements are written in a _____

a) Text box

b) List box

c) Combo box

d) Data grid Answer

Answer : Text box

Question : The name of the table is ____

a) Scheme lD

b) Scheme

c) Integer

d) Key

Answer : Scheme

Question : ________ is the Primary key.

a) Scheme lD

b) Scheme

c) Integer

d) Key

Answer : Scheme lD

Question : After entering the instructions in the text box, the ________ button gets highlighted.

a) Cancel

b) OK

c) Help

d) Execute

Answer : Execute

Question : Once the table has been created using SQL statements, go to View Menu and click _____tables to view a complete list of the tables.

a) Update

b) Renew

c) Refresh

d) Revise

Answer : Refresh

Question : The _______ TABLE statement is used to remove a table.

a) DROP

b) REMOVE

c) DELETE

d) ERASE

Answer : DROP

Question : To retrieve information from a table using SQL statements, go to the top panel under the label ________.

a) Create

b) Execute SQL

c) Tasks

d) Tools

Answer : Tasks

Question : The SQL statement "SELECT * from Employee" will display complete detail of all the employees stored in the _______ table.

a) SELECT

b) Employee

c) Previous

d) All of these

Answer : Employee

Question : In the Statement "DROP TABLE Scheme IF EXISTS;"_______ is the table name.

a) DROP

b) Scheme

c) IF

d) EXISTS

Answer : Scheme

Question : Right Click on any query to find an option _______ .to view the query.

a) Edit in help view

b) Edit in structured view

c) Edit in SQL view

d) Edit

Answer : Edit in SQL view

Question : The keyword ________ is used to indicate that output needs to be sorted on a field.

a) ORDER BY

b) WHERE

c) ASC

d) AS

Answer : ORDER BY

Question : The keyword ___ is used to retrieve the records based on criteria.

a) ORDER BY

b) WHERE

c) ASC

d) AS

Answer : WHERE

Question : The keyword _____ mentions that data should be sorted in ascending order.

a) ORDER BY

b) WHERE

c) ASC

d) AS

Answer : ASC

Question : The criterion parameter must be preceded by a________ symbol.

a) Semi Colon

b) Full Stop

c) Single Quote

d) Colon

Answer : Colon

Question : "Get the sum of option is available under ______functions.

a) Total

b) Aggregate

c) Combined

d) Collected

Answer : Aggregate

Question : The seventh step of the Query Wizard is _______.

a) Aliases

b) Grouping

c) Sorting Order

d) Overview

Answer : Aliases

Question : ASC in Sorting order stands for _____ order.

a) Accent

b) ASCII

c) Ascending

d) Assess

Answer : Ascending

Question : The fifth step of the Query Wizard is ______.

a) Aliases

b) Grouping

c) Sorting order

d) Overview

Answer : Grouping

Question : _______means asking questions, doing inquiry or performing analysis.

a) Query

b) Question

c) Doubt

d) Inquiry

Answer : Query

Question : In Base, to query is to ask a question about the information in the________

a) Table

b) Database

c) Recto

d) Reports

Answer : Database

Question : Through a _____ Base can display exactly the fields and records a person would like to view from database.

a) Query

b) Question

c) Doubt

d) Inquiry

Answer : Query

Question : A Query is a set of rules for fetching information from a _______ or several tables at once

a) Reports

b) Database

c) Table

d) Records

Answer : Table

Question : A Query consists of, a set of ________ organized in rows and columns.

a) Reports

b) Database

c) Table

d) Records

Answer : Records

Question : To create a query, open a database and click on the icon labeled as ____ in the left hand pane.

a) Queries

b) Tables

c) Forms

d) Reports

Answer : Queries

Question : Different ways to create a query is shown in the ____ pane displayed on the top

a) Top

b) Tasks

c) Left

d) Right

Answer : Tasks

Question : Base offers _____ different ways to create a query

a) One

b) Two

c) Three

d) Four

Answer : Three

Question : The creating a query in _______ provides I minimum amount of guidance.

a) Wizard view

b) SQL view

c) Query view

d) Design view

Answer : Design view

Question : A _____ guides through the process of que:1 creation.

a) Wizard

b) Database

c) Query

d) Design view

Answer : Wizard

Question : Creating Query in _____ provides no guidance at all

a) Wizard view

b) SQL view

c) Query view

d) Design view

Answer : SQL view

Question : SQL is a _______ generation language.

a) First

b) Second

c) Third

d) Fourth

Answer : Fourth

Question : Full form of SQL is ________.

a) Structured Question Language

b) Spontaneous Question Language

c) Structured Query Language

d) None of these

Answer : Structured Query Language

Question : Base's _______ has the advantage of helping to organize and requires no previous knowledgeable.

a) Query wizard

b) Data wizard

c) SQL Wizard

d) Expert Wizard

Answer : Query wizard

Question : In the Query Creation Wizard, there are . steps to create a query.

a) Eight

b) Seven

c) Six

d) Five

Answer : Eight

Question : From all the steps of the Query Crea~ Wizard, only the ____ selection step compulsory.

a) Table

b) Field

c) Query

d) All of these

Answer : Field

Question : The fields that are finally selected to be a part to the query will be listed under “filed in the _____” list box.

a) Table

b) Field

c) Query

d) All of these

Answer : Query

Question : The second step in the Query creation wizard is to mention the  ____ order of the query.

a) Systematic

b) Sort

c) Relative

d) None of these

Answer : Sort

Question : In the ______ step in the Query creation wizard is to set up the query

a) First

b) Second

c) Third

d) Fourth

Answer : Third

Question : In the third step of the Query creation wizard, appropriate values have to be selected for the field, the condition and the ______ parameters.

a) Value

b) Important

c) Conditional

d) Maximum

Answer : Value

Question : In case the selected table does not contain any numeric field, options to summarize or perform numerical calculations are ____

a) Merged

b) Included

c) Bounded

d) Skipped

Answer : Skipped

Question : In the seventh step of the Query creation wizard, Base expects _____ for selected field names.

a) Automatic names

b) Aliases

c) Different names

d) Same names

Answer : Aliases

Question : The seventh step of the Query creation wizard is _____

a) Compulsory

b) Optional

c) Both (A) and (B)

d) None of these

Answer : Optional

Question : If the user does not add ____ then field names of table will be displayed as it is in a query.

a) Automatic names

b) Aliases

c) Different names

d) Same names

Answer : Aliases

Question : The eighth step of the Query creation wizard, an _____ of all the steps performed is given.

a) Overview

b) Impression

c) Indication

d) Inclination

Answer : Overview

Question : A desired name can be given to the query, in the text box labeled "___ ".

a) Query name

b) Query details

c) Name of the query

d) Name

Answer : Name of the query

Question : ____ views are used to create complicated query.

a) Wizard

b) Over

c) Modify

d) Design

Answer : Design

Question : Base allows users to make use of a query already created for creating another ____ .

a) Table

b) Field

c) Query

d) All of these

Answer : Query

Question : The _______ symbol is used to move fields to "Fields in the Query" list box.

a) [>>]

b) 1 « 1

c) [T]

d) \T]

Answer : [T]

Question : The label “sort by” is listed in a drop down______.

a) Box

b) List

c) Table

d) Catalog

Answer : Box

Question : "Get the sum of option is available under _______ functions.

a) Total

b) Aggregate

c) Combined

d) Collected

Answer : Aggregate

Question : The fifth step of the Query Wizard is _____

a) Aliases

b) Grouping

c) Sorting order

d) Overview

Answer : Grouping

Question : The seventh step of the Query Wizard is _______.

a) Aliases

b) Grouping

c) Sorting Order

d) Overview

Answer : Aliases

Question : ASC in Sorting order stands for____ order.

a) Accent

b) ASCII

c) Ascending

d) Assess

Answer : Ascending

Question : To execute a query click on the ____ query button.

a) Walk

b) Stroll

c) Jog

d) Run

Answer : Run

Question : The "Add Table or Query button" is located on the Query design_________.

a) Toolbar

b) Task bar

c) Format bar

d) Table bar

Answer : Toolbar

Question : ______ click on the table to add tables or queries from the "Add table or Query" dialog box.

a) Right

b) Left

c) Single

d) Double

Answer : Double

Question : The default value of "Visible" (record headings) is set to be...........

a) True

b) False

c) Left

d) Right

Answer : True

Question : To display only a of selected records, Base helps in specifying a criterion that limits the records.

a) Subset

b) Limit

c) Few

d) Little

Answer : Subset

Question : The Text for the Criterion cell must be enclosed within a quotation _____

a) Set

b) Delimiter

c) Enclosed

d) Bounded

Answer : Delimiter

Question : The Date for the Criterion cell must be enclosed in the ______ delimiter.

a) $

b) #

c) ##

d) '

Answer : #

Question : The_____ literals for the Criterion cell do not need any delimiters.

a) Text

b) Date

c) Number

d) Error

Answer : Number

Question : If the user misses using delimiters in the Criterion cell, Base does not report any ________.

a) Text

b) Date

c) Number

d) Error

Answer : Error

Question : Base allows designing expression for defining criteria using different types of________.

a) Symbols

b) Operators

c) Views

d) Expressions

Answer : Operators

Question : =, >, <, >=, <=, <> are _____ operators.

a) Comparison

b) Logical

c) Special

d) Mathematical

Answer : Comparison

Question : The syntax for displaying Date which is greater than 1st June 2011, in the Criterion cell is _______.

a) "<#01/06/2011#"

b) "<#01/06/2011"

c) ">01/06/2011#"

d) ">#01/06/2011#"

Answer : ">#01/06/2011#"

Question : Like, Is, Between, In are _______ operators.

a) Comparison

b) Logical

c) Special

d) Mathematical

Answer : Special

Question : And, Or, Not are _______ operators.

a) Comparison

b) Logical

c) Special

d) Mathematical

Answer : Logical

Question : The syntax for displaying Date which is between 1st June 2005 and 1st Nov 2012, in the Criterion cell is

a) ">=# 1/6/2005 # And <= # 11/1/2012 #"

b) "<=# 1/6/2005 # And <= # 11/1/2012 #"

c) ">=# 1/6/2005 # And >= # 11/1/2012 #"

d) "># 1/6/2005 # And < # 11/1/2012 #"

Answer : ">=# 1/6/2005 # And <= # 11/1/2012 #"

Question : NOT IN('Ahmadabad';'Patna') in the Criterion row of a City field will retrieve customers from all places except _______

a) Ahmadabad

b) Patna

c) Ahmadabad or Patna

d) None of these

Answer : Ahmadabad or Patna

Question : Use 'Ahmadabad' _____ 'Patna' operator in Criterion cell will display either Ahmadabad and Patna.

a) OR

b) IN

c) NOT

d) AND

Answer : AND

Question : No check mark in a field signifies the value is ____ and that it is empty.

a) Zero

b) Null

c) Empty

d) None of these

Answer : Null

Question : "Is Not Empty" in the ___ row signifies that the field displayed should not be NULL.

a) Criterion

b) AND

c) OR

d) Function

Answer : OR

Question : _________ symbol is a Wild Character.

a) $

b) *

c) #

d) @

Answer : *

Question : A _____ is a symbol that represents any character or combination of characters.

a) Special character

b) Wild symbol

c) Card

d) Wild Card

Answer : Wild Card

Question : _______ represents a word whose first two alphabets are 'hp', followed by any group of characters.

a) hp*

b) hp?

c) *hp

d) ?hp

Answer : hp*

Question : ______*hp' will display products with names ending with alphabets 'hp'.

a) Unlike

b) Like

c) Same

d) Similar

Answer : Like

Question : ________ and ending with alphabets 'hp'.

a) Starting

b) Finishing

c) Opening

d) Concluding

Answer : Starting

Question : _____ operator must be included with the wild card characters.

a) Unlike

b) Like

c) Same

d) Similar

Answer : Like

Question : Calculations within a query in Base can be performed using_____ ways.

a) One

b) Two

c) Three

d) Four

Answer : Two

Question : calculations includes performing numeric, date and text calculations.

a) Custom

b) Predefined

c) Systematic

d) Defined

Answer : Custom

Question : ____ calculations include operations like add, multiply, subtract or divide the values in two different fields.

a) Custom

b) Predefined

c) Systematic

d) Defined

Answer : Custom

Question : To perform custom calculations,there is a need to add an extra field known as ____ field.

a) Absolute

b) Predefined

c) Calculated

d) Custom

Answer : Calculated

Question : _______ calculations means summarizing the data.

a) Absolute

b) Predefined

c) Calculations

d) Custom

Answer : Predefined

Question : In the above figure Country lD of the Country table is known as the________ field.

a) Referenced

b) Referencing

c) Main

d) Refer

Answer : Referenced

Question : In the above figure, Country lD of the State table is known as the_______field.

a) Referenced

b) Referencing

c) Main

d) Refer

Answer : Referencing

Question : Master records can also be called _______ records.

a) Child

b) Children

c) Transaction

d) Parent

Answer : Parent

Question : Transaction records can also be called ____ records.

a) Child

b) Children

c) Teacher

d) Parent

Answer : Child

Question : The Relationship line becomes _______ when selected, which helps in Editing the relationship.

a) Visible

b) Invisible

c) Thickened

d) Thin

Answer : Thickened

Question : A Class and Class Teacher is an example of _________ relationship.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : One to One

Question : The most common type of relationship between the tables is ________.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : One to Many

Question : Class Teacher and Student is an example of _______ relationship.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : One to Many

Question : To define a field for any table, _____ had to be performed.

a) Specify a field name

b) Choose a proper data type

c) Write Description

d) All of these

Answer : All of these

Question : An employee with multiple designations or a single designation belonging to multiple employees is an example of ____ relationship.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : Many to Many

Question : Data_______ restricts the values entered in a particular field.

a) Checking

b) Validation

c) Confirmation

d) Restriction

Answer : Validation

Question : The Text data type for a particular field is automatically takes the predefined size of ______

a) 30

b) 40

c) 50

d) 60

Answer : 50

Question : Base automatically assigns some predefined field size to ____ data types.

a) Numeric

b) Date/Time

c) Yes/No

d) All of these

Answer : All of these

Question : The _______ property determines whether the user must enter a value for a particular field to complete record entry.

a) Entry Required

b) Auto Value

c) Length

d) Default value

Answer : Entry Required

Question : When a user runs a Parameter query there will be a display of a ____box

a) List box

b) Combo box

c) Text box

d) Dialog box

Answer : Dialog box

Question : The values entered as parameters get assigned as _____ values for retrieving data.

a) Fixed

b) Criterion

c) Variable

d) Parameter

Answer : Criterion