Basics of Database Management System

V

Vinay Kumar • 8.55K Points
Tutor III

Q 31. Which of the following are common ways to enforce data validation when entering data into an Access form?

(A) Create an input mask to restrict the kind of value that can be entered in positions across the field.
(B) Define a validation rule for that field
(C) A and B
(D) none of the above
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

V

Vinay Kumar • 8.55K Points
Tutor III

Q 32. Pivot Table reports are good for

(A) Analyzing large amounts of data
(B) Turning tables upside down
(C) Breaking spreadsheet data into multiple worksheet
(D) None of above
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

V

Vinay Kumar • 8.55K Points
Tutor III

Q 33. 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
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

V

Vinay Kumar • 8.55K Points
Tutor III

Q 34. Which field allow to select items from drop down list?

(A) An OLE field
(B) A Memo Field
(C) A lookup Field
(D) A hyperlink field
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

V

Vinay Kumar • 8.55K Points
Tutor III

Q 35. 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
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

V

Vinay Kumar • 8.55K Points
Tutor III

Q 36. What’s the best Access object for an invoice you’ll mail to customers?

(A) A report
(B) A form
(C) A table
(D) All of the above
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

V

Vinay Kumar • 8.55K Points
Tutor III

Q 37. The largest unit of a database is

(A) A record
(B) A field
(C) A subfield
(D) None of above
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

V

Vinay Kumar • 8.55K Points
Tutor III

Q 38. 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 pitot table report does not
(D) None of above
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

V

Vinay Kumar • 8.55K Points
Tutor III

Q 39. 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
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share

V

Vinay Kumar • 8.55K Points
Tutor III

Q 40. All of the following terms are related to computerized databases except which one?

(A) Search
(B) Sort
(C) Field names
(D) Record grab
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share