INTRODUCTION TO DATABASE SYSTEM QUIZ

Entities can be associated with one another in which of the following?

Relationships

Attributes

Identifiers

Entities

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

data manipulation language

transaction log

report writer

None of these

query language

TRUE ANSWER : ?
YOUR ANSWER : ?

A form defines

the width of each field

where data is placed on the screen

both of the listed here

none of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?

Microsoft Access is an enterprise-class database product.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The only reason for the existence of relations is to store instances of functional dependencies.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

If you want to group the records in the abc database, you could use the Jobcode as the _____.

Delete

Sort Key

Index

Update

TRUE ANSWER : ?
YOUR ANSWER : ?

The distinguishable parts of a record are called

data

fields

database

None of these

files

TRUE ANSWER : ?
YOUR ANSWER : ?

A relation is in this form if it is in BCNF and has no multivalued dependencies:

second normal form.

third normal form.

fourth normal form.

domain/key normal form.

TRUE ANSWER : ?
YOUR ANSWER : ?

If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.

Update

None of these

Index

Delete

Sort Key

TRUE ANSWER : ?
YOUR ANSWER : ?

↑