Question 1

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

Accepted Answer

A) Read Committed 
B) Serializable 
C) Repeatable Read 
D) Read Only 
E) Read Uncommitted 
A) Read Committed 
B) Serializable 
C) Repeatable Read 
D) Read Only 
E) Read Uncommitted

Question 2

The Oracle Database GUI provides graphical facilities for managing databases.

Accepted Answer

A) True 
 B)False

Question 3

The Oracle Database Configuration Assistant is the easiest Oracle Database tool to use when you are creating an Oracle database.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not a transaction isolation level supported by Oracle Database?

Accepted Answer

A) Read Committed 
B) Serializable 
C) Repeatable Read 
D) Read Only 
E) All of the above are supported. 
A) Read Committed 
B) Serializable 
C) Repeatable Read 
D) Read Only 
E) All of the above are supported.

Question 5

INSTEAD OF triggers are placed on views.

Accepted Answer

A) True 
 B)False

Question 6

The Oracle Database GUI is the Oracle SQL Browser.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

In Oracle Database recovery facilities,OnLine ReDo files are backup log files maintained separately and not necessarily on disk media.

Accepted Answer

A) True 
 B)False

Question 9

Explain the Oracle Database PL/SQL Block Structure.

Accepted Answer

The Oracle Database PL/SQL block structu

Question 10

In Oracle Database,which of the following prefixes is only available to triggers?

Accepted Answer

A) :current 
B) := same 
C) :new 
D) := current 
E) :insert 
A) :current 
B) := same 
C) :new 
D) := current 
E) :insert

Question 11

Oracle Database only reads committed changes,and therefore dirty reads are not possible.

Accepted Answer

A) True 
 B)False

Question 12

All Oracle Database triggers work at the row level.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following tasks can be done using the Oracle SQL Developer?

Accepted Answer

A) See the structure of a table 
B) Add and remove columns from a table 
C) Insert and delete data from a table 
D) A and B 
E) A,B and C 
A) See the structure of a table 
B) Add and remove columns from a table 
C) Insert and delete data from a table 
D) A and B 
E) A,B and C

Question 14

The Oracle Database PL/SQL statement used to define a set of PL/SQL statements is:

Accepted Answer

A) DECLARE. 
B) BEGIN. 
C) IF...THEN...ELSE...END IF. 
D) LOOP. 
E) END;. 
A) DECLARE. 
B) BEGIN. 
C) IF...THEN...ELSE...END IF. 
D) LOOP. 
E) END;.

Question 15

Oracle Database does not require the use of Archive ReDo files for instance recovery.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following Oracle Database PL/SQL statements is used to create a block of code that repeats while some condition is true?

Accepted Answer

A) FOR 
B) WHILE 
C) LOOP 
D) A and B 
E) A,B and C 
A) FOR 
B) WHILE 
C) LOOP 
D) A and B 
E) A,B and C

Question 17

In Oracle Database recovery facilities,OnLine ReDo files are maintained on disk and contain the rollback segments from recent database changes.

Accepted Answer

A) True 
 B)False

Question 18

When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

When creating a new database in Oracle Database,two new account passwords are automatically created in the database.

Accepted Answer

A) True 
 B)False

Exam 11: Managing Databases With Oracle Database 11g

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

The Oracle Database GUI provides graphical facilities for managing databases.

The Oracle Database Configuration Assistant is the easiest Oracle Database tool to use when you are creating an Oracle database.

Which of the following is not a transaction isolation level supported by Oracle Database?

INSTEAD OF triggers are placed on views.

The Oracle Database GUI is the Oracle SQL Browser.

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

In Oracle Database recovery facilities,OnLine ReDo files are backup log files maintained separately and not necessarily on disk media.

Explain the Oracle Database PL/SQL Block Structure.

In Oracle Database,which of the following prefixes is only available to triggers?

Oracle Database only reads committed changes,and therefore dirty reads are not possible.

All Oracle Database triggers work at the row level.

Which of the following tasks can be done using the Oracle SQL Developer?

The Oracle Database PL/SQL statement used to define a set of PL/SQL statements is:

Oracle Database does not require the use of Archive ReDo files for instance recovery.

Which of the following Oracle Database PL/SQL statements is used to create a block of code that repeats while some condition is true?

In Oracle Database recovery facilities,OnLine ReDo files are maintained on disk and contain the rollback segments from recent database changes.

When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

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

When creating a new database in Oracle Database,two new account passwords are automatically created in the database.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2008 R2

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters