DBMS

The data model which describes how the data is actually stored is

• internal model

• external model

• logical model

• none of these

Data about data is normally termed as

• directory

• data bank

• meta data

• none of the above

A view of database that appears to an application program is known as

• schema

• subschema

• virtual table

• none of the above

Collection of information stored in a database at a particular moment is

• view

• schema

• instance

• none of the above

DBA stands for

• Data Bank Access

• Database Access

• Data Bank Administration

• Database Administrator

Data items grouped together for storage purposes are called a :

• Record

• title

• list

• string

A function that has no partial functional dependencies is in _______ form

• 3NF

• 2NF

• 4NF

• BCNF

Every Boyee-Codd normal form is in

• 1NF

• 2Nf

• 3NF

• all the above

If every non-key attribute is functionally dependent on the primary key, then the relation will be in :

• 1NF

• 2NF

• 3NF

• 4NF

Which command is used to remove all rows from a table ?

• Delete

• Remove

• Truncate

• Both [A] and [B]