INTRODUCTION TO DATABASE SYSTEM QUIZ

Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

ALTER TABLE

DEFINE TABLE

MODIFY TABLE

All of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?

The highest level in the hierarchy of data organization is called

data bank

data file

data record

database

TRUE ANSWER : ?
YOUR ANSWER : ?

A top-to-bottom relationship among the items in a database is established by a

All of the listed here

Hierarchical schema

Relational schema

Network schema

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is true of a network structure?

It will be the dominant data base of the future

It is conceptually simple

It is a physical representation of the data

It allows a many-to-many relationship

TRUE ANSWER : ?
YOUR ANSWER : ?

Helping people keep track of things is the purpose of a(n) ________ .

table

relationship

database

instance

TRUE ANSWER : ?
YOUR ANSWER : ?

A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

None of these

a compound key consisting of the first name and the last name

the pin code

the last name

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Each of data files has a _____ that describe the way the data is stored in the file.

Database

Fields

Records

File structure

TRUE ANSWER : ?
YOUR ANSWER : ?

In a relation, the order of the rows matters.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A file produced by a spreadsheet

is generally stored on disk in an ASCII text format

all of the listed here

can be used as it by the DBMS

can be used for graphic

TRUE ANSWER : ?
YOUR ANSWER : ?

A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑