VVCE_SQL_RDBMS_1

RDMBs has been designed to handle what kind of data?

• Semi-Structured

• Unstructured

• Structured only

• Both Structured and Unstructured data

"create" command falls under which category?

• DDL

• DML

• DCL

• TCL

A column that is a foreign key referencing Primary Key of another table cannot have Null values

• True

• False

Which of the following is NOT correct wrt RDBMS?

• Consistency may not be maintained at times

• There is a solid structure attached to each table

• Data is in the form of Rows and Columns

• While storing Sequence of records is insignificant

You had a bank balance of Rs. 1000 and you just sent Rs. 500 to a friend. After sending the money, the app still shows that you have a bank balance of Rs. 1000. What aspect of ACID property is compromised here?

• Atomicity

• Consistency

• Durability

• Isolation

A foreign key (FK) can only have reference to Primary key (PK) of another table?

• True, FK can only refer to PK of another table

• It can have reference to a column that has Unique Constraint as well

• It can refer to any column

• It can refer to any column that doesn't have NULL values

What is the difference between Primary Key and Unique Constraint?

• Both are same

• Primary key doesn't allow Null values where as Unique constraint allows Nulls

• Primary key allows Null values where as Unique constraint doesn't allow Nulls

• There can be multiple primary keys in a table but only one unique constraint column