SQL and DBMS Quiz 2

How many properties of transactions are there?

• A. 4

• B. 5

• C. 6

• D. 7

What is the purpose of the DISTINCT keyword in SQL?

• A. It filters the rows returned by the SELECT statement.

• B. It specifies the columns to be retrieved.

• C. It removes duplicate rows from the result set.

• D. It orders the results in ascending or descending order.

RDBMS applications stores data

• A. In tabular form

• B. As file

• C. Both a and b

• D. None of the above

What For each attribute of a relation, there is a set of permitted values, called the of that attribute.

• A. Dictionaries

• B. Domain

• C. Directory

• D. Relation

What does NULL value specify in RDBMS?

• A. The field is set to Zero

• B. The field is set to Infinite

• C. The field is left blank

• D. The field is set to Whole Number

X is read from a database and stored in a buffer in main memory with the operation.

• A. Read

• B. Write

• C. Commit

• D. Rollback

Redundancy is reduced in a database table by using the form.

• A. Abnormal

• B. Normal

• C. Special

• D. None

In what format data is stored in DBMS?

• A. Hierarchal form

• B. Navigational form

• C. Both A. and B.

• D. None of the above

In DBMS -

• A. There is no relation between the tables

• B. There is relation between the tables

• C. There is custom relation between the databases

• D. There is data value relation between the databases

Which of the following is not a type of Normal Form?

• A. 1NF

• B. 2NF

• C. 3NF

• D. 10NF