MCQ 511 MarkIn Which from the result of query is seen ?AMaster viewBDatabase view✓datasheet viewDDesign viewAnswerCorrect option: C. datasheet viewdatasheet viewView full question & answer→
MCQ 521 Mark………….. can be used to insert additional features in query that may be beyond the capacity of the wizard.ADesign View ✓Modify QueryCboth $(A)$ and $(B)$Dnone of theseAnswerCorrect option: B. Modify QueryModify QueryView full question & answer→
MCQ 531 MarkWhat is AliasesATo save queryBTo save query by other name✓Displaying meaningful namesDGive meaningful nameAnswerCorrect option: C. Displaying meaningful namesDisplaying meaningful namesView full question & answer→
MCQ 541 MarkFourth step of Query Wizard is ……………….ACompulsory✓optionalCCan’t sayDnone of theseAnswerCorrect option: B. optionaloptionalView full question & answer→
MCQ 551 MarkWhich step gives facility for alias in query wizard ?✓AliasesBGrouping conditionsCOverviewDGroupingAnswerCorrect option: A. AliasesAliasesView full question & answer→
MCQ 561 MarkHow many steps are available in fourth step of query wizrd to summarize ?✓$2$B$3$C$4$D$5$AnswerCorrect option: A. $2$$2$View full question & answer→
MCQ 571 MarkIf we don’t add aliases then field names of a table will be displayed in a …………….Anew formBother form✓as it isDany oneAnswerCorrect option: C. as it isas it isView full question & answer→
MCQ 581 Mark……………… allows us to add amsll touches to the field name in query wizard ?AfifthBsixth✓SeventhDeightAnswerCorrect option: C. Seventh SeventhView full question & answer→
MCQ 591 MarkThe keywod ……………….. further mentions that data should be sorted in ascending order of FirstName.✓$ASC$B$ASD$ C$ASG$D$ASCENDING$AnswerCorrect option: A. $ASC$ $ASC$View full question & answer→
MCQ 601 MarkWhich step of query wizard has a facility to add condition according to group ?AAliases✓Grouping conditionsCOverviewDGroupingAnswerCorrect option: B. Grouping conditions Grouping conditionsView full question & answer→
MCQ 611 MarkWhich list box can be seen in fifth step of query wizard ?AAvailable fieldsBGroup by✓Both $(A)$ and $(B)$Dnone of theseAnswerCorrect option: C. Both $(A)$ and $(B)$Both $(A)$ and $(B)$View full question & answer→
MCQ 621 MarkWhich step of query wizard gives facility of preparing a group field ?AAliasesBGrouping conditionsCOverview✓GroupingAnswerCorrect option: D. GroupingGroupingView full question & answer→
MCQ 631 MarkWhat is decided in seventh step of query ?ACondition based on groupBCreate as field for making groupCTo summarize or perform numerical calculation✓Give aliases to fieldAnswerCorrect option: D. Give aliases to fieldGive aliases to fieldView full question & answer→
MCQ 641 MarkWhich is the fifth step of query wizard?✓GroupingBOverviewCAliasesDGrouping conditionsAnswerCorrect option: A. GroupingGroupingView full question & answer→
MCQ 651 MarkWhich option is used to get facility of numerical calculations and summarize ?✓Detail or summaryBSorting order CSearch conditionDField selectionAnswerCorrect option: A. Detail or summaryDetail or summaryView full question & answer→
MCQ 661 MarkWhat is the sixth step of query wizard ?AGroupingBOverviewCAliases✓Grouping conditionsAnswerCorrect option: D. Grouping conditionsGrouping conditionsView full question & answer→
MCQ 671 MarkHow many list box can be seen in fifth step of query wizard ?✓$2$B$3$C$4$D$5$AnswerCorrect option: A. $2$$2$View full question & answer→
MCQ 681 MarkThe fifth step of query wizard is ……….ACompulsory✓optionalCCan’t sayDnone of theseAnswerCorrect option: B. optionaloptionalView full question & answer→
MCQ 691 MarkWhat is the fourth step of query wizard ?Afield selectionBSearch conditionCSorting order✓Detail or summaryAnswerCorrect option: D. Detail or summaryDetail or summaryView full question & answer→
MCQ 701 MarkIf the selected table does not contain any numeric field base skips …………. In its query wizard.A$2$✓$3$C$4$D$5$AnswerCorrect option: B. $3$ $3$View full question & answer→
MCQ 711 MarkIf only one search condition is to be set we need to choose…………..✓Match all of the followingBMatch any of the followingCBoth $(A)$ and $(B)$DNone of theseAnswerCorrect option: A. Match all of the following Match all of the followingView full question & answer→
MCQ 721 MarkWhich option is used in sezrch condition steps ?AMatch all of the followingBMatch any of the following✓Both $(A)$ and $(B)$DNone of theseAnswerCorrect option: C. Both $(A)$ and $(B)$ Both $(A)$ and $(B)$View full question & answer→
MCQ 731 MarkIn search engine we observe that we have …………..option in query wizard.✓$2$B$3$C$4$D$5$AnswerCorrect option: A. $2$ $2$View full question & answer→
MCQ 741 MarkWe can define maximum …………. Search conditions in the query.A$2$✓$3$C$4$D$5$AnswerCorrect option: B. $3$$3$View full question & answer→
MCQ 751 MarkWhat is parameter value ?✓parameterBProtometerCPrimeterDPrototypeAnswerCorrect option: A. parameterparameterView full question & answer→
MCQ 761 MarkWhat will you choose in third step of query wizard ?Aappropriate value for fieldBCondition for fieldCValue parameter for the field✓All of theseAnswerCorrect option: D. All of these All of theseView full question & answer→
MCQ 771 Mark…………… step has given facility for value parameters.AFirst BSecond✓ThirdDFourth AnswerCorrect option: C. ThirdThirdView full question & answer→
MCQ 781 Mark……….. step of the wizard we actually set up the query.AFirstBSecond✓ThirdDFourth AnswerCorrect option: C. ThirdThirdView 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.AFirstBSecond✓ThirdDFourth AnswerCorrect option: C. ThirdThirdView full question & answer→
MCQ 801 Mark…………….. is to mention the sort order.ADetail or summary✓Sorting orderCSearch conditionsDField selectionAnswerCorrect option: B. Sorting orderSorting orderView full question & answer→
MCQ 811 MarkWhat is the second step of query wizard ?AField selectionBSearch Condition✓Sorting orderDDetail or summaryAnswerCorrect option: C. Sorting orderSorting orderView full question & answer→
MCQ 821 MarkThe field that you finally select to be part of your query will be listed under.✓fields in the queryBAvailable fieldsCfields in the databaseDpresents fieldsAnswerCorrect option: A. fields in the queryfields in the queryView full question & answer→
MCQ 831 MarkFields can be arranged in the order required using …………… button.A$> \ <$B$>>\ <<$✓$T v$Dboth $(A)$ and $(B)$AnswerCorrect 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.ADeatil or summaryBSorting order ✓Search conditionsDField selectionAnswerCorrect option: C. Search conditionsSearch conditionsView full question & answer→
MCQ 851 MarkWhat is the third step of query wizard ?Afield Selection✓Search conditionsCSorting orderDDetail or summaryAnswerCorrect option: B. Search conditionsSearch conditionsView full question & answer→
MCQ 861 MarkBy what type you can arrange information in sorting order tep in query wizard ?AAscendingBDescending✓Both (A) and (B) Dnone of theseAnswerCorrect option: C. Both (A) and (B) C. Both (A) and (B)View full question & answer→
MCQ 871 MarkIt allows you to select up to ……………….. fields for deciding the sorting order of output.A$2$B$3$✓$4$D$5$AnswerCorrect option: C. $4$$4$View full question & answer→
MCQ 881 MarkThe second step of query wizard is …………………Acompulsory✓optionalCCan’tsayDnoneAnswerCorrect option: B. optionaloptionalView full question & answer→
MCQ 891 Mark……. View is useful for the user who has no previous knowledge.ADesign ViewBSQL View✓WizardDBoth $(A)$ and $(B)$AnswerCorrect option: C. WizardWizardView full question & answer→
MCQ 901 MarkIf you are database expert, you might prefer …….ADesign ViewBSQL ViewCWizard✓Both (A) and (B)AnswerCorrect option: D. Both (A) and (B)Both $(A)$ and $(B)$View full question & answer→
MCQ 911 MarkWhat is the full form of $SQL$ ?AStructure Question Language✓Structure Query LanguageC Structure Quach LanguageDStructure Quick LanguageAnswerCorrect option: B. Structure Query LanguageStructure Query LanguageView full question & answer→
MCQ 921 MarkFrom the following which language is fourth generation ?ABasicBFortran✓$SQL$D$LOGO$AnswerCorrect 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$Dboth $(A)$ and $(B)$AnswerCorrect option: B. $>> \ <<$$ >> \ <<$View full question & answer→
MCQ 941 Markcreate query in $ SQL$ View ….. user need to have knowledge about ……. Computer language.Afirst generationBsecond generationCthird generation✓fourth generationAnswerCorrect option: D. fourth generationfourth generationView 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 $Dboth $(A)$ and $(B)$AnswerCorrect option: A. $> < $$A. > <$View full question & answer→
MCQ 961 MarkThe fields that you finally select to be part of your query will be under ……list box.✓fields in the queryBavailable fieldsCfields in the databaseDpresent fieldsAnswerCorrect option: A. fields in the query fields in the queryView full question & answer→
MCQ 971 MarkFrom which list box of query wizard you can select your own choice field or all of the fields?Afields in the query✓available fieldsCfields in the databaseDpresents fieldsAnswerCorrect option: B. available fields available fieldsView full question & answer→
MCQ 981 MarkCreate query in ….. provides no guidance at all.ACreate Query in Design view…BUse Wizard to create Query✓Create Query in $SQL$ ViewDAll of theseAnswerCorrect option: C. Create Query in $SQL$ View Create Query in $SQL$ ViewView full question & answer→
MCQ 991 MarkWhich list box you can shown in query wizard in the dialog box ?Aavailable fieldsBfields in the query✓Both $(A)$ and $(B)$Dnone of theseAnswerCorrect option: C. Both $(A)$ and $(B)$Both $(A)$ and $(B)$View full question & answer→
MCQ 1001 MarkHow many total list box are shown in query wizard in the dialog box ?✓$2$B$3$C$5$D$6$AnswerCorrect option: A. $2$$2$View full question & answer→