FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) The Oracle Enterprise Manager 11g Database Control
B) The Oracle SQL*Plus command utility program
C) The Oracle Database Configuration Assistant
D) A and B
E) A,B,and C

F) C) and D)
G) None of the above

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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 ________.

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

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

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

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

INSTEAD OF triggers are placed on views.

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

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

With Oracle Database,stored procedures can be invoked remotely.

Briefly describe how Oracle Database implements serializable transaction isolation.

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

What is the Oracle Enterprise Manager 11g Database Control?

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

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

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

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

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

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