Well-structured Std 11 Computer Textbook MCQ Answers and Std 11 Computer MCQ Answers Ch 11 Retrieving Data Using Queries can serve as a valuable review tool before computer exams.
GSEB Std 11 Computer Chapter 11 MCQ Retrieving Data Using Queries
Question 1.
…………… is a huge collection of data.
(A) Table
(B) Database
(C) Record
(D) Field
Answer:
(B) Database
Question 2.
…………….. can be used to retrieve specific set of information from database.
(A) Query
(B) Form
(C) Report
(D) Macro
Answer:
(A) Query
Question 3.
The user can retrieve data from query according to ……………….. of how it is stored in the database.
(A) the user can retrieve data according to his choice
(B) criteria
(C) format irrespective
(D) all of these
Answer:
(D) all of these
Question 4.
What type of question we can ask by query ?
(A) Give me details of customer who has purchased products worth more than one lakh rupees in the current year
(B) Give me details of product that have not been sold even once
(C) Give me details of students who resides in Ahmedabad and Morbi city
(D) All of these
Answer:
(D) All of these
Question 5.
What is the key reasons to use database management system ?
(A) Ability to design query
(B) Save the query
(C) Use the query as and where required
(D) All of these
Answer:
(D) All of these
Question 6.
Query basically means …………….. .
(A) asking question
(B) doing enquiry
(C) performing analysis
(D) all of these
Answer:
(D) all of these
Question 7.
……………. is to ask a question about the information in the database.
(A) Query
(B) Question
(C) Question bank
(D) Primary key
Answer:
(A) Query
Question 8.
What information is send to Base by query ?
(A) Display exactly which fields a person would like
(B) Display exactly which record a person would like
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 9.
………………… is a set of rules for fetching information from a table or from several table at once.
(A) Form
(B) Query
(C) Table
(D) Report
Answer:
(B) Query
Question 10.
The result of a query displays in a …………….. form.
(A) table
(B) report
(C) form
(D) query
Answer:
(A) table
Question 11.
Query consists of a set of records, organized in …………….. .
(A) rows as per record
(B) columns as per field
(C) both (A) and (B)
(D) none of these
Answer:
(C) both (A) and (B)
Question 12.
To create a query what to do ?
(A) Open a table
(B) Open a database
(C) Open a query
(D) Any one of these
Answer:
(B) Open a database
Question 13.
How many icon is shown in database window ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(C) 4
Question 14.
Which icon is shown in database pane ?
(A) Tables, Queries
(B) Forms, Reports
(C) Macro, Modules
(D) Both (A) and (B)
Answer:
(D) Both (A) and (B)
Question 15.
Queries icon is shown in which side of database window ?
(A) Left
(B) Right
(C) Up
(D) Down
Answer:
(A) Left
Question 16.
The query window is organized like ……………….. .
(A) table window
(B) form window
(C) report window
(D) all of these
Answer:
(D) all of these
Question 17.
By how many types you make a query ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 18.
From the following options which option is used for creating a query ?
(A) Create Query in Design View…
(B) Use Wizard to Create Query
(C) Create Query in SQL View…
(D) All of these
Answer:
(D) All of these
Question 19.
Which side to create a query will be shown in the tasks pane ?
(A) Left
(B) Right
(C) Up
(D) Down
Answer:
(C) Up
Question 20.
Create a query in ………………… provides a minimal amount of guidance.
(A) Create Query in Design View…
(B) Use Wizard to Create Query …
(C) Create Query in SQL View…
(D) All of these
Answer:
(A) Create Query in Design View…
Question 21.
……………. wizard is provided for the query creation.
(A) Create Query in Design View…
(B) Use Wizard to Create Query…
(C) Create Query in SQL View…
(D) All of these
Answer:
(B) Use Wizard to Create Query…
Question 22.
Create query in …………… provides no guidance at all.
(A) Create Query in Design View…
(B) Use Wizard to Create Query….
(C) Create Query in SQL View…
(D) All of these
Answer:
(C) Create Query in SQL View…
Question 23.
To create query in SQL View…. user need to have knowledge about …………. computer language.
(A) first generation
(B) second generation
(C) third generation
(D) fourth generation
Answer:
(D) fourth generation
Question 24.
From the following which language is fourth generation ?
(A) Basic
(B) Fortran
(C) SQL
(D) LOGO
Answer:
(C) SQL
Question 25.
What is the full form of SQL ?
(A) Structured Question Language
(B) Structured Query Language
(C) Structured Quach Language
(D) Structured Quick Language
Answer:
(B) Structured Query Language
Question 26.
If you are database expert, you might prefer ……………. .
(A) Design View
(B) SQL View
(C) Wizard
(D) Both (A) and (B)
Answer:
(D) Both (A) and (B)
Question 27.
……………. view is useful for the user who has no previous knowledge.
(A) Design View
(B) SQL View
(C) Wizard
(D) Both (A) and (B)
Answer:
(C) Wizard
Question 28.
If you have already created some queries then it will be listed under the pane title …………….. .
(A) queries
(B) headers
(C) database
(D) section
Answer:
(A) queries
Question 29.
icon display whom ?
(A) Table
(B) Form
(C) Report
(D) Query
Answer:
(D) Query
Question 30.
How many steps available to create a query in query wizard ?
(A) 6
(B) 7
(C) 8
(D) 9
Answer:
(C) 8
Question 31.
What is the first step of query wizard ?
(A) Field selection
(B) Search conditions
(C) Sorting order
(D) Detail or summary
Answer:
(A) Field selection
Question 32.
…………….. helps us in identifying the fields that are to be displayed in our output.
(A) Detail or summary
(B) Sorting order
(C) Search conditions
(D) Field selection
Answer:
(D) Field selection
Question 33.
What is decided to create a query in first step ?
(A) Select table for query
(B) Select field for query
(C) Arrange field in the order
(D) Both (A) and (B)
Answer:
(D) Both (A) and (B)
Question 34.
In query wizard first step is ……………. .
(A) compulsory
(B) optional
(C) can’t say
(D) none of these
Answer:
(A) compulsory
Question 35.
Which step is compulsory of query wizard ?
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(A) First
Question 36.
…………….. helps us in identifying the fields that are to be displayed in our output.
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(A) First
Question 37.
……………… in creating the query is to select the table and the set of fields in that table from which information is to be retrieved.
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(A) First
Question 38.
How many total list box are shown in Query Wizard in the dialog box ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 39.
Which list box you can see in dialog box of Query Wizard ?
(A) Available fields
(B) Fields in the Query
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 40.
From which list box of Query Wizard you can select your own choice field or all of the fields ?
(A) Fields in the Query
(B) Available fields
(C) Fields in the Database
(D) Presents fields
Answer:
(B) Available fields
Question 41.
The fields that you finally select to be part of your query will be listed under …………….. list box.
(A) fields in the query
(B) available fields
(C) fields in the database
(D) presents fields
Answer:
(A) fields in the query
Question 42.
……………. buttons can be used to move the field from the available fields list box to field in the query list box.
(D) Both (A) and (B)
Answer:
Question 43.
…………….. buttons can be used simultaneously to move fields from the available field list box to field in the query list box.
(D) Both (A) and (B)
Answer:
Question 44.
Fields can be arranged in the order required using ……………. button.
(D) (A) or (B)
Answer:
Question 45.
The field that you finally select to be part of your query will be listed under …………… .
(A) fields in the query
(B) available fields
(C) fields in the database
(D) presents fields
Answer:
(A) fields in the query
Question 46.
What is the second step of query wizard ?
(A) Field selection
(B) Search conditions
(C) Sorting order
(D) Detail or summary
Answer:
(C) Sorting order
Question 47.
…………….. is to mention the sort order.
(A) Detail or summary
(B) Sorting order
(C) Search conditions
(D) Field selection
Answer:
(B) Sorting order
Question 48.
What will be decided in second step to create a query ?
(A) Table selection for query
(B) Field selection for query
(C) Arrange field in order
(D) Both (A) and (B)
Answer:
(C) Arrange field in order
Question 49.
The second step of query wizard is …………… .
(A) compulsory
(B) optional
(C) can’t say
(D) none of these
Answer:
(B) optional
Question 50.
…………… is to mention the sort order in which output at the query will be display.
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(B) Second
Question 51.
It allows you to select up to ………………. fields for deciding the sorting order of output.
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(C) 4
Question 52.
By how many types you can arrange information in sorting order in query wizard ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 53.
By what type you can arrange information in sorting order step in query wizard ?
(A) Ascending
(B) Descending
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 54.
What is the third step of query wizard ?
(A) Field selection
(B) Search conditions
(C) Sorting order
(D) Detail or summary
Answer:
(B) Search conditions
Question 55.
………………. of the wizard we have to select appropriate values for the field.
(A) Detail or summary
(B) Sorting order
(C) Search conditions
(D) Field selection
Answer:
(C) Search conditions
Question 56.
What will be decide in third step of query wizard ?
(A) Select table and field for query
(B) Add condition for searching the field
(C) Arrange field in order
(D) Observation of query
Answer:
(B) Add condition for searching the field
Question 57.
The third step of query wizard is ……………… .
(A) compulsory
(B) optional
(C) can’t say
(D) none of these
Answer:
(B) optional
Question 58.
…………….. step of the wizard we have to select appropriate values for the field, the conditions and the value parameters.
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(C) Third
Question 59.
……………… step of the wizard we actually set up the query.
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(C) Third
Question 60.
……………. step has given facility for value parameters.
(A) First
(B) Second
(C) Third
(D) Fourth
Answer:
(C) Third
Question 61.
What will you choose in third step of query wizard ?
(A) Appropriate value for field
(B) Condition for field
(C) Value parameter for the field
(D) All of these
Answer:
(D) All of these
Question 62.
What is parameter value ?
(A) Parameter
(B) Protometer
(C) Primeter
(D) Prototype
Answer:
(A) Parameter
Question 63.
We can define maximum …………. search conditions in one query.
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 64.
In search engine we observe that we have …………. options in query wizard.
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 65.
Which option is used in search condition steps ?
(A) Match all of the following
(B) Match any of the following
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 66.
If only one search condition is to be set we need to choose …………….. .
(A) Match all of the following
(B) Match any of the following
(C) Both (A) and (B)
(D) None of these
Answer:
(A) Match all of the following
Question 67.
If multiple search condition are to be set, we need to choose ………………. .
(A) Match all of the following
(B) Match any of the following
(C) (A) or (B)
(D) None of these
Answer:
(B) Match any of the following
Question 68.
If the selected table does not contain any numeric field base skips ……………… in its query wizard.
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 69.
If selected table does not contain any numeric field base skips which steps ?
(A) 2, 3, 4
(B) 3, 4, 5
(C) 4, 5, 6
(D) 5, 6, 7
Answer:
(C) 4, 5, 6
Question 70.
What is the fourth step of query wizard ?
(A) Field selection
(B) Search conditions
(C) Sorting order
(D) Detail or summary
Answer:
(D) Detail or summary
Question 71.
Which option is used to get facility of numerical calculations and summarize ?
(A) Detail or summary
(B) Sorting order
(C) Search conditions
(D) Field selection
Answer:
(A) Detail or summary
Question 72.
What is decided in fourth step of Query ?
(A) Arrange field in order
(B) Add condition for searching the field
(C) To summarize and to perform numerical calculations
(D) None of these
Answer:
(C) To summarize and to perform numerical calculations
Question 73.
Fourth step of Query Wizard is …………… .
(A) compulsory
(B) optional
(C) can’t say
(D) none of these
Answer:
(B) optional
Question 74.
How many steps are available in fourth step of query wizard to summarize ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 75.
Which type of query you will decide with aggregate function and query summarize in the fourth step of query wizard ?
(A) Detailed query
(B) Summary query
(C) (A) or (B)
(D) None of these
Answer:
(B) Summary query
Question 76.
Which is the fifth step of query wizard ?
(A) Grouping
(B) Overview
(C) Aliases
(D) Grouping conditions
Answer:
(A) Grouping
Question 77.
Which step of query wizard gives facility of preparing a group field ?
(A) Aliases
(B) Grouping conditions
(C) Overview
(D) Grouping
Answer:
(D) Grouping
Question 78.
What is decided for creating query in fifth step of query wizard ?
(A) Arrange field in order
(B) Create group for creating field
(C) To summarize or perform numerical calculation
(D) Add condition for searching the field
Answer:
(B) Create group for creating field
Question 79.
The fifth step of query wizard is ……………. .
(A) compulsory
(B) optional
(C) can’t say
(D) none of these
Answer:
(B) optional
Question 80.
How many list box can be seen in fifth step of query wizard ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 81.
Which list box can be seen in fifth step of query wizard ?
(A) Available fields
(B) Group by
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 82.
Which option is useful to display result of grouping in query ?
(A) Arrange by
(B) Group by
(C) Set by
(D) Order by
Answer:
(B) Group by
Question 83.
What is the sixth step of query wizard ?
(A) Grouping
(B) Overview
(C) Aliases
(D) Grouping conditions
Answer:
(D) Grouping conditions
Question 84.
Which step of query wizard has a facility to add condition according to group ?
(A) Aliases
(B) Grouping conditions
(C) Overview
(D) Grouping
Answer:
(B) Grouping conditions
Question 85.
What is decided for creating query in sixth step of query wizard ?
(A) Condition based on group
(B) Create as field for making group
(C) To summarize or perform numerical calculation
(D) Give aliases to field
Answer:
(A) Condition based on group
Question 86.
What is the seventh step of query wizard ?
(A) Grouping
(B) Overview
(C) Aliases
(D) Grouping conditions
Answer:
(C) Aliases
Question 87.
Which step gives facility for alias in query wizard ?
(A) Aliases
(B) Grouping conditions
(C) Overview
(D) Grouping
Answer:
(A) Aliases
Question 88.
What is Aliases ?
(A) To save query
(B) To save query by other name
(C) Displaying meaningful names
(D) Give meaningful name
Answer:
(C) Displaying meaningful names
Question 89.
What is decided in seventh step of query ?
(A) Condition based on group
(B) Create as field for making group
(C) To summarize or perform numerical calculation
(D) Give aliases to field
Answer:
(D) Give aliases to field
Question 90.
The keyword ……………… further mentions that data should be sorted in ascending order of FirstName.
(A) ASC
(B) ASD
(C) ASG
(D) ASCENDING
Answer:
(A) ASC
Question 91.
The purpose of ………………. is to make the query wizard display the field names in human readable form.
(A) fifth
(B) sixth
(C) seventh
(D) eight
Answer:
(C) seventh
Question 92.
…………….. allows us to add small touches to the field name in query wizard.
(A) fifth
(B) sixth
(C) seventh
(D) eight
Answer:
(C) seventh
Question 93.
Which type of changes we can do with aliases in query wizard ?
(A) CustomerFName to FirstName
(B) Rno to RollNumber
(C) EmaillD to EmaillD
(D) All of these
Answer:
(D) All of these
Question 94.
If we do not add aliases then field names of a table will be displayed in a …………….. .
(A) new form
(B) other form
(C) as it is
(D) any one
Answer:
(C) as it is
Question 95.
What is the eight step of query wizard ?
(A) Grouping
(B) Overview
(C) Aliases
(D) Grouping conditions
Answer:
(B) Overview
Question 96.
……………. step of query wizard gives an overview of all the steps performed till now.
(A) Aliases
(B) Grouping conditions
(C) Overview
(D) Grouping
Answer:
(C) Overview
Question 97.
What is decided in eighth step of query wizard ?
(A) Condition based on group
(B) Create as field for making group
(C) To summarize or perform numerical calculation
(D) Give aliases to field
Answer:
(D) Give aliases to field
Question 98.
Which step is used to give a name of query ?
(A) First
(B) Second
(C) Seventh
(D) Eighth
Answer:
(D) Eighth
Question 99.
Use ………………. button to make the changes desired in query wizard.
(A) Back
(B) Edit
(C) Change
(D) Help
Answer:
(A) Back
Question 100.
Once the query is created the only way to make changes is through ……………. .
(A) Wizard
(B) Design View
(C) SQL View
(D) All of these
Answer:
(B) Design View
Question 101.
How many options under the question how do you want to proceed after creating a query ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 102.
Which options under the question how do you want to proceed after creating a query ?
(A) Display Query
(B) Modify Query
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 103.
We can view the query result immediately by choosing ……………. .
(A) Display Query
(B) Modify Query
(C) (A) or (B)
(D) None of these
Answer:
(A) Display Query
Question 104.
Open query in query wizard using ……………. .
(A) Display Query
(B) Modify Query
(C) (A) or (B)
(D) None of these
Answer:
(B) Modify Query
Question 105.
……………. can be used to insert additional features in query that may be beyond the capacity of the wizard.
(A) Design View
(B) Wizard
(C) SQL View
(D) All of these
Answer:
(A) Design View
Question 106.
In which form the result of query is seen ?
(A) Master view
(B) Database view
(C) Datasheet view
(D) Design view
Answer:
(C) Datasheet view
Question 107.
If we do not want to filter records, in query wizard then it is not necessary of having ……………… .
(A) sorting
(B) criteria
(C) aliases
(D) all of these
Answer:
(B) criteria
Question 108.
To create query of the ………………. it allows as to query on a single table only.
(A) design view
(B) wizard
(C) both (A) and (B)
(D) none of these
Answer:
(B) wizard
Question 109.
To create query of the …………….. it allows us to make multiple table.
(A) design view
(B) wizard
(C) both (A) and (B)
(D) none of these
Answer:
(A) design view
Question 110.
Which is the limitation of wizard to create a query ?
(A) In this you can use only one field.
(B) In this you can use only one data type.
(C) In this you can use only one table.
(D) In this you can use only one query.
Answer:
(C) In this you can use only one table.
Question 111.
Due to the limitation of wizard we will use ……………. .
(A) SQL
(B) Design View
(C) (A) or (B)
(D) none of these
Answer:
(B) Design View
Question 112.
Which dialog box is open while Create Query in Design View ?
(A) Add Table or Query
(B) Add Table or Report
(C) Add Query or Form
(D) Add Query or Report
Answer:
(A) Add Table or Query
Question 113.
To create query for add table in design view which button is clicked ?
(A) Put
(B) Include
(C) Add
(D) Attach
Answer:
(C) Add
Question 114.
You can add one or more table at a time in design view of query …………… give the appropriate option.
(A) This sentence is true
(B) This sentence is false
(C) Can’t say
(D) None of these
Answer:
(A) This sentence is true
Question 115.
Which view base also displays the relationship which we have earlier define between the table ?
(A) Wizard
(B) Design View
(C) SQL
(D) All of these
Answer:
(B) Design View
Question 116.
By which name this tool button is known as 
?
(A) Run Query
(B) Save Query
(C) Query Design
(D) Add Table or Query
Answer:
(A) Run Query
Question 117.
By which name this tool button known as 
?
(A) Run Query
(B) Save Query
(C) Query Design
(D) Add Table or Query
Answer:
(D) Add Table or Query
Question 118.
By which name this tool button known as 
?
(A) Run Query
(B) Save Query
(C) Query Design
(D) Add Table or Query
Answer:
(B) Save Query
Question 119.
Add Table or Query button comes on which toolbar ?
(A) Query design
(B) Query grid
(C) Query editing
(D) Query details
Answer:
(A) Query design
Question 120.
The field names along with their respective table names will be displayed in …………….. in design view.
(A) Query details
(B) Query design
(C) Query grid
(D) Query editing
Answer:
(C) Query grid
Question 121.
What will you see in query grid ?
(A) Name of table
(B) Name of field
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 122.
How many heading is shown in query design window ?
(A) 7
(B) 8
(C) 9
(D) 10
Answer:
(B) 8
Question 123.
From the following we are able to see some heading like ……………….. .
(A) Field, Alias, Table
(B) Sort, Visible, Function
(C) Criterion, Or
(D) All of these
Answer:
(D) All of these
Question 124.
By default ……………… option for each field is set to be true.
(A) Alias
(B) Function
(C) Visible
(D) Criterion
Answer:
(C) Visible
Question 125.
……………… indicates that all selected fields will be displayed in the output.
(A) Criterion
(B) Visible
(C) Alias
(D) Function
Answer:
(B) Visible
Question 126.
……………. can be used for displaying meaningful names for the field.
(A) Alias
(B) Function
(C) Visible
(D) Criterion
Answer:
(A) Alias
Question 127.
To display records in alphabetical order of his/her names, select ……………….. .
(A) Criterion
(B) Sort
(C) Alias
(D) Function
Answer:
(B) Sort
Question 128.
How many option available for display records in alphabetical order ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 129.
Which option you can see to display records in alphabetical order ?
(A) Ascending, Descending
(B) Ascending, Descending, Not sorted
(C) A to Z, Z to A
(D) None of these
Answer:
(B) Ascending, Descending, Not sorted
Question 130.
To save query for future select ……………. .
(A) query which is made by wizard
(B) query which is made by design view
(C) both (A) and (B)
(D) query is saved
Answer:
(D) query is saved
Question 131.
Click on the …………….. button to display a Save dialog box.
(A) File → Save
(B) Close button
(C) (A) or (B)
(D) None of these
Answer:
(C) (A) or (B)
Question 132.
Which tool button is used to save a query ?
Answer:
Question 133.
After creating a query you cannot change. Give the appropriate answer for these sentence.
(A) This sentence is true
(B) This sentence is false
(C) Can not say
(D) None of these
Answer:
(B) This sentence is false
Question 134.
Which option will you select when you right click on the query for the changes you done in it ?
(A) Edit
(B) Change
(C) Modify
(D) Adjust
Answer:
(A) Edit
Question 135.
To Run the query, which tool button is used ?
Answer:
Question 136.
In query instead of viewing an records we want base to display a subset of selected records to do this we can specify.
(A) Alias
(B) Cost
(C) Group
(D) Criteria
Answer:
(D) Criteria
Question 137.
How many types are there in query to add criteria ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 138.
From the following which option displayed to add criteria in query ?
(A) Only use of one field
(B) Use of more than one field
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 139.
To view the details of customers residing in the city of Ahmedabad then in which cell of city field we have to type ‘Ahmedabad’ ?
(A) Field
(B) Criterion
(C) Function
(D) Visible
Answer:
(B) Criterion
Question 140.
How many types of parameters you can add in query ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 141.
From the following, which type of criteria you can add in query ?
(A) Text
(B) Numeric
(C) Date
(D) All of these
Answer:
(D) All of these
Question 142.
Text must be enclosed with in ……………… delimiter.
(A) ‘ ’
(B) “ ”
(C) # #
(D) no need of sign
Answer:
(A) ‘ ’
Question 143.
Date must be enclosed in the …………… delimiter.
(A) ‘ ’
(B) “ ”
(C) # #
(D) no need of sign
Answer:
(C) # #
Question 144.
Number literals enclosed with in ……………… .
(A) ‘ ’
(B) “ ”
(C) # #
(D) no need of sign
Answer:
(D) no need of sign
Question 145.
If we miss to put delimiters ……………. .
(A) display error message
(B) base add symbol itself
(C) don’t display error message
(D) both (B) and (C)
Answer:
(D) both (B) and (C)
Question 146.
How many operator does base allows ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 147.
From the following, which option displays operator type ?
(A) Comparison
(B) Logical
(C) Special
(D) All of these
Answer:
(D) All of these
Question 148.
From the following, which option shows ‘ comparison operator ?
(A) And, Or, Not
(B) >, <, >=, <=, = <>
(C) Is, In, Like, Between
(D) All of these
Answer:
(B) >, <, >=, <=, = <>
Question 149.
From the following, which option shows logical operator ?
(A) And, Or, Not
(B) >, <, >=, <=, = <>
(C) Is, In, Like, Between
(D) All of these
Answer:
(A) And, Or, Not
Question 150.
From the following, which option shows special operator ?
(A) And, Or, Not
(B) >, <, >=, <=, = <>
(C) Is, In, Like, Between
(D) All of these
Answer:
(C) Is, In, Like, Between
Question 151.
To display the list of employee who joined after 1 June, 2012 which criteria is being use ?
(A) >01/06/2012
(B) “>01/06/2012”
(C) “>01-06-2012”
(D) >#01/06/2012#
Answer:
(D) >#01/06/2012#
Question 152.
To display the list of employees who joined between 1 June, 2012 to 30 November, 2012 which criteria is being use ?
(A) >01/06/2012<11/30/2012
(B) >=01/06/2012<=l1/30/2012
(C) >=#01/06/2012# And <=#11/30/2012#
(D) >=#01/06/2012#to <=#11/30/2012#
Answer:
(C) >=#01/06/2012# And <=#11/30/2012#
Question 153.
To display employees who joined between 1 June, 2012 to 30 November, 2012 which criteria is being use ?
(A) Between#1/6/2012#And#11/30/2012#
(B) Between#1/6/2012#to#11/30/2012#
(C) Between#1/6/2012#Or#11/30/2012#
(D) Between 1/6/2012 And 11/30/2012
Answer:
(A) Between#1/6/2012#And#11/30/2012#
Question 154.
To send customers, who live in the city of Ahmedabad or Morbi then which query will you select from design grid?
(A) Criterion, Function
(B) Criterion, Or
(C) Criterion, Visible
(D) Criterion, Alias
Answer:
(B) Criterion, Or
Question 155.
To display customers, who live in Ahmedabad or Surat then which option will you select ?
(A) IN(Ahmedabd, Surat)
(B) IN (Ahmedabad; Surat)
(C) IN (Ahmedabad’, ‘Surat’)
(D) IN (Ahmedabad’; ‘Surat’);
Answer:
(D) IN (Ahmedabad’; ‘Surat’);
Question 156.
A list of customer residing except Ahmedabad or Rajkot then which option will you select ?
(A) NOT IN (‘Ahmedabad’, ‘Rajkot’)
(B) NOT IN (‘Ahmedabad’; ‘Rajkot’)
(C) NOT IN (‘Ahmedabad’ & ‘Rajkot’)
(D) NOT IN (‘Ahmedabad’ And ‘Rajkot’)
Answer:
(B) NOT IN (‘Ahmedabad’; ‘Rajkot’)
Question 157.
If you don’t want that entry will live empty then which criteria will you choose ?
(A) Not Null
(B) Not Empty
(C) Is Not Null
(D) In Not Empty
Answer:
(D) In Not Empty
Question 158.
We wrote both the expression in same row while applying ……………… operator.
(A) OR operator
(B) AND operator
(C) NOT operator
(D) IS operator
Answer:
(B) AND operator
Question 159.
……………… condition between two fields is written in separate rows then which operator will you choose ?
(A) OR operator
(B) AND operator
(C) NOT operator
(D) IS operator
Answer:
(A) OR operator
Question 160.
*Symbol is used for ……………… .
(A) user card
(B) character map
(C) wild card
(D) database card
Answer:
(C) wild card
Question 161.
We want to see the list of products with their model names starting with …………… .
(A) character map
(B) wild card
(C) database card
(D) user card
Answer:
(B) wild card
Question 162.
Wild card represents by …………….. .
(A) character
(B) combination of character
(C) both (A) and (B)
(D) none of these
Answer:
(C) both (A) and (B)
Question 163.
tej* represents a group …………….. .
(A) first three alphabets are tej followed by any group of character
(B) last three alphabets are tej followed by any group of character
(C) first three alphabets are tej
(D) last three alphabets are tej
Answer:
(A) first three alphabets are tej followed by any group of character
Question 164.
*as represents a group …………….. .
(A) starting with as alphabet by any group of character
(B) ending with as alphabet by any group of character
(C) both (A) and (B)
(D) none of these
Answer:
(B) ending with as alphabet by any group of character
Question 165.
te*as represents a group …………….. .
(A) starting with te and ending with as alphabet
(B) ending with te and starting with as alphabet
(C) starting with te or ending with as alphabet
(D) ending with te or starting with as alphabet
Answer:
(A) starting with te and ending with as alphabet
Question 166.
Which operator is used with wild card character ?
(A) Is
(B) In
(C) Like
(D) Between
Answer:
(C) Like
Question 167.
Like ‘te*’ gives results ……………. .
(A) tejas
(B) tejal
(C) tejasvi
(D) all of these
Answer:
(D) all of these
Question 168.
Like ‘*ar*’ gives results …………….. .
(A) Kumar
(B) Sukumar
(C) Shreekumar
(D) all of these
Answer:
(D) all of these
Question 169.
How many types are there for calculation in Base ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 170.
Which option is used for calculation in base ?
(A) Custom calculation
(B) Predefined calculation
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 171.
……………… includes performing numeric date and text calculations on each record using data one or more fields.
(A) Custom calculation
(B) Predefined calculation
(C) Both (A) and (B)
(D) None of these
Answer:
(A) Custom calculation
Question 172.
Which type of calculation are done by custom calculation ?
(A) Related text
(B) Numeric
(C) Date
(D) All of these
Answer:
(D) All of these
Question 173.
To perform custom calculation, how many fields are required ?
(A) One
(B) More than one
(C) One or more than one
(D) More than two
Answer:
(C) One or more than one
Question 174.
……………. calculation include calculation like add, multiply, subtract or divide the values in two different fields.
(A) Custom calculation
(B) Predefined calculation
(C) Both (A) and (B)
(D) None of these
Answer:
(A) Custom calculation
Question 175.
To perform ………………… we need to add an extra field.
(A) Custom calculation
(B) Predefined calculation
(C) Both (A) and (B)
(D) None of these
Answer:
(A) Custom calculation
Question 176.
To perform custom calculation we need to add an extra field known as ………………. .
(A) custom field
(B) counted field
(C) calculated field
(D) all of these
Answer:
(D) all of these
Question 177.
Double click on Add Table or Query dialog box it includes ………………. .
(A) master grid
(B) query grid
(C) user grid
(D) table grid
Answer:
(B) query grid
Question 178.
In custom calculation the extra field is included in which row ?
(A) Field
(B) Criterion
(C) Function
(D) Table
Answer:
(A) Field
Question 179.
To increase the width of column, which option is selected ?
(A) Column Size
(B) Column Length
(C) Column Width
(D) Column Thickness
Answer:
(C) Column Width
Question 180.
To perform calculations on group of records, which calculation is used ?
(A) Custom calculation
(B) Predefined calculation
(C) Both (A) and (B)
(D) None of these
Answer:
(B) Predefined calculation
Question 181.
Which type of calculation is performed by predefined type ?
(A) Calculation on group
(B) Calculation on summary
(C) Predefined calculation
(D) All of these
Answer:
(D) All of these
Question 182.
Which type of calculation is performed by predefined calculation ?
(A) Sum, Average, Count
(B) Minimum, Maximum
(C) Standard Deviation or Variance
(D) All of these
Answer:
(D) All of these
Question 183.
Which option is used for aggregate function ?
(A) Sum, Avg, Count
(B) Max, Min
(C) StDev, Var
(D) All of these
Answer:
(D) All of these
Question 184.
In predefined calculation any function choose in which type of function list ?
(A) Aggregate function
(B) Master function
(C) Predefined function
(D) User defined function
Answer:
(A) Aggregate function
Question 185.
In which type of calculation, base performs the calculation each time when you run the query ?
(A) Custom calculation
(B) Predefined calculation
(C) Both (A) and (B)
(D) None of these
Answer:
(B) Predefined calculation
Question 186.
In which type of queries it is always based on the most current data available in the database ?
(A) Custom calculation
(B) Predefined calculation
(C) Both (A) and (B)
(D) None of these
Answer:
(B) Predefined calculation
Question 187.
Who is useful for getting the total number of customers residing in city ?
(A) Apply addition on field
(B) Apply the count function on the field
(C) Create a group of field
(D) Use valid card on field
Answer:
(C) Create a group of field
Question 188.
Which option can used for total number of customer residing in each of the cities by City field and CustomerCode field code ?
(A) City : Group, CustomerCode : Count
(B) City : Count, CustomerCode : Group
(C) City : Sum, CustomerCode : Count
(D) City : Count, CustomerCode : Sum
Answer:
(A) City : Group, CustomerCode : Count
Question 189.
…………….. queries are designed to accept values from the user at runtime of these
(A) Select query
(B) Parameter query
(C) SQL query
(D) Any one of these
Answer:
(B) Parameter query
Question 190.
By running which type of query it opens the dialog box of price ?
(A) Parameter query
(B) SQL query
(C) Select query
(D) Any one of these
Answer:
(A) Parameter query
Question 191.
The queries that we created used fixed criterion ………………. .
(A) Select query
(B) Parameter query
(C) Both (A) and (B)
(D) None of these
Answer:
(B) Parameter query
Question 192.
To add all fields of table in query, which symbol is used ?
(A) @
(B) #
(C) *
(D) ?
Answer:
(C) *
Question 193.
Where parameter is written for creating query ?
(A) Field
(B) Criterion
(C) Table
(D) Function
Answer:
(B) Criterion
Question 194.
When we run a parameter query ……………… .
(A) it will display a dialog box asking the use to enter the values of the parameter
(B) it will display display a dialog box display the result of parameter
(C) it will display dialog box for parameter
(D) it will display dialog box for questioning regulating parameter
Answer:
(A) it will display a dialog box asking the use to enter the values of the parameter
Question 195.
What is used before criterion in parameter query ?
(A) Colon
(B) :
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 196.
How many options are available to do any work in base ?
(A) One
(B) Two
(C) More than one
(D) None of these
Answer:
(C) More than one
Question 197.
Which option is used to add a table in database ?
(A) Create Table in Design View…
(B) Use Wizard to Create Table…
(C) Create Query in SQL View…
(D) All of these
Answer:
(D) All of these
Question 198.
Which option is easy for creating a table ?
(A) Create Table in Design View…
(B) Use Wizard to Create Table…
(C) Create Query is SQL View…
(D) All of these
Answer:
(B) Use Wizard to Create Table…
Question 199.
To create a query, which option is useful for ‘ more option ?
(A) Create Table in SQL View…
(B) Use Wizard to Create Table…
(C) Create Query in SQL View…
(D) All of these
Answer:
(A) Create Table in SQL View…
Question 200.
……………… option gives us the most Flexibility and Control for making query.
(A) Create Table in Design View…
(B) Use Wizard to Create Table…
(C) Create Query in SQL View…
(D) All of these
Answer:
(C) Create Query in SQL View…
Question 201.
What is the full form of SQL ?
(A) System Query Language
(B) Structured Query Language
(C) Source Query Language
(D) Section Query Language
Answer:
(B) Structured Query Language
Question 202.
What is mean by ‘L’ in SQL ?
(A) Language
(B) Location
(C) List
(D) Layer
Answer:
(A) Language
Question 203.
SQL is a standard language used to query a …………….. .
(A) productive database
(B) hierarchical database
(C) network database
(D) relational database
Answer:
(D) relational database
Question 204.
Relational database is standard language listed to ……………. .
(A) JaveScript
(B) SQL
(C) HTML
(D) PHP
Answer:
(B) SQL
Question 205.
The SQL queries are in the form of ……………… .
(A) sentence
(B) function
(C) equation
(D) table
Answer:
(A) sentence
Question 206.
Different operations can also be done using SQL commands.
(A) Create a table
(B) Add information in table
(C) Update table or delete table
(D) All of these
Answer:
(D) All of these
Question 207.
Which option is used for SQL query ?
(A) Query → SQL
(B) Tools → SQL
(C) View → SQL
(D) Edit → SQL
Answer:
(B) Tools → SQL
Question 208.
When we open SQL query, which dialog box we will see ?
(A) Execute SQL Statement
(B) SQL Statement Query
(C) Execute SQL Query
(D) SQL Statement Execute
Answer:
(A) Execute SQL Statement
Question 209.
How many boxes are there in Execute SQL statement ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 210.
Which text box are shown in Execute SQL statement ?
(A) Command to SQL
(B) Status
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 211.
In SQL query Execute SQL Statement dialog box will get opened with a cursor blinking in the text box under the label ……………… .
(A) Command to execute
(B) SQL to Command
(C) Command to Execute
(D) SQL Command to Execute
Answer:
(C) Command to Execute
Question 212.
Pay attention on …………….. to avoid errors in execution of queries.
(A) capital or small letters
(B) quote sign
(C) syntax to avoid errors
(D) all of these
Answer:
(D) all of these
Question 213.
With SQL to create a table named Tejas which construction of sentence is right ?
(A) CREATE TABLE Tejas
(B) CREATE TABLE “Tejas”
(C) CREATE TABLE : Tejas
(D) CREATE TABLE : “Tejas”
Answer:
(B) CREATE TABLE “Tejas”
Question 214.
With SQL option, which sentence is used for SchemelD field as primary key ?
(A) “SchemelD” INTEGER NOT NULL PRIMARY KEY
(B) SchemelD INTEGER NOT NULL PRIMARY KEY
(C) “SchemelD” INTEGER PRIMARY KEY NOT NULL
(D) SchemelD INTEGER PRIMARY KEY NOT NULL
Answer:
(A) “SchemelD” INTEGER NOT NULL PRIMARY KEY
Question 215.
When you enter the instructions in the Execute SQL statement the ……………….. button gets highlighted.
(A) Run Query
(B) Result
(C) Execute
(D) SQL Query
Answer:
(C) Execute
Question 216.
What can you see while executing SQL query ?
(A) Window for Running query
(B) Window will inform that the instruction have been successful
(C) Window will inform to execute the query
(D) Enter the input
Answer:
(B) Window will inform that the instruction have been successful
Question 217.
Which option is used to execute the complete list of tables ?
(A) View → Refresh Tables
(B) File → Refresh Tables
(C) Edit → Refresh Table
(D) Tables → Refresh Tables
Answer:
(A) View → Refresh Tables
Question 218.
To remove the table from a database ………………. statement is used in SQL statement.
(A) DELETE TABLE
(B) REMOVE TABLE
(C) DROP TABLE
(D) ERASE TABLE
Answer:
(C) DROP TABLE
Question 219.
To remove the Scheme from a database ………………. statement is used.
(A) DELETE TABLE Scheme IF EXISTS;
(B) DROP TABLE Scheme IF EXISTS;
(C) DELETE TABLE ‘Scheme’ IF EXISTS;
(D) DROP TABLE ‘Scheme’ IF EXISTS;
Answer:
(B) DROP TABLE Scheme IF EXISTS;
Question 220.
To get information from the Employee table, which SQL statement is used ?
(A) SELECT * from Employee;
(B) DISPLAY * from Employee;
(C) SELECT * Employee;
(D) DISPLAY * Employee;
Answer:
(A) SELECT * from Employee;
Question 221.
To retrieve particular record from the table, which keyword is used in SQL ?
(A) DISPLAY
(B) GET
(C) SELECT
(D) RECORD
Answer:
(C) SELECT
Question 222.
A query starts with SELECT keyword is known as …………….. .
(A) SELECT query
(B) SQL query
(C) MASTER query
(D) BASE query
Answer:
(B) SQL query
Question 223.
Run Query button (AAA) is on the ……………… bar.
(A) function bar
(B) menu bar
(C) standard toolbar
(D) query toolbar
Answer:
(A) function bar
Question 224.
Which SQL sentence is used for FirstName and LastName field of Employee table ?
(A) SELECT FirstName ; LastName from Employee;
(B) DISPLAY FirstName ; LastName from Employee;
(C) SELECT FirstName, LastName from Employee;
(D) DISPAY FirstName, Employee; LastName from
Answer:
(C) SELECT FirstName, LastName from Employee;
Question 225.
Right click on any query to find an option for changing SQL type of query …………….. .
(A) Change in SQL View
(B) Edit in SQL View
(C) Modify in SQL View
(D) Revice in SQL View
Answer:
(B) Edit in SQL View
Question 226.
Which option is used for SQL keyword ?
(A) DELETE TABLE Scheme IF EXISTS;
(B) DROP TABLE Scheme IF EXISTS;
(C) DELETE TABLE ‘Scheme’ IF EXISTS;
(D) DROP TABLE ‘Scheme’ IF EXISTS;
Answer:
(D) DROP TABLE ‘Scheme’ IF EXISTS;
Question 227.
In SQL design view after AS keyword what will display ?
(A) Alias
(B) Name of table
(C) To set results chromologically
(D) Measurement
Answer:
(A) Alias
Question 228.
In SQL design view after FROM keyword, what will display ?
(A) Alias
(B) Name of table
(C) To set results chronologically
(D) Measurement
Answer:
(B) Name of table
Question 229.
In SQL design view after WHERE keyword, what will display ?
(A) Alias
(B) Name of table
(C) To set results chronologically
(D) Measurement
Answer:
(D) Measurement
Question 230.
In SQL design view after ORDER BY keyword what will display ?
(A) Alias
(B) Name of table
(C) To set results chronologically
(D) Measurement
Answer:
(C) To set results chronologically