INTRODUCTION TO DATABASE SYSTEM QUIZ

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

Data Base Management System (DBMS)

Data Base Processing System (DBPS)

None of these

Data Management System (DMS)

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is an identifier of another entity.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

ALTER TRIGGERS

MODIFY TRIGGERS IN TABLE

ALTER TABLE

All of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?

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

modification anomalies.

referential integrity constraints.

normal forms.

transitive dependencies.

TRUE ANSWER : ?
YOUR ANSWER : ?

In SQL, which command is used to changes data in a table?

INSERT

UPDATE

BROWSE

APPEND

TRUE ANSWER : ?
YOUR ANSWER : ?

Which language has recently become the de-facto standard for interfacing application programs with relational database system?

4GL

SQL

None of these

dBASE

Oracle

TRUE ANSWER : ?
YOUR ANSWER : ?

A number of related records that are treated as a unit is called

data

field

batch

file

TRUE ANSWER : ?
YOUR ANSWER : ?

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

One-to-One Relationship

Composite Relationship

One-to-Many Relationship

Many-to-Many Relationship

TRUE ANSWER : ?
YOUR ANSWER : ?

If you want to group the records in the abc database, you could use the Jobcode as the _____.

Update

Sort Key

Index

Delete

TRUE ANSWER : ?
YOUR ANSWER : ?

An attribute describes the entity's characteristics.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑