MCQ

Download App

Questions · Page 2 of 3

MCQ 511 Mark

In Which from the result of query is seen ?

A
Masterview
B
Databaseview
✓
datasheetview
D
Designview

Answer

Correct option: C.

datasheetview

View full question & answer→

MCQ 521 Mark

$…………..$ can be used to insert additional features in query that may be beyond the capacity of the wizard.

A
Design View
✓
Modify Query
C
$(A)$ or $(B)$
D
none of these

Answer

Correct option: B.

Modify Query

View full question & answer→

MCQ 531 Mark

What is Aliases

A
Tosavequery
B
Tosavequerybyothername
✓
Displayingmeaningfulnames
D
Givemeaningfulname

Answer

Correct option: C.

Displayingmeaningfulnames

View full question & answer→

MCQ 541 Mark

Fourth step of Query Wizard is $……….$

A
Compulsory
✓
optional
C
Can’tsay
D
noneofthese

Answer

Correct option: B.

optional

View full question & answer→

MCQ 551 Mark

Which step gives facility for alias in query wizard ?

✓
Aliases
B
Groupingconditions
C
Overview
D
Grouping

Answer

Correct option: A.

Aliases

View full question & answer→

MCQ 561 Mark

How many steps are available in fourth step of query wizrd to summarize ?

✓
$2$
B
$3$
C
$4$
D
$5$

Answer

Correct option: A.

$2$

View full question & answer→

MCQ 571 Mark

If we don’t add aliases then field names of a table will be displayed in a $…………….$

A
newform
B
otherform
✓
asitis
D
anyone

Answer

Correct option: C.

asitis

View full question & answer→

MCQ 581 Mark

$………………$ allows us to add amsll touches to the field name in query wizard ?

A
fifth
B
sixth
✓
Seventh
D
eight

Answer

Correct option: C.

Seventh

View full question & answer→

MCQ 591 Mark

The keywod $………………..$ further mentions that data should be sorted in ascending order of FirstName.

✓
$ASC$
B
$ASD$
C
$ASG$
D
$ASCENDING$

Answer

Correct option: A.

$ASC$

View full question & answer→

MCQ 601 Mark

Which step of query wizard has a facility to add condition according to group ?

A
Aliases
✓
Groupingconditions
C
Overview
D
Grouping

Answer

Correct option: B.

Groupingconditions

View full question & answer→

MCQ 611 Mark

Which list box can be seen in fifth step of query wizard ?

A
Available fields
B
Group by
✓
Both $(A)$ and $(B)$
D
none of these

Answer

Correct option: C.

Both $(A)$ and $(B)$

View full question & answer→

MCQ 621 Mark

Which step of query wizard gives facility of preparing a group field ?

A
Aliases
B
Groupingconditions
C
Overview
✓
Grouping

Answer

Correct option: D.

Grouping

View full question & answer→

MCQ 631 Mark

What is decided in seventh step of query ?

A
Conditionbasedongroup
B
Createasfieldformakinggroup
C
Tosummarizeorperformnumericalcalculation
✓
Givealiasestofield

Answer

Correct option: D.

Givealiasestofield

View full question & answer→

MCQ 641 Mark

Which is the fifth step of query wizard?

✓
Grouping
B
Overview
C
Aliases
D
Groupingconditions

Answer

Correct option: A.

Grouping

View full question & answer→

MCQ 651 Mark

Which option is used to get facility of numerical calculations and summarize ?

✓
Detailorsummary
B
Sortingorder
C
Searchcondition
D
Fieldselection

Answer

Correct option: A.

Detailorsummary

View full question & answer→

MCQ 661 Mark

What is the sixth step of query wizard ?

A
Grouping
B
Overview
C
Aliases
✓
Groupingconditions

Answer

Correct option: D.

Groupingconditions

View full question & answer→

MCQ 671 Mark

How many list box can be seen in fifth step of query wizard ?

✓
$2$
B
$3$
C
$4$
D
$5$

Answer

Correct option: A.

$2$

View full question & answer→

MCQ 681 Mark

The fifth step of query wizard is $……….$

A
Compulsory
✓
optional
C
Can’tsay
D
noneofthese

Answer

Correct option: B.

optional

View full question & answer→

MCQ 691 Mark

What is the fourth step of query wizard ?

A
fieldselection
B
Searchcondition
C
Sortingorder
✓
Detailorsummary

Answer

Correct option: D.

Detailorsummary

View full question & answer→

MCQ 701 Mark

If the selected table does not contain any numeric field base skips $………….$ In its query wizard.

A
$2$
✓
$3$
C
$4$
D
$5$

Answer

Correct option: B.

$3$

View full question & answer→

MCQ 711 Mark

If only one search condition is to be set we need to choose$…………..$

✓
Match all of the following
B
Matchany of the following
C
Both $(A)$ and $(B)$
D
None of these

Answer

Correct option: A.

Match all of the following

View full question & answer→

MCQ 721 Mark

Which option is used in sezrch condition steps ?

A
Match all of the following
B
Match any of the following
✓
Both $(A)$ and $(B)$
D
None of these

Answer

Correct option: C.

Both $(A)$ and $(B)$

View full question & answer→

MCQ 731 Mark

In search engine we observe that we have $…………..$option in query wizard.

✓
$2$
B
$3$
C
$4$
D
$5$

Answer

Correct option: A.

$2$

View full question & answer→

MCQ 741 Mark

We can define maximum $………….$ Search conditions in the query.

A
$2$
✓
$3$
C
$4$
D
$5$

Answer

Correct option: B.

$3$

View full question & answer→

MCQ 751 Mark

What is parameter value ?

✓
parameter
B
Protometer
C
Primeter
D
Prototype

Answer

Correct option: A.

parameter

View full question & answer→

MCQ 761 Mark

What will you choose in third step of query wizard ?

A
appropriatevalueforfield
B
Conditionforfield
C
Valueparameterforthefield
✓
Allofthese

Answer

Correct option: D.

Allofthese

View full question & answer→

MCQ 771 Mark

$……………$ step has given facility for value parameters.

A
First
B
Second
✓
Third
D
Fourth

Answer

Correct option: C.

Third

View full question & answer→

MCQ 781 Mark

$………..$ step of the wizard we actually set up the query.

A
First
B
Second
✓
Third
D
Fourth

Answer

Correct option: C.

Third

View full question & answer→

MCQ 791 Mark

$………….$ Step of the wizard we have to select appropriate values for the field , the conditions and the value parameters.

A
First
B
Second
✓
Third
D
Fourth

Answer

Correct option: C.

Third

View full question & answer→

MCQ 801 Mark

$……………..$ is to mention the sort order.

A
Detailor summary
✓
Sorting order
C
Search conditions
D
Field selection

Answer

Correct option: B.

Sorting order

View full question & answer→

MCQ 811 Mark

What is the second step of query wizard ?

A
Fieldselection
B
SearchCondition
✓
Sortingorder
D
Detailorsummary

Answer

Correct option: C.

Sortingorder

View full question & answer→

MCQ 821 Mark

The field that you finally select to be part of your query will be listed under.

✓
fieldsinthequery
B
Availablefields
C
fieldsinthedatabase
D
presentsfields

Answer

Correct option: A.

fieldsinthequery

View full question & answer→

MCQ 831 Mark

Fields can be arranged in the order required using $……………$ button.

A
> <
B
>> <<
✓
T v
D
both $(A)$ and $(B)$

Answer

Correct option: C.

T v

View full question & answer→

MCQ 841 Mark

$…………..$ of the wizard we have to select appropriate values for the field.

A
Deatil or summary
B
Sorting order
✓
Search conditions
D
Field selection

Answer

Correct option: C.

Search conditions

View full question & answer→

MCQ 851 Mark

What is the third step of query wizard ?

A
fieldSelection
✓
Searchconditions
C
Sortingorder
D
Detailorsummary

Answer

Correct option: B.

Searchconditions

View full question & answer→

MCQ 861 Mark

By what type you can arrange information in sorting order tep in query wizard ?

A
Ascending
B
Descending
✓
Both $(A)$ and $(B)$
D
none of these

Answer

Correct option: C.

Both $(A)$ and $(B)$

View full question & answer→

MCQ 871 Mark

It allows you to select up to $………………..$ fields for deciding the sorting order of output.

A
$2$
B
$3$
✓
$4$
D
$5$

Answer

Correct option: C.

$4$

View full question & answer→

MCQ 881 Mark

The second step of query wizard is $…………………$

A
compulsory
✓
optional
C
Can’tsay
D
none

Answer

Correct option: B.

optional

View full question & answer→

MCQ 891 Mark

$…….$ View is useful for the user who has no previous knowledge.

A
Design View
B
SQL View
✓
Wizard
D
Both $(A)$ and $(B)$

Answer

Correct option: C.

Wizard

View full question & answer→

MCQ 901 Mark

If you are database expert, you might prefer $…….$

A
Design View
B
SQL View
C
Wizard
✓
Both $(A)$ and $(B)$

Answer

Correct option: D.

Both $(A)$ and $(B)$

View full question & answer→

MCQ 911 Mark

What is the full form of $SQL ?$

A
Structure Question Language
✓
Structure Query Language
C
Structure Quach Language
D
Structure Quick Language

Answer

Correct option: B.

Structure Query Language

View full question & answer→

MCQ 921 Mark

From the following which language is fourth generation ?

A
Basic
B
Fortran
✓
$SQL$
D
$LOGO$

Answer

Correct option: C.

$SQL$

View full question & answer→

MCQ 931 Mark

$…………….$ Buttons can be used simultaneously to move fields from the available field list box to field in the query list box.

A
> <
✓
>> <<
C
T v
D
both $(A)$ and $(B)$

Answer

Correct option: B.

>> <<

View full question & answer→

MCQ 941 Mark

create query in $SQL$ View $…..$ user need to have knowledge about $…….$ Computer language.

A
first generation
B
second generation
C
third generation
✓
fourth generation

Answer

Correct option: D.

fourth generation

View full question & answer→

MCQ 951 Mark

$…......….$ Button can be used simulataneously to move fields from the available list box to field I the query list box.

✓
> <
B
>> <<
C
T v
D
both $(A)$ and $(B)$

Answer

Correct option: A.

> <

View full question & answer→

MCQ 961 Mark

The fields that you finally select to be part of your query will be under $……$ list box.

✓
fields in the query
B
available fields
C
fields in the database
D
present fields

Answer

Correct option: A.

fields in the query

View full question & answer→

MCQ 971 Mark

From which list box of query wizard you can select your own choice field or all of the fields?

A
fieldsinthequery
✓
available fields
C
fieldsinthedatabase
D
presentsfields

Answer

Correct option: B.

available fields

View full question & answer→

MCQ 981 Mark

Create query in $…..$ provides no guidance at all.

A
CreateQueryinDesignview…
B
UseWizardtocreateQuery
✓
CreateQueryinSQLView
D
Allofthese

Answer

Correct option: C.

CreateQueryinSQLView

View full question & answer→

MCQ 991 Mark

Which list box you can shown in query wizard in the dialog box ?

A
available fields
B
fields in the query
✓
both $(a)$ and $(b)$
D
none of these

Answer

Correct option: C.

both $(a)$ and $(b)$

View full question & answer→

MCQ 1001 Mark

How many total list box are shown in query wizard in the dialog box ?

✓
$2$
B
$3$
C
$5$
D
$6$

Answer

Correct option: A.

$2$

View full question & answer→

Generate Paper Free All Retrieving Data using Queries topics

MCQ - Page 2 - Computer STD 11 Arts Questions - Vidyadip

Computer MCQ

MCQ