MCQ 11 MarkData must be enclosed in the ……… delimiter.A$’ ‘$B$” “$✓$ \#$ $ \#$Dno need of signAnswerCorrect option: C. $ \#$ $ \#$$ \#$ $ \#$View full question & answer→
MCQ 21 MarkFrom the following, which type of criteria you can add in query ?AtextBnumericCdate ✓all of theseAnswerCorrect option: D. all of theseall of theseView full question & answer→
MCQ 31 MarkHow many types of parameterys you can add in query ?A$2$✓$3$C$4$D$5$AnswerCorrect option: B. $3$ $3$View full question & answer→
MCQ 41 MarkFrom the following , which option shows comparison operator ?AAnd, or, not✓$>, <, >=, = <>$Cis, in , ike, betweenDall of thesesAnswerCorrect option: B. $>, <, >=, = <>$$ >, <, >=, = <>$View full question & answer→
MCQ 51 MarkFrom the following ,which option displays oprator type ?AcomparisonBlogicalCspecial✓all of theseAnswerCorrect option: D. all of theseall of theseView full question & answer→
MCQ 61 MarkHow many operator does base allows ?A$2$✓$3$C$4$ D$5$AnswerCorrect option: B. $3$ $3$View full question & answer→
MCQ 71 MarkIf we miss to put delimiters………Adisplay error message✓base add symbol itseif Cdon’t displat error messageDboth$(a)$ and$(b)$AnswerCorrect option: B. base add symbol itseif base add symbol itseifView full question & answer→
MCQ 81 MarkNumber literals enclosed with in…… .A$’ ‘$B$” “$ C$ \# \#$✓no need of signAnswerCorrect option: D. no need of signno need of signView full question & answer→
MCQ 91 MarkText must be be enclosed with in ………. Delimiter.✓$’ ‘$B$” “$C$ \# \#$Dno need of signAnswerCorrect option: A. $’ ‘$$’ ‘$View full question & answer→
MCQ 101 MarkTo view the details of customers residing in the city of ahmedabad then in which cell of city field we have to type ‘ahmedabad’?Afield✓criterionCfunctionDvisibleAnswerCorrect option: B. criterioncriterionView full question & answer→
MCQ 111 MarkWhich option you can see to display records in alphabetical order ?Aascending descending ✓ascending, descending, not sortedCa to z. z to aDnone of theseAnswerCorrect option: B. ascending, descending, not sorted ascending,descending,not sortedView full question & answer→
MCQ 121 MarkHow many option available for display records in alphabetical order?A$2$✓$3$C$4$D$5$AnswerCorrect option: B. $3$$3$View full question & answer→
MCQ 131 Mark…… Can be used for displaying meaningful names for the field.✓aliasBfunctionCvisibleDcriterionAnswerCorrect option: A. alias aliasView full question & answer→
MCQ 141 Mark….Indicates that all selected fields will be displated in the output.Aalias✓functionCvisibleDcriterionAnswerCorrect option: B. functionfunctionView full question & answer→
MCQ 151 MarkFrom the following which option displayed to add criteria in query ?Aonly use of one fieldBuse of more than one field✓both $(a)$ and $(b)$Dnone of theseAnswerCorrect option: C. both $(a)$ and $(b)$both $(a)$ and $(b)$View full question & answer→
MCQ 161 MarkHow many type are there in query to add criteria ?✓$2$B$3$C$4$D$5$AnswerCorrect option: A. $2$$2$View full question & answer→
MCQ 171 MarkIn query instead of viewing an records we ant base to display a subset of selected records to do this we can specify.AaliasBcost✓grup DcriteriaAnswerCorrect option: C. grup grupView full question & answer→
MCQ 181 MarkWhich option will you select when you right click on the query for the changes you done in it?✓editBchangeCmodifyDadjustAnswerCorrect option: A. editeditView full question & answer→
MCQ 191 MarkAfter creating query you cannot change.give the appropriate answer for these sentence.Athis sentence is true✓this sentence is falseCcan not sayDnone of theseAnswerCorrect option: B. this sentence is false this sentence is falseView full question & answer→
MCQ 201 MarkClick on the …… button to display a save dialog box.Afile-saveBclose button✓$(a)$ or $(b)$Dnone of theseAnswerCorrect option: C. $(a)$ or $(b)$$(a)$ or $(b)$View full question & answer→
MCQ 211 MarkThe field names along with their respective table names will be displayed in…….in design view.Aquery desingBquery grid✓query editingDquery detailsAnswerCorrect option: C. query editingquery editingView full question & answer→
MCQ 221 Markadd table or query button comes on which toolbar ?✓query desingBquery gridCquery editingDquery detailsAnswerCorrect option: A. query desingquery desingView full question & answer→
MCQ 231 MarkBy which name this tool button known as $$ ?Arun query✓save queryCquery designDadd table or queryAnswerCorrect option: B. save querysave queryView full question & answer→
MCQ 241 MarkTo save query for futue select……Aquery which is made by wizardBquery which is made by design viewCboth$(a)$ and $(b)$✓query is savedAnswerCorrect option: D. query is savedquery is savedView full question & answer→
MCQ 251 MarkTo display records in alphabetical order of his/her names, select… .Acriteion✓sortCaliasDfunctionAnswerCorrect option: B. sortsortView full question & answer→
MCQ 261 Mark….Indicates that all selected fields will be displated in the output.Aalias✓functionCvisibleDcriterionAnswerCorrect option: B. functionfunctionView full question & answer→
MCQ 271 MarkBy defult……. Option for each field is set to be rtue.Aalias Bfunction✓visibleDcriterionAnswerCorrect option: C. visiblevisibleView full question & answer→
MCQ 281 MarkFrom the following we are able to see some deading like……Afield, alias, tableBsort, visible, functionCcriterion, or✓all of theseAnswerCorrect option: D. all of theseall of theseView full question & answer→
MCQ 291 MarkHow many heading is shown in query design window ?A$7$✓$8$C$9$D$10$AnswerCorrect option: B. $8$$8$View full question & answer→
MCQ 301 MarkWhay will tou see in query grid ?Aname pf table Bname of field✓both $(a)$ and $(b)$Dnone of theseAnswerCorrect option: C. both $(a)$ and $(b)$both $(a)$ and $(b)$View full question & answer→
MCQ 311 MarkDue to the limitation of wizard we will use.Asql ✓design viewCboth $(A)$ and $(B)$Dnone of theseAnswerCorrect option: B. design viewdesign viewView full question & answer→
MCQ 321 MarkTo create query of the ……it allows us to make multiple table.✓design viewBwizardCboth$(a)$ and $(b)$Dnone of theseAnswerCorrect option: A. design viewdesign viewView full question & answer→
MCQ 331 MarkTo create query of the……..it allows as to query on a single table only.Adesign view ✓wizardCboth$(a)$ and$(b)$Dnone of theseAnswerCorrect option: B. wizardwizardView full question & answer→
MCQ 341 MarkBy which name this tool button known as $$ ?Arun queryBsave queryCquery design✓add table or queryAnswerCorrect option: D. add table or queryadd table or queryView full question & answer→
MCQ 351 MarkIf we do not want to filter records, in query wizard, then it is not necessary of having …………Asorting✓criteriaCaliasesDAll of theseAnswerCorrect option: B. criteriacriteriaView full question & answer→
MCQ 361 MarkBy which name this tool button is known as mâ ?✓run queryBsave queryCquery designDadd table or queryAnswerCorrect option: A. run queryrun queryView full question & answer→
MCQ 371 MarkWhich view base also displays the relationship which we have earlier define between the table ?Awizard✓design viewCsqlDall of theseAnswerCorrect option: B. design viewdesign viewView full question & answer→
MCQ 381 MarkYou can one or more table at a time in design view of query…… give the appropriate option.✓this sentence is true Bthis sentence is falseCcan’t sayDnone of theseAnswerCorrect option: A. this sentence is true this sentence is trueView full question & answer→
MCQ 391 MarkTo create query for add table design view which button is clicked ?AputBinclude✓addDattachAnswerCorrect option: C. addaddView full question & answer→
MCQ 401 MarkWhich dialog box is open while create query in design view ?✓add table or query Badd table or reportCadd query or formDadd query or reportAnswerCorrect option: A. add table or query add table or queryView 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 ViewBWizardCSQL ViewDAll of theseAnswerCorrect option: A. Design ViewDesign ViewView full question & answer→
MCQ 421 MarkWhat is the seventh step of query wizard ?AGroupingBOverview✓AliasesDGrouping conditionsAnswerCorrect option: C. AliasesAliasesView full question & answer→
MCQ 431 MarkOpen query in query in query wizard using ………….ADisplay Query✓Modify QueryCboth $(A)$ and $(B)$Dnone of theseAnswerCorrect option: B. Modify QueryModify QueryView full question & answer→
MCQ 441 MarkWe can view the query result immediately by choosing …………✓Display QueryBModify QueryCboth $(A)$ and $(B)$Dnone of theseAnswerCorrect option: A. Display Query Display QueryView full question & answer→
MCQ 451 MarkHow many options under the question how do you want to proceed after creating a query ?✓$2$B$3$C$4$D$5$AnswerCorrect option: A. $2$$2$View full question & answer→
MCQ 461 MarkOnce the query is created the only way to make changes is through……………….AWizard✓Design ViewCSQL ViewDAll of theseAnswerCorrect option: B. Design ViewDesign ViewView full question & answer→
MCQ 471 MarkUse …………….. button to make the changes desired in query wizard .✓BackBedit CChangeDHelpAnswerCorrect option: A. BackBackView full question & answer→
MCQ 481 MarkWhich step is used to give a name of query ?AFirstBsecondCSeventh✓eightAnswerCorrect option: D. eighteightView full question & answer→
MCQ 491 Mark……… stepp of query wizard gives an overview of all the steps performed till now.AAliasesBGrouping conditions✓OverviewDGroupingAnswerCorrect option: C. OverviewOverviewView full question & answer→
MCQ 501 MarkWhat is the eight step of query wizard ?AGrouping✓OverviewCAliasesDGrouping conditionsAnswerCorrect option: B. OverviewOverviewView full question & answer→