INTRODUCTION TO DATABASE SYSTEM QUIZ

An on-line commercial site such as Amazon.com is an example of a(n) ________ .

multiuser database application

single-user database application

e-commerce database application

data mining database application

TRUE ANSWER : ?
YOUR ANSWER : ?

A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

File structure

Database

Fields

Records

TRUE ANSWER : ?
YOUR ANSWER : ?

A top-to-bottom relationship among the items in a database is established by a

All of the listed here

Hierarchical schema

Relational schema

Network schema

TRUE ANSWER : ?
YOUR ANSWER : ?

Row is synonymous with the term:

relation.

field.

column.

record.

TRUE ANSWER : ?
YOUR ANSWER : ?

In a database, data is stored in spreadsheets which have rows and columns.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A computer file can be best described as

None of these

a general collection of data items

a random collection of data items

a single data item

an orderly collection of data items

TRUE ANSWER : ?
YOUR ANSWER : ?

In SQL, GRANT command is used to

allow user to create databases

None of the listed here

allow user to access databases

grant system privileges, roles, and object privileges to uses and roles

TRUE ANSWER : ?
YOUR ANSWER : ?

The database administration function includes

computer operations management

All of these

None of these

application programming

database access planning

TRUE ANSWER : ?
YOUR ANSWER : ?

The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

Characters

None of the listed here

Bits

Data field

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is a database administrator's function?

backing up the database

database design

performance monitoring

All of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?

↑