INTRODUCTION TO DATABASE SYSTEM QUIZ

In which of the following is a single-entity instance of one type related to many entity instances of another type?

Many-to-Many Relationship

Composite Relationship

One-to-One Relationship

One-to-Many Relationship

TRUE ANSWER : ?
YOUR ANSWER : ?

The model for a record management system might be

None of these

All of these

handwritten list

a Rolodex card file

a business form

TRUE ANSWER : ?
YOUR ANSWER : ?

In SQL, which command is used to select only one copy of each set of duplicable rows

None of these

All of these

SELECT UNIQUE

SELECT DISTINCT

SELECT DIFFERENT

TRUE ANSWER : ?
YOUR ANSWER : ?

In a relation, the order of the columns does not matter.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Data item characteristics that are important in data management include

spelling

punctuation

width

language

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype entity is a special case of another entity called a supertype entity.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

REMOVE INDEX

ROLL BACK INDEX

DROP INDEX

DELETE INDEX

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

If attribute A determines both attributes B and C, then it is also true that:

B →

A →

(B,C) →

C →

TRUE ANSWER : ?
YOUR ANSWER : ?

An Enterprise Resource Planning application is an example of a(n) ________ .

data mining database application

single-user database application

e-commerce database application

multiuser database application

TRUE ANSWER : ?
YOUR ANSWER : ?

↑