Sail E0 Webinar

MCQs

Total Questions : 229 | Page 9 of 23 pages
Question 81. This DBMS feature allows users to easily interrogate a database. Select the best fit for answer
  1.    Database management approach
  2.    DBMS uses
  3.    Database administrator
  4.    Query language
 Discuss Question
Answer: Option C. -> Database administrator
Answer: (c)
Question 82. How do you update Pivot Table report data after changes are made to the source data?
  1.    Save your changes, close the workbook, and then reopen it.
  2.    Select the Pivot Table worksheet and press F9 on the keyboard
  3.    Click the report, and on the Pivot Table toolbar, click the refresh data button
  4.    All of the above
 Discuss Question
Answer: Option C. -> Click the report, and on the Pivot Table toolbar, click the refresh data button
Answer: (c)
Question 83. Which of the following are common ways to enforce data validation when entering data into an Access form?
  1.    Create an input mask to restrict the kind of value that can be entered in positions across the field.
  2.    Define a validation rule for that field
  3.    A and B
  4.    none of the above
 Discuss Question
Answer: Option C. -> A and B
Answer: (c)
Question 84. In Form view, which command displays records alphabetically?
  1.    Find
  2.    Advanced Filter/Sort
  3.    Sort
  4.    All of the above
 Discuss Question
Answer: Option C. -> Sort
Answer: (c)
Question 85. The largest unit of a database is
  1.    A record
  2.    A field
  3.    A subfield
  4.    None of above
 Discuss Question
Answer: Option B. -> A field
Answer: (b)
Question 86. An identification field in a record. Select the best fit for answer
  1.    Record
  2.    File
  3.    Database
  4.    Key field
 Discuss Question
Answer: Option C. -> Database
Answer: (c)
Question 87. The complete picture of data stored in database is known as
  1.    Record
  2.    Scheme
  3.    System flowchart
  4.    DBMS
 Discuss Question
Answer: Option B. -> Scheme
Answer: (b)
Question 88. Which control does access use to link data access page components to access data?
  1.    Microsoft Dynamic Data Control
  2.    Microsoft Data Connection Control
  3.    Microsoft Office Data Source Control
  4.    None of the above
 Discuss Question
Answer: Option C. -> Microsoft Office Data Source Control
Answer: (c)
Question 89. Which custom date format displays the numeric day of the year when a date is entered?
  1.    YY
  2.    YYYY
  3.    Y
  4.    All of above
 Discuss Question
Answer: Option C. -> Y
Answer: (c)
Question 90. The DBMS that is most difficult to use is ________ .
  1.    Microsoft’s SQL Server
  2.    Microsoft’s Access
  3.    IBM’s DB2
  4.    Oracle Corporation’s Oracle
  5.    None of these
 Discuss Question
Answer: Option D. -> Oracle Corporation’s Oracle
Answer: (d)

Latest Videos

Latest Test Papers