Shortcut Navigation:

Database Management Quiz

You are managing the in-house database systems.You need to ensure that the user AMY can execute all operations against the SALES relation. What SQL statement sequence will you use?

You are managing the in-house database systems. You are creating a series of secondary indexes in your relational database. By doing so, which of the following issues must be carefully considered .

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 ?

Which of the following types of JDBC drivers allows your Java programs to communicate with the ODBC driver of your DBMS?

In your program you want to use the JDBC-ODBC Bridge driver. What code do you use?

Which of the following correctly describe the sequence of the DBMS operational process?

You reject someone's proposal to use File-based databases. Which of the following are the disadvantages of such databases?

Which of the following are valid rowset classes that you can use in your Java application ?

Which of the following correctly describe the locking mechanism in a RDBMS?

In the world of SQL relational database, the data type for varchar, in general, is:

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?