INTRODUCTION TO DATABASE SYSTEM QUIZ

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 →

(B,C) →

TRUE ANSWER : ?
YOUR ANSWER : ?

A database is called "self-describing" because it contains a description of itself.

True

False

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.

Delete

None of these

Update

Index

Sort Key

TRUE ANSWER : ?
YOUR ANSWER : ?

When using a database management system, the first thing that you must do is to

activate file editor

create a database file

load the software into your micro¬computer

keep a floppy disk in readiness

TRUE ANSWER : ?
YOUR ANSWER : ?

In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.

child

instance

parent

subtype

TRUE ANSWER : ?
YOUR ANSWER : ?

A recursive relationship is a relationship between an archetype and an instance of that archetype.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An attribute describes the entity's characteristics.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

For some relations, changing the data can have undesirable consequences called:

transitive dependencies.

referential integrity constraints.

modification anomalies.

normal forms.

TRUE ANSWER : ?
YOUR ANSWER : ?

A multiple-form file management system

lets you define different forms for different operations

lets you create a look-up form with an associated read-only password to prevent access by unauthorized users

allow you to entry data in all the forms

None of these

both (a) and (b)

TRUE ANSWER : ?
YOUR ANSWER : ?

Which command is used to remove a table from the database in SQL?

UNATTACH TABLE

DROP TABLE

DELETE TABLE

ERASE TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?