DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q381
What is a largest collection of data stored in a computer ? You might use this type of program to keep a record of all the friends in your address book.
  • A Information processing
  • B Spreadsheet
  • C Operating system
  • D Database
Answer: Option D
Q382
Which command is used to replace
  • A REPLACE
  • B REPLACE ALL
  • C Add record from edit menu
  • D All of above
Answer: Option C
Q383
All of the Following terms are related to computerized database except which one ?
  • A Search
  • B Sort
  • C Field Names
  • D Record Grab
Answer: Option A
Q384
Need to see all the information from two tables on one form . Insert
  • A A page break
  • B A subform
  • C A linked command button
  • D None of the above
Answer: Option B
Q385
What is the primary difference between a pivot table report and a cross tab query ?
  • A A Pivot table report can contain sums, counts, and averages while a cross tab query cannot.
  • B You can't pivot a cross tab query
  • C A cross tab query lets you group similar items. A Pivot table report does not
  • D None of above
Answer: Option B
Q386
The largest unit of a datbase is
  • A A record
  • B A field
  • C A subfield
  • D None of above
Answer: Option B
Q387
What's the best Access object for an invoice you'll mail to customer's ?
  • A A report
  • B A form
  • C A table
  • D All of the above
Answer: Option A
Q388
What is a grouped Report ?
  • A A type of report that can be generated by the Report Wizard
  • B A report that displays data that has been sorted in ascending or descending order
  • C A report that displays data grouped by fields you specify
  • D None
Answer: Option C
Q389
Which field allow to select items from drop down list ?
  • A An OLE field
  • B Memo Field
  • C A lookup field
  • D A hyperlink field
Answer: Option C
Q390
What did the first Table Analyzer Do ?
  • A Analyze the data in a set of flat files and automatically create a relational database system from that information
  • B Provide a graphic way to design relational databases
  • C Automate process of connecting tables to SQL Server
  • D None
Answer: Option A
Database
Back to Database
Questions and Answers for Competitive Exams Various Entrance Test