INTRODUCTION TO DATABASE SYSTEM QUIZ

Given the functional dependency R → S , R is called the determinant.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which command is used to remove an index from the database in SQL?

REMOVE INDEX

DROP INDEX

ROLL BACK INDEX

DELETE INDEX

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?

None of these

transaction log

report writer

query language

data manipulation language

TRUE ANSWER : ?
YOUR ANSWER : ?

Data item characteristics that are important in data management include

language

spelling

punctuation

width

TRUE ANSWER : ?
YOUR ANSWER : ?

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

A →

(B,C) →

A →

A → (B,C).

TRUE ANSWER : ?
YOUR ANSWER : ?

Sophisticated report generators can

print row-oriented reports

selectively retrieve and print portions of a list

All of the listed here

perform arithmetic operations

TRUE ANSWER : ?
YOUR ANSWER : ?

In SQL, which command(s) is(are) used to create a synonym for a schema object?

CREATE SCHEMA

CREATE SAME

CREATE SYNONYM

All of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?

The relational model uses some unfamiliar terminology. A tuple is equivalent to a

field

data base

data item

record

TRUE ANSWER : ?
YOUR ANSWER : ?

In the relational model, relationships between relations or tables are created by using:

candidate keys.

foreign keys.

composite keys.

determinants.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑