Relational Database Quiz (XII)

In the relational modes, cardinality is termed as:

• Number of tuples

• Number of attributes

• Number of tables

• Number of constraints

The view of total database content is

• Conceptual view

• Internal view

• External view

• Physical View

Cartesian product in relational algebra is

• a Unary operator

• a Binary operator

• a Ternary operator

• not defined

‘AS’ clause is used in SQL for

• Selection operation

• Rename operation

• Join operation

• Projection operation

Architecture of the database can be viewed as

• two levels

• four levels

• three levels

• one level

In a relational model, relations are termed as

• Tuples

• Attributes

• Tables

• Rows

The database schema is written in

• HLL

• DML

• DDL

• DCL

An entity set that does not have sufficient attributes to form a primary key is a

• strong entity set

• weak entity set

• simple entity set

• primary entity set

A relational database developer refers to a record as

• a criteria

• a relation

• a tuple

• an attribute

DML is provided for

• Description of logical structure of database.

• Addition of new structures in the database system.

• Manipulation & processing of database.

• Definition of physical structure of database system.