DBMS LAB Quiz 2

Which of the following is an example of a DBMS

• SQL

• Microsoft Office

• PHP

• Oracle

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

• Delete

• Remove

• Truncate

• Both [A] and [B]

The statement in SQL which allows to change the definition of a table is

• Alter

• Update

• Create

• Select

can a primary key be null

• yes

• no

An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.

• 3, 20

• 20, 4

• 20, 20

• 3, 4

To preserve the integrity and consistency of data, the database system must ensure

• Atomicity

• Isolation

• Durability

• Consistency

• All of the above

for the following two entities which one is the correct option CUTOMER/ORDER

• one to one

• one to many

• many to one

DBA stands for

• Data Bank Access

• Database Access

• Data Bank Administration

• Database Administrator

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