Questions

MCQ . (1 Marks)

Take a timed test

127 questions · auto-graded multiple-choice test.

MCQ 11 Mark
Data must be enclosed in the ……… delimiter.
  • A
    $’  ‘$
  • B
    $”  “$
  • $ \#$ $ \#$
  • D
    no need of sign
Answer
Correct option: C.
$ \#$ $ \#$
$ \#$ $ \#$
View full question & answer
MCQ 21 Mark
From the following, which type of criteria you can add in query ?
  • A
    text
  • B
    numeric
  • C
    date  
  • all of these
Answer
Correct option: D.
all of these
all of these
View full question & answer
MCQ 41 Mark
From the following , which option shows comparison operator ?
  • A
    And, or,  not
  • $>, <, >=, = <>$
  • C
    is, in , ike, between
  • D
    all of theses
Answer
Correct option: B.
$>, <, >=, = <>$
$ >, <, >=, = <>$
View full question & answer
MCQ 51 Mark
From the following ,which option displays oprator   type ?
  • A
    comparison
  • B
    logical
  • C
    special
  • all of these
Answer
Correct option: D.
all of these
all of these
View full question & answer
MCQ 71 Mark
If we miss to put delimiters………
  • A
    display error message
  • base add symbol itseif 
  • C
    don’t displat error message
  • D
    both$(a)$ and$(b)$
Answer
Correct option: B.
base add symbol itseif 
base add symbol itseif
View full question & answer
MCQ 81 Mark
Number literals enclosed with in…… .
  • A
    $’  ‘$
  • B
    $”  “$     
  • C
    $ \#  \#$
  • no need of sign
Answer
Correct option: D.
no need of sign
no need of sign
View full question & answer
MCQ 91 Mark
Text must be be  enclosed  with in ………. Delimiter.
  • $’  ‘$
  • B
    $”  “$
  • C
    $ \#  \#$
  • D
    no need of sign
Answer
Correct option: A.
$’  ‘$
$’ ‘$
View full question & answer
MCQ 101 Mark
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
  • criterion
  • C
    function
  • D
    visible
Answer
Correct option: B.
criterion
criterion
View full question & answer
MCQ 111 Mark
Which option you can see to display records in alphabetical order ?
  • A
    ascending descending              
  • ascending, descending, not sorted
  • C
    a to z. z to a
  • D
    none of these
Answer
Correct option: B.
ascending, descending, not sorted
 ascending,descending,not sorted
View full question & answer
MCQ 121 Mark
How many option available for display  records in alphabetical order?
  • A
    $2$
  • $3$
  • C
    $4$
  • D
    $5$
Answer
Correct option: B.
$3$
$3$
View full question & answer
MCQ 131 Mark
…… Can be used for displaying meaningful names for the field.
  • alias
  • B
    function
  • C
    visible
  • D
    criterion
Answer
Correct option: A.
alias
 alias
View full question & answer
MCQ 141 Mark
….Indicates that all selected fields will be displated in the output.
  • A
    alias
  • function
  • C
    visible
  • D
    criterion
Answer
Correct option: B.
function
function
View full question & answer
MCQ 151 Mark
From the following which option displayed to add criteria in query ?
  • A
    only use of one field
  • B
    use of more than one field
  • both $(a)$ and $(b)$
  • D
    none of these
Answer
Correct option: C.
both $(a)$ and $(b)$
both $(a)$ and $(b)$
View full question & answer
MCQ 171 Mark
In  query instead of viewing an records we ant base to display a subset of selected records to do this we can specify.
  • A
    alias
  • B
    cost
  • grup  
  • D
    criteria
Answer
Correct option: C.
grup  
grup
View full question & answer
MCQ 181 Mark
Which option will you select when you right click on the query for the changes you done in it?
  • edit
  • B
    change
  • C
    modify
  • D
    adjust
Answer
Correct option: A.
edit
edit
View full question & answer
MCQ 191 Mark
After creating query you cannot change.give the appropriate answer for these sentence.
  • A
    this sentence is true
  • this sentence is false
  • C
    can not say
  • D
    none of these
Answer
Correct option: B.
this sentence is false
 this sentence is false
View full question & answer
MCQ 201 Mark
Click on the …… button to display a save dialog box.
  • A
    file-save
  • B
    close button
  • $(a)$ or $(b)$
  • D
    none of these
Answer
Correct option: C.
$(a)$ or $(b)$
$(a)$ or $(b)$
View full question & answer
MCQ 211 Mark
The  field names along with their respective table names will be displayed in…….in design view.
  • A
    query desing
  • B
    query grid
  • query editing
  • D
    query details
Answer
Correct option: C.
query editing
query editing
View full question & answer
MCQ 221 Mark
add table or query button comes on which toolbar ?
  • query desing
  • B
    query grid
  • C
    query editing
  • D
    query details
Answer
Correct option: A.
query desing
query desing
View full question & answer
MCQ 231 Mark
By which name this tool button known as $œ$ ?
  • A
    run query
  • save query
  • C
    query design
  • D
    add table or query
Answer
Correct option: B.
save query
save query
View full question & answer
MCQ 241 Mark
To save query for futue select……
  • A
    query which is made by wizard
  • B
    query which is made by design view
  • C
    both$(a)$ and $(b)$
  • query is saved
Answer
Correct option: D.
query is saved
query is saved
View full question & answer
MCQ 251 Mark
To display records in alphabetical  order of his/her names, select… .
  • A
    criteion
  • sort
  • C
    alias
  • D
    function
Answer
Correct option: B.
sort
sort
View full question & answer
MCQ 261 Mark
….Indicates that all selected fields will be displated in the output.
  • A
    alias
  • function
  • C
    visible
  • D
    criterion
Answer
Correct option: B.
function
function
View full question & answer
MCQ 271 Mark
By defult……. Option for each field is set to be rtue.
  • A
    alias  
  • B
    function
  • visible
  • D
    criterion
Answer
Correct option: C.
visible
visible
View full question & answer
MCQ 281 Mark
From the following we are able to see some deading like……
  • A
    field, alias, table
  • B
    sort, visible, function
  • C
    criterion, or
  • all of these
Answer
Correct option: D.
all of these
all of these
View full question & answer
MCQ 301 Mark
Whay will tou see in query grid ?
  • A
    name pf table              
  • B
    name of field
  • both $(a)$ and $(b)$
  • D
    none of these
Answer
Correct option: C.
both $(a)$ and $(b)$
both $(a)$ and $(b)$
View full question & answer
MCQ 311 Mark
Due to the limitation of wizard we will use.
  • A
    sql     
  • design view
  • C
    both $(A)$ and $(B)$
  • D
    none of these
Answer
Correct option: B.
design view
design view
View full question & answer
MCQ 321 Mark
To create query of the ……it allows us to make multiple table.
  • design view
  • B
    wizard
  • C
    both$(a)$ and $(b)$
  • D
    none of these
Answer
Correct option: A.
design view
design view
View full question & answer
MCQ 331 Mark
To create query of the……..it allows as to query on a single table only.
  • A
    design view   
  • wizard
  • C
    both$(a)$ and$(b)$
  • D
    none of these
Answer
Correct option: B.
wizard
wizard
View full question & answer
MCQ 341 Mark
By which name this tool button known as $ž$ ?
  • A
    run query
  • B
    save query
  • C
    query design
  • add table or query
Answer
Correct option: D.
add table or query
add table or query
View full question & answer
MCQ 351 Mark
If we do not want to filter records, in query wizard, then it is not necessary of having …………
  • A
    sorting
  • criteria
  • C
    aliases
  • D
    All of these
Answer
Correct option: B.
criteria
criteria
View full question & answer
MCQ 361 Mark
By which name this tool button is known as mâ ?
  • run query
  • B
    save query
  • C
    query design
  • D
    add table or query
Answer
Correct option: A.
run query
run query
View full question & answer
MCQ 371 Mark
Which view base also displays  the relationship which we have earlier define between the table ?
  • A
    wizard
  • design view
  • C
    sql
  • D
    all of these
Answer
Correct option: B.
design view
design view
View full question & answer
MCQ 381 Mark
You can one or more table at a time in design view of query…… give the  appropriate option.
  • this sentence is true   
  • B
    this sentence is false
  • C
    can’t say
  • D
    none of these
Answer
Correct option: A.
this sentence is true   
 this sentence is true
View full question & answer
MCQ 391 Mark
To create query  for add table design view which button is clicked ?
  • A
    put
  • B
    include
  • add
  • D
    attach
Answer
Correct option: C.
add
add
View full question & answer
MCQ 401 Mark
Which dialog box is open while create query in design view ?
  • add table or query     
  • B
    add table or report
  • C
    add query or form
  • D
    add query or report
Answer
Correct option: A.
add table or query     
 add table or query
View full question & answer
MCQ 411 Mark
………….. can be used to insert additional features in query that may be beyond the capacity of the wizard.
  • Design View
  • B
    Wizard
  • C
    SQL View
  • D
    All of these
Answer
Correct option: A.
Design View
Design View
View full question & answer
MCQ 421 Mark
What is the seventh step of query wizard ?
  • A
    Grouping
  • B
    Overview
  • Aliases
  • D
    Grouping conditions
Answer
Correct option: C.
Aliases
Aliases
View full question & answer
MCQ 431 Mark
Open query in query in query wizard using ………….
  • A
    Display Query
  • Modify Query
  • C
    both $(A)$ and $(B)$
  • D
    none of these
Answer
Correct option: B.
Modify Query
Modify Query
View full question & answer
MCQ 441 Mark
We can view the query result immediately by choosing …………
  • Display Query
  • B
    Modify Query
  • C
    both $(A)$ and $(B)$
  • D
    none of these
Answer
Correct option: A.
Display Query
 Display Query
View full question & answer
MCQ 451 Mark
How many options under the question how do you want to proceed after creating a query ?
  • $2$
  • B
    $3$
  • C
    $4$
  • D
    $5$
Answer
Correct option: A.
$2$
$2$
View full question & answer
MCQ 461 Mark
Once the query is created the only way to make changes is through……………….
  • A
    Wizard
  • Design View
  • C
    SQL View
  • D
    All of these
Answer
Correct option: B.
Design View
Design View
View full question & answer
MCQ 471 Mark
Use …………….. button to  make the changes desired in query wizard .
  • Back
  • B
    edit  
  • C
    Change
  • D
    Help
Answer
Correct option: A.
Back
Back
View full question & answer
MCQ 481 Mark
Which step is used to give a name of query ?
  • A
    First
  • B
    second
  • C
    Seventh
  • eight
Answer
Correct option: D.
eight
eight
View full question & answer
MCQ 491 Mark
……… stepp of query wizard gives an overview of all the steps performed till now.
  • A
    Aliases
  • B
    Grouping conditions
  • Overview
  • D
    Grouping
Answer
Correct option: C.
Overview
Overview
View full question & answer
MCQ 501 Mark
What is the eight step of query wizard ?
  • A
    Grouping
  • Overview
  • C
    Aliases
  • D
    Grouping conditions
Answer
Correct option: B.
Overview
Overview
View full question & answer
MCQ 511 Mark
In Which from the result of query is seen ?
  • A
    Master view
  • B
    Database view
  • datasheet view
  • D
    Design view
Answer
Correct option: C.
datasheet view
datasheet view
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
    both $(A)$ and $(B)$
  • D
    none of these
Answer
Correct option: B.
Modify Query
Modify Query
View full question & answer
MCQ 531 Mark
What is Aliases
  • A
    To save query
  • B
    To save query by other name
  • Displaying meaningful names
  • D
    Give meaningful name
Answer
Correct option: C.
Displaying meaningful names
Displaying meaningful names
View full question & answer
MCQ 541 Mark
Fourth step of Query Wizard is ……………….
  • A
    Compulsory
  • optional
  • C
    Can’t say
  • D
    none of these
Answer
Correct option: B.
optional
optional
View full question & answer
MCQ 551 Mark
Which step gives facility for alias in query wizard ?
  • Aliases
  • B
    Grouping conditions
  • C
    Overview
  • D
    Grouping
Answer
Correct option: A.
Aliases
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$
$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
    new form
  • B
    other form
  • as it is
  • D
    any one
Answer
Correct option: C.
as it is
as it is
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
 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$
 $ASC$
View full question & answer
MCQ 601 Mark
Which step of query wizard has a facility to add condition according to group ?
  • A
    Aliases
  • Grouping conditions
  • C
    Overview
  • D
    Grouping
Answer
Correct option: B.
Grouping conditions
 Grouping conditions
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)$
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
    Grouping conditions
  • C
    Overview
  • Grouping
Answer
Correct option: D.
Grouping
Grouping
View full question & answer
MCQ 631 Mark
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
  • Give aliases to field
Answer
Correct option: D.
Give aliases to field
Give aliases to field
View full question & answer
MCQ 641 Mark
Which is the fifth step of query wizard?
  • Grouping
  • B
    Overview
  • C
    Aliases
  • D
    Grouping conditions
Answer
Correct option: A.
Grouping
Grouping
View full question & answer
MCQ 651 Mark
Which option is used to get facility of numerical calculations and summarize ?
  • Detail or summary
  • B
    Sorting order               
  • C
    Search condition
  • D
    Field selection
Answer
Correct option: A.
Detail or summary
Detail or summary
View full question & answer
MCQ 661 Mark
What is the sixth step of query wizard ?
  • A
    Grouping
  • B
    Overview
  • C
    Aliases
  • Grouping conditions
Answer
Correct option: D.
Grouping conditions
Grouping conditions
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$
$2$
View full question & answer
MCQ 681 Mark
The fifth step of query wizard is ……….
  • A
    Compulsory
  • optional
  • C
    Can’t say
  • D
    none of these
Answer
Correct option: B.
optional
optional
View full question & answer
MCQ 691 Mark
What is the fourth step of query wizard ?
  • A
    field selection
  • B
    Search condition
  • C
    Sorting order
  • Detail or summary
Answer
Correct option: D.
Detail or summary
Detail or summary
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$
 $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
    Match any of the following
  • C
    Both $(A)$ and $(B)$
  • D
    None of these
Answer
Correct option: A.
Match all of the following
 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)$
 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$
 $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$
$3$
View full question & answer
MCQ 751 Mark
What is parameter value ?
  • parameter
  • B
    Protometer
  • C
    Primeter
  • D
    Prototype
Answer
Correct option: A.
parameter
parameter
View full question & answer
MCQ 761 Mark
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
  • All of these
Answer
Correct option: D.
All of these
 All of these
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
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
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
Third
View full question & answer
MCQ 801 Mark
…………….. is to mention the sort order.
  • A
    Detail or  summary
  • Sorting order
  • C
    Search conditions
  • D
    Field selection
Answer
Correct option: B.
Sorting order
Sorting order
View full question & answer
MCQ 811 Mark
What is the second step of query wizard ?
  • A
    Field selection
  • B
    Search Condition
  • Sorting order
  • D
    Detail or summary
Answer
Correct option: C.
Sorting order
Sorting order
View full question & answer
MCQ 821 Mark
The field that you finally select to be part of your query will be listed under.
  • fields in the query
  • B
    Available fields
  • C
    fields in the database
  • D
    presents fields
Answer
Correct option: A.
fields in the query
fields in the query
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$
$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
Search conditions
View full question & answer
MCQ 851 Mark
What is the third step of query wizard ?
  • A
    field Selection
  • Search conditions
  • C
    Sorting order
  • D
    Detail or summary
Answer
Correct option: B.
Search conditions
Search conditions
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) 
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$
$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
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
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)
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
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$
$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
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.
$>   <  $
$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
  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
    fields in the query
  • available  fields
  • C
    fields in the database
  • D
    presents fields
Answer
Correct option: B.
available  fields
 available fields
View full question & answer
MCQ 981 Mark
Create query in ….. provides no guidance at all.
  • A
    Create Query in Design view…
  • B
    Use Wizard to create Query
  • Create Query in $SQL$ View
  • D
    All of these
Answer
Correct option: C.
Create Query in $SQL$ View
  Create Query in $SQL$ View
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)$
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$
$2$
View full question & answer
MCQ 1011 Mark
………..In creating the query is to select the table and the set of field in that table from whichinformationis to be retrirved.
  • first
  • B
    second
  • C
    third
  • D
    fourth
Answer
Correct option: A.
first
first
View full question & answer
MCQ 1021 Mark
……… Help us in identifyinf the field that are to be displayed  in our output
  • first
  • B
     second
  • C
    thid
  • D
    fourth
Answer
Correct option: A.
first
  first
View full question & answer
MCQ 1031 Mark
Which step is compulsory of query wizard ?
  • first
  • B
    second
  • C
     third
  • D
    fourth
Answer
Correct option: A.
first
  first
View full question & answer
MCQ 1041 Mark
…….. wizard is provides for the query creation.
  • A
    Create Query in Design view…
  • Use Wizard to create Query
  • C
    Create Query in SQL View
  • D
    All of these
Answer
Correct option: B.
Use Wizard to create Query
 Use Wizard to create Query
View full question & answer
MCQ 1051 Mark
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
  • Both $(A)$ and $(B)$
Answer
Correct option: D.
Both $(A)$ and $(B)$
Both $(A)$ and $(B)$
View full question & answer
MCQ 1061 Mark
…………..Help us in identifying the fields that are to be displayed in our output
  • A
    detail summary
  • B
    sorting order
  • C
    search conditions
  • field selection
Answer
Correct option: D.
field selection
 field selection
View full question & answer
MCQ 1071 Mark
What  is the first step  querywizard ?
  • field selection
  • B
    search conditions
  • C
     sorting order
  • D
    detail or summary
Answer
Correct option: A.
field selection
  field selection
View full question & answer
MCQ 1081 Mark
How many steps available to create a query in query wizard ?
  • A
    $6$
  • B
    $7$
  • $8$
  • D
    $9$
Answer
Correct option: C.
$8$
 $ 8$
View full question & answer
MCQ 1101 Mark
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
  • All of these
Answer
Correct option: D.
All of these
 All of these
View full question & answer
MCQ 1121 Mark
The query window is organized like……..
  • A
    table window
  • B
    form window
  • C
    report window
  • all of these
Answer
Correct option: D.
all of these
  all of these
View full question & answer
MCQ 1131 Mark
……….. is a set of rules for fetching information from a table or from several table at once.
  • A
    Form
  • Query
  • C
    Table
  • D
    report
Answer
Correct option: B.
Query
  Query
View full question & answer
MCQ 1141 Mark
…….. is to ask a question about the information in the database
  • Query
  • B
    Question
  • C
    Question bank
  • D
    primary key
Answer
Correct option: A.
Query
Query
View full question & answer
MCQ 1151 Mark
Query basically means ……….
  • A
    asking question
  • B
    doing enquiry
  • C
    performing analysis
  • All of these
Answer
Correct option: D.
All of these
All of these
View full question & answer
MCQ 1161 Mark
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
  • All of these
Answer
Correct option: D.
All of these
  All of these
View full question & answer
MCQ 1171 Mark
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
  • all of these
Answer
Correct option: D.
all of these
 all of these
View full question & answer
MCQ 1181 Mark
Queries icon is shown in which side of database window ?
  • A
    Left
  • B
    Right
  • C
    Up
  • Down
Answer
Correct option: D.
Down
  Down
View full question & answer
MCQ 1191 Mark
Which icon is shown in database pane ?
  • tables, Queries
  • B
    Forms, Reports
  • C
    Macro, Modules
  • D
    Both $(A)$ and $(B)$
Answer
Correct option: A.
tables, Queries
  tables, Queries
View full question & answer
MCQ 1211 Mark
………………… can be used to retrieve specific set of informationfrom database.
  • Query
  • B
    Form               
  • C
    Report
  • D
    Macro
Answer
Correct option: A.
Query
Query
View full question & answer
MCQ 1221 Mark
…………….  Is a huge collection of data.
  • A
    table
  • Database
  • C
    Record
  • D
    Field
Answer
Correct option: B.
Database
Database
View full question & answer
MCQ 1231 Mark
Create a query in …… provides a minimal amount of guidance.
  • Create Query in Design view…
  • B
    Use Wizard to create Query
  • C
    Create Query in SQL View
  • D
    All of these
Answer
Correct option: A.
Create Query in Design view…
Create Query in Design view…
View full question & answer
MCQ 1241 Mark
Which side to create a query will be shown in the tasks pane ?
  • A
    Left
  • B
    Right
  • Up
  • D
    Down
Answer
Correct option: C.
Up
  Up
View full question & answer
MCQ 1251 Mark
to create a query what to do ?
  • A
    Open a table
  • B
    Open a database
  • Open a query
  • D
    Any one of these
Answer
Correct option: C.
Open a query
 Open a query
View full question & answer
MCQ 1261 Mark
Query consists of a set of records, organized in ……….
  • A
    rows as per record
  • B
    column as per field
  • Both $(A)$ and $(B)$
  • D
    none of these
Answer
Correct option: C.
Both $(A)$ and $(B)$
Both $(A)$ and $(B)$
View full question & answer
MCQ 1271 Mark
The result of query displays in a ……… form
  • table
  • B
    report
  • C
    form
  • D
    query
Answer
Correct option: A.
table
  table
View full question & answer