Tag: database

Multiple choice database

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

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

Reveal answer Fill a bubble to check yourself