INTRODUCTION TO DATABASE SYSTEM QUIZ

Which of the following products implemented the CODASYL DBTG model?

R:base

IDMS

dBase-II

DB2

TRUE ANSWER : ?
YOUR ANSWER : ?

All instances of an entity class have the same attributes.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Queries to a database

both (a) and (b)

are written in English

All of these

can use aggregate functions like SUM and COUNT

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

1:1, 1:N and N:M relationships are also known as HAS-A relationships.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Given the functional dependency R → (S,T) , then it is also true that R → S.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In which of the following can many entity instances of one type be related to many entity instances of another type?

Many-to-Many Relationship

One-to-One Relationship

Composite Relationship

One-to-Many Relationship

TRUE ANSWER : ?
YOUR ANSWER : ?

A recursive relationship is a relationship between an entity and ________ .

an archetype entity

an instance entity

a subtype entity

itself

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

data manipulation language

query language

report writer

transaction log

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.

Flat file

Data structure

Table

None of these

Database

TRUE ANSWER : ?
YOUR ANSWER : ?

One approach to standardizing storing of data

MIS

CODASYL specifications

None of these

All of these

structured programming

TRUE ANSWER : ?
YOUR ANSWER : ?

↑