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.✓firstBsecondCthirdDfourthAnswerCorrect option: A. firstfirstView full question & answer→
MCQ 1021 Mark……… Help us in identifyinf the field that are to be displayed in our output✓firstB secondCthidDfourthAnswerCorrect option: A. first firstView full question & answer→
MCQ 1031 MarkWhich step is compulsory of query wizard ?✓firstBsecondC thirdDfourthAnswerCorrect option: A. first firstView full question & answer→
MCQ 1041 Mark…….. wizard is provides for the query creation.ACreate Query in Design view…✓Use Wizard to create QueryCCreate Query in SQL ViewDAll of theseAnswerCorrect option: B. Use Wizard to create Query Use Wizard to create QueryView full question & answer→
MCQ 1051 MarkWhat is decided to create a query in first step?Aselect table for queryBselect field for queryCarrange field in the order✓Both $(A)$ and $(B)$AnswerCorrect 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 outputAdetail summaryBsorting orderCsearch conditions✓field selectionAnswerCorrect option: D. field selection field selectionView full question & answer→
MCQ 1071 MarkWhat is the first step querywizard ?✓field selectionBsearch conditionsC sorting orderDdetail or summaryAnswerCorrect option: A. field selection field selectionView full question & answer→
MCQ 1081 MarkHow many steps available to create a query in query wizard ?A$6$B$7$✓$8$D$9$AnswerCorrect option: C. $8$ $ 8$View full question & answer→
MCQ 1091 Mark4 icon display whom ?ATableBformCReport✓QueryAnswerCorrect option: D. Query QueryView full question & answer→
MCQ 1101 MarkFrom the following options which option is used for creating a query ?ACreate Query in Design view…BUse Wizard to create QueryCCreate Query in SQL View✓All of theseAnswerCorrect option: D. All of these All of theseView full question & answer→
MCQ 1111 MarkBy how many types you make a query ?A$2$✓$3$C$4$D$5$AnswerCorrect option: B. $3$ $3$View full question & answer→
MCQ 1121 MarkThe query window is organized like……..Atable windowBform windowCreport window✓all of theseAnswerCorrect option: D. all of these all of theseView full question & answer→
MCQ 1131 Mark……….. is a set of rules for fetching information from a table or from several table at once.AForm✓QueryCTableDreportAnswerCorrect option: B. Query QueryView full question & answer→
MCQ 1141 Mark…….. is to ask a question about the information in the database✓QueryBQuestionCQuestion bankDprimary keyAnswerCorrect option: A. QueryQueryView full question & answer→
MCQ 1151 MarkQuery basically means ……….Aasking questionBdoing enquiryCperforming analysis✓All of theseAnswerCorrect option: D. All of theseAll of theseView full question & answer→
MCQ 1161 MarkWhat is the key reasons to use database management system ?AAbility to design queryBSave the queryCUse the query as and where required✓All of theseAnswerCorrect option: D. All of these All of theseView full question & answer→
MCQ 1171 MarkThe user can retrieve data from query according to ………. Of how it is stored in the database.AThe user can retrieve data according to his choiceBcriteriaCformat irrespective✓all of theseAnswerCorrect option: D. all of these all of theseView full question & answer→
MCQ 1181 MarkQueries icon is shown in which side of database window ?ALeftBRightCUp✓DownAnswerCorrect option: D. Down DownView full question & answer→
MCQ 1191 MarkWhich icon is shown in database pane ?✓tables, QueriesBForms, ReportsCMacro, ModulesDBoth $(A)$ and $(B)$AnswerCorrect option: A. tables, Queries tables, QueriesView full question & answer→
MCQ 1201 MarkHow many icon is shown in database window ?A$2$B$3$C$4$✓$5$AnswerCorrect option: D. $5$$5$View full question & answer→
MCQ 1211 Mark………………… can be used to retrieve specific set of informationfrom database.✓QueryBForm CReportDMacroAnswerCorrect option: A. QueryQueryView full question & answer→
MCQ 1221 Mark……………. Is a huge collection of data.Atable✓DatabaseCRecordDFieldAnswerCorrect option: B. DatabaseDatabaseView full question & answer→
MCQ 1231 MarkCreate a query in …… provides a minimal amount of guidance.✓Create Query in Design view…BUse Wizard to create QueryCCreate Query in SQL ViewDAll of theseAnswerCorrect option: A. Create Query in Design view…Create Query in Design view…View full question & answer→
MCQ 1241 MarkWhich side to create a query will be shown in the tasks pane ?ALeftBRight✓UpDDownAnswerCorrect option: C. Up UpView full question & answer→
MCQ 1251 Markto create a query what to do ?AOpen a tableBOpen a database✓Open a queryDAny one of theseAnswerCorrect option: C. Open a query Open a queryView full question & answer→
MCQ 1261 MarkQuery consists of a set of records, organized in ……….Arows as per recordBcolumn as per field✓Both $(A)$ and $(B)$Dnone of theseAnswerCorrect option: C. Both $(A)$ and $(B)$Both $(A)$ and $(B)$View full question & answer→
MCQ 1271 MarkThe result of query displays in a ……… form✓tableBreportCformDqueryAnswerCorrect option: A. table tableView full question & answer→