Exam 11: Managing Databases With Oracle Database

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

Each Oracle Database tablespace has one or more datafiles associated with it.

The CurrVal method provides the current value in a sequence.

Which of the following is a GUI tool for application development with Oracle Database?

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

Which method returns the next value in a sequence?

INSTEAD OF triggers are placed on views.

You can use the Edit Table table editor to create an index in Oracle Database.

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

In Oracle Database,to achieve transaction level consistency,which level of transaction isolation must be used?

What is the Database Configuration Assistant (DBCA)?

For which of the following types of failure would Oracle Database use Offline ReDo files as part of a recovery effort?

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

Explain the Oracle Database PL/SQL Block Structure.

The PL/SQL keywords FOR,WHILE,and LOOP are used to create blocks of code that repeat until an ending condition is reached.

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

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

The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements as long as some condition is true is ________.

The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.

The Oracle Enterprise Manager Database Express 12c is a Web-based Oracle Database administration utility.