Shortcut Navigation:

Properly Designed DBMS Quiz

You run a SELECT statement, and multiple duplicates of values are retrieved. What keyword can you use to retrieve only the non duplicate data?

Which of the following elements are the valid components of ACID in a relational database transaction?

In JDBC, what represents a single instance of a particular database session?

What statement do you use to remove a schema and its related objects from your relational database?

In a properly designed DBMS, concurrency control is provided by which of the following components.

Which of the following are valid CREATE statements in the world of DDL?

What statement do you use to remove a schema and ensure that the removal takes place only if the schema is empty?

What is used by a properly designed DBMS to enable databases to be returned to the pre-transaction state should errors occur?

Under JDBC, which of the following types of instances can be created by the Connection object?

Which of the following are the factors to consider when you want to select a DBMS based on the criteria of physical capabilities, as recommended by CIW ?