INTRODUCTION TO DATABASE SYSTEM QUIZ

Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

Instance entity

Supertype entity

Subtype entity

Archetype entity

TRUE ANSWER : ?
YOUR ANSWER : ?

A network schema

restricts the structure to a one-to-many relationship

permits many-to-many relation¬ships

stores data in tables

All of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?

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

All of the listed here

DEFINE TABLE

MODIFY TABLE

ALTER TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

In a relation, the columns are sometimes called "attributes".

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In SQL, which command is used to create a database user?

CREATE USER

All of the listed here

MK USER

ADD USER TO DATABASE

TRUE ANSWER : ?
YOUR ANSWER : ?

In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

instance

child

subtype

parent

TRUE ANSWER : ?
YOUR ANSWER : ?

A ternary relationship is so called because in contains two entities and one association between them.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Updating a database means

revising the file structure

reorganizing the database

all of the listed here

modifying or adding record occurrences

TRUE ANSWER : ?
YOUR ANSWER : ?

If you want your database to include methods, you should use a _____ database.

Network

Object-Oriented

Distributed

Hierarchical

TRUE ANSWER : ?
YOUR ANSWER : ?

↑