INTRODUCTION TO DATABASE SYSTEM QUIZ

Which command is used to select distinct subject (SUB) from the table (BOOK)?

None of these

All of these

SELECT DISTINCT SUB FROM BOOK

SELECT ALL FROM BOOK

SELECT SUB FROM BOOK

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not a relational database?

FoxPro

4th Dimension

dBASE IV

Reflex

TRUE ANSWER : ?
YOUR ANSWER : ?

In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The distinguishable parts of a record are called

database

fields

files

data

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Data item characteristics that are important in data management include

width

punctuation

language

spelling

TRUE ANSWER : ?
YOUR ANSWER : ?

In a relation, the rows are sometimes called "records".

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A primary key is a composite key that was selected to be the main identifier for the relation.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In which of the following can many entity instances of one type be related to many entity instances of another type?

One-to-Many Relationship

Composite Relationship

Many-to-Many Relationship

One-to-One Relationship

TRUE ANSWER : ?
YOUR ANSWER : ?

Applications are programs that interact directly with the database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A race condition occurs when

two users of the DBMS are interacting with different files at the same time

Two concurrent activities interact to cause a processing error

None of the listed here

Both of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?