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

Question : 1

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 : 2

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 : 3

What is the first step in creating a form or report with the form wizard or report wizard?

a) Selecting the fields that you want to appear in the form or report

b) Selecting the underlying table or query on which you want to base the form or report

c) Reading several screens of mostly useless information and clicking next

d) Selecting how the form or report should be formatted

Question : 4

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

a) Search

b) Sort

c) Field names

d) Record grab

Question : 5

A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As

a) Tables

b) Relations

c) Tuple

d) Both (A) and (B)

Question : 6

COPY STRUCTURE command is used to

a) Copy contents of an active database to a new file

b) Copy all records of an active database to disk

c) Copy contents of an active database to disk

d) Copy structure of an active database to a new file