Exam 10: B: Managing Databases With Oracle Database 11g Release 2

The Oracle database PL/SQL statement used to test for a condition and then direct when blocks of code should be run depending on the outcome of the test is ________.

What is the Oracle Enterprise Manager 11g Database Control?

With Oracle Database,data must be entered at the Oracle Database command prompt.

The PL/SQL keyword ISTHERE is used to test for the existence of a condition.

In Oracle Database backup and recovery facilities,a consistent backup is one in which all uncommitted changes have been removed from the datafiles.

When creating tables,Oracle Database automatically converts the SQL standard data type "int" into:

In the event of an application failure,Oracle Database uses the in-memory rollback segments and OnLine ReDo files to recover.

The Oracle Database PL/SQL block structure begins with ________.

Which of the following is a tool for managing an existing Oracle Database database?

Briefly describe how Oracle Database implements serializable transaction isolation.

The Oracle Database GUI tool used for application development is the Oracle SQL Developer.

In Oracle Database security,a System Privilege is the right to general tasks such as performing some action on the database data.

Among its many functions,SQL*Plus is also a text editor.

The prefix :old is used with values of columns available to update and delete triggers.

Which of the following is the default transaction isolation level offered by Oracle Database?

The prefix :new is used with values of columns available to insert and update triggers.

In Oracle Database security,a Role can have many system privileges.

With Oracle Database,stored procedures can be invoked remotely.

INSTEAD OF triggers are placed on views.

In Oracle Database recovery facilities,control files are small files that describe the name,contents,and locations of various files used by Oracle Database.