RDBMSQUIZ_1(06/02/2023)

What is a relation in RDBMS?

• Key

• Table

• Row

• Data Types

Which of the following is the correct option for the given query?

SELECT DISTINCT name FROM RDBMS WHERE ID IS NOT NULL;

• a) The query gives all the possible RDBMS names where a finite value exists for ID

• b) The query gives the RDBMS names where a finite value exists for ID and it excludes identical names

• c) The query gives the names of the RDBMS that have a null ID and it also excludes identical names

• d) The query is syntactically wrong

Which of the following is the correct output for the given query?

(SELECT databaseid FROM RDBMS WHERE SECTION = 'c') EXCEPT (SELECT databaseid FROM RDBMS WHERE id < 10);

• a) All the values of the databaseid for which section is c and id > 10

• b) All the values of the databaseid for which section not c and id > 10

• c) All the values of the databaseid for which section is c and id < 10

• d) All the values of the databaseid for which section not c and id < 10

Which of the following commands do we use to delete a relation (RDBMS) from a database?

• a) delete table RDBMS

• b) drop table RDBMS

• c) delete from RDBMS

• d) drop relation RDBMS

Which of the following is the property of transaction that protects data from system failure?

• Atomicity

• Isolation

• Consistency

• Durability

During transaction before commit which of the following statement is done automatically in case of shutdown?

• Rollback

• Commit

• View

• Flashback

A relational database developer refers to a record as?

• Relation

• Tuple

• Data

• Column

The referential integrity constraint of a relational database can be specified with the help of?

• Primary Key

• Secondary Key

• Foreign Key

• None of the above

Minimal Superkeys are also called?

• Primary Key

• Candidate Key

• Foreign Key

• None of the above

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