MCQ 11 MarkData must be enclosed in the $………$ delimiter.A’ ‘B” “✓# # DnoneedofsignAnswerCorrect option: C. # # View full question & answer→
MCQ 21 MarkFrom the following, which type of criteria you can add in query ?AtextBnumericCdate ✓alloftheseAnswerCorrect option: D. alloftheseView 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$View full question & answer→
MCQ 41 MarkFrom the following , which option shows comparison operator ?AAnd,or, not✓>,<,>=,=<>Cis,in,ike,betweenDallofthesesAnswerCorrect option: B. >,<,>=,=<>View full question & answer→
MCQ 51 MarkFrom the following ,which option displays oprator type ?AcomparisonBlogicalCspecial✓all of theseAnswerCorrect option: D. all of theseView full question & answer→
MCQ 61 MarkHow many operator does base allows ?A$2$✓$3$C$4$D$5$AnswerCorrect option: B. $3$View full question & answer→
MCQ 71 MarkIf we miss to put delimiters$………$Adisplay error message✓base add symbol itseif Cdon’t displaterr or messageDboth $(a)$ and $(b)$AnswerCorrect option: B. base add symbol itseif View full question & answer→
MCQ 81 MarkNumber literals enclosed with in$…… .$A’ ‘B” “ C# #✓no need of signAnswerCorrect option: D. no 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. criterionView full question & answer→
MCQ 111 MarkWhich option you can see to display records in alphabetical order ?Aascendingdescending ✓ascending,descending,notsortedCatoz.ztoaDnoneoftheseAnswerCorrect option: B. ascending,descending,notsortedView 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$View full question & answer→
MCQ 131 Mark$……$ Can be used for displaying meaningful names for the field.✓aliasBfunctionCvisibleDcriterionAnswerCorrect option: A. aliasView full question & answer→
MCQ 141 Mark$….$Indicates that all selected fields will be displated in the output.Aalias✓functionCvisibleDcriterionAnswerCorrect option: B. functionView 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)$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$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 View 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. editView 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 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)$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 editingView full question & answer→
MCQ 221 Markadd table or query button comes on which toolbar ?✓query desingBquery gridCquery editingDquery detailsAnswerCorrect option: A. query 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 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 savedView full question & answer→
MCQ 251 MarkTo display records in alphabetical order of his/her names, select Acriteion✓sortCaliasDfunctionAnswerCorrect option: B. sortView full question & answer→
MCQ 261 Mark$….....$Indicates that all selected fields will be displated in the output.Aalias✓functionCvisibleDcriterionAnswerCorrect option: B. functionView full question & answer→
MCQ 271 MarkBy defult$…….$ Option for each field is set to be rtue.Aalias Bfunction✓visibleDcriterionAnswerCorrect option: C. visibleView 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 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$View full question & answer→
MCQ 301 MarkWhay will tou see in query grid ?Anamepftable Bnameoffield✓both $(a)$ and $(b)$DnoneoftheseAnswerCorrect option: C. both $(a)$ and $(b)$View full question & answer→
MCQ 311 MarkDue to the limitation of wizard we will use.Asql ✓design viewC$(a)$ or $(b)$Dnone of theseAnswerCorrect option: B. design 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 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. wizardView 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 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✓criteriaCaliasesDAlloftheseAnswerCorrect option: B. criteriaView full question & answer→
MCQ 361 MarkBy which name this tool button is known as mâ ?✓runqueryBsavequeryCquerydesignDaddtableorqueryAnswerCorrect option: A. runqueryView full question & answer→
MCQ 371 MarkWhich view base also displays the relationship which we have earlier define between the table ?Awizard✓designviewCsqlDalloftheseAnswerCorrect option: B. designviewView 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 View full question & answer→
MCQ 391 MarkTo create query for add table design view which button is clicked ?AputBinclude✓addDattachAnswerCorrect option: C. addView full question & answer→
MCQ 401 MarkWhich dialog box is open while create query in design view ?✓addtableorquery BaddtableorreportCaddqueryorformDaddqueryorreportAnswerCorrect option: A. addtableorquery 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.✓DesignViewBWizardCSQLViewDAlloftheseAnswerCorrect option: A. DesignViewView full question & answer→
MCQ 421 MarkWhat is the seventh step of query wizard ?AGroupingBOverview✓AliasesDGroupingconditionsAnswerCorrect option: C. AliasesView full question & answer→
MCQ 431 MarkOpen query in query in query wizard using $………….$ADisplay Query✓Modify QueryC$(A)$ or $(B)$Dnone of theseAnswerCorrect option: B. Modify QueryView full question & answer→
MCQ 441 MarkWe can view the query result immediately by choosing $…………$✓Display QueryBModify QueryC$(A)$ or $(B)$Dnone of theseAnswerCorrect option: A. 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$View full question & answer→
MCQ 461 MarkOnce the query is created the only way to make changes is through$……………….$AWizard✓DesignViewCSQLViewDAlloftheseAnswerCorrect option: B. DesignViewView full question & answer→
MCQ 471 MarkUse $……………..$ button to make the changes desired in query wizard .✓BackBedit CChangeDHelpAnswerCorrect option: A. BackView full question & answer→
MCQ 481 MarkWhich step is used to give a name of query ?AFirstBsecondCSeventh✓eightAnswerCorrect option: D. eightView full question & answer→
MCQ 491 Mark$………$ stepp of query wizard gives an overview of all the steps performed till now.AAliasesBGroupingconditions✓OverviewDGroupingAnswerCorrect option: C. OverviewView full question & answer→
MCQ 501 MarkWhat is the eight step of query wizard ?AGrouping✓OverviewCAliasesDGroupingconditionsAnswerCorrect option: B. OverviewView full question & answer→