INTRODUCTION TO DATABASE SYSTEM QUIZ

Enterprise Resource Planning (ERP) is an example of a single user database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

After you _____ a record, many data management the environments require you to issue a command to save the changes you made.

Delete

Sort key

Update

Index

TRUE ANSWER : ?
YOUR ANSWER : ?

In SQL, which command is used to add new rows to a table?

ALTER TABLE

INSERT

ADD ROW

APPEND

TRUE ANSWER : ?
YOUR ANSWER : ?

The following are functions of a DBMS except ________ .

processing data

creating and processing forms

creating databases

administrating databases

TRUE ANSWER : ?
YOUR ANSWER : ?

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

File structure

Database

Records

Fields

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is a group of one or more attributes that uniquely identifies a row?

Determinant

Tuple

Relation

Key

TRUE ANSWER : ?
YOUR ANSWER : ?

In SQL, which command is used to add a column/integrity constraint to a table

ALTER TABLE

MODIFY TABLE

INSERT COLUMN

ADD COLUMN

TRUE ANSWER : ?
YOUR ANSWER : ?

Sophisticated report generators can

perform arithmetic operations

All of the listed here

selectively retrieve and print portions of a list

print row-oriented reports

TRUE ANSWER : ?
YOUR ANSWER : ?

A set of programs that handle a firm's data base responsibilities is called a

None of these

Data Base Management System (DBMS)

Data Base Processing System (DBPS)

All of these

Data Management System (DMS)

TRUE ANSWER : ?
YOUR ANSWER : ?

↑