INTRODUCTION TO DATABASE SYSTEM QUIZ

The XML family of standards is very important in database processing today.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

R:base

IDMS

DB2

dBase-II

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following indicates the minimum number of entities that must be involved in a relationship?

Maximum cardinality

Minimum cardinality

Greater Entity Count (GEC)

ERD

TRUE ANSWER : ?
YOUR ANSWER : ?

Entity instances are associated by relationship classes.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Periodically adding, changing and deleting file records is called file

renewing

upgrading

Updating

restructuring

TRUE ANSWER : ?
YOUR ANSWER : ?

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

All of the listed here

Relational schema

Network schema

Hierarchical schema

TRUE ANSWER : ?
YOUR ANSWER : ?

The Management Information system (MIS) structure with one main computer system is called a

hierarchical MIS structure

distributed MIS structure

decentralized MIS structure

centralized MIS structure

TRUE ANSWER : ?
YOUR ANSWER : ?

An attribute that names or identifies entity instances is a(n):

entity.

identifier.

attribute.

relationship.

TRUE ANSWER : ?
YOUR ANSWER : ?

A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In a large DBMS

each subschema contains every field in the logical schema

each user can "see" only a small part of the entire database

all of the listed here

each user can access every sub¬schema

TRUE ANSWER : ?
YOUR ANSWER : ?

↑