CS403 Quiz Nov 2010

An entity type is


Select correct option:



defined when the database is actually constructed

a specific type such as an integer, text, date, logical etc

a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)



defined by the database designer



Which of the following is NOT a component of a DFD?

Select correct option:



Dataflow

Datastore

External entities

Relationship between external entities



A________is used to maintain a connection between the users of the database system.

Select correct option:



mail server

file server

client-server

none of the given


User rights information is stored in

Select correct option:



Physical database

Catalog

Logical database

Buffer


Data about data is database

Select correct option:



True

False

Partially True

None of the Above



An instance is

Select correct option:



a particular occurance of an entity

a special type of relation

an attribute of an entity

any particular entity



most widely used conceptual model is the ____ model.

Select correct option:



implementation

ER

Object Oriented

internal



Who is responsible for authorizing access to the database, for coordinating and monitoring its use?

Select correct option:



Database Designer

Database Administrator

End User

Application Programmer



Within a table, each primary key value ____.

Select correct option:



is a minimal superkey

is always the first field in each table

must be numeric

must be unique



Incase of Context-level Diagram, the system is represented by

Select correct option:



One process atleast

Two processes atleast

One process only

Any number of processes