data base management system (DBMS) set 3 Detailed Explanation And More Example

Question : 1

Customers, Orders. What’s their best relationship?

a) Many-to-many

b) One-to-one

c) One-to-many

d) All of the above

Question : 2

This DBMS feature allows users to easily interrogate a database. Select the best fit for answer

a) Database management approach

b) DBMS uses

c) Database administrator

d) Query language

Question : 3

How do you update Pivot Table report data after changes are made to the source data?

a) Save your changes, close the workbook, and then reopen it.

b) Select the Pivot Table worksheet and press F9 on the keyboard

c) Click the report, and on the Pivot Table toolbar, click the refresh data button

d) All of the above

Question : 4

Which action will optimize your database performance?

a) Set the record set type to Snapshot

b) Use the compact and repair database tool

c) Create a replica of the database

d) All of the above

Question : 5

The ascending order of a data hierarchy ios:

a) Bit, byte, field, record, file, database

b) Bit, byte, record, field, file, database

c) Byte, bit, field, record, file, database

d) Byte, bit, record, field, file, database

Question : 6

What is a stored question about information in a database?

a) Record

b) Field

c) Report

d) Query