Question 1

Which type of trigger is commonly used to update views?

Accepted Answer

A) BEFORE triggers 
B) AFTER triggers 
C) SELECT triggers 
D) INSTEAD OF triggers 
E) UPDATE triggers 
A) BEFORE triggers 
B) AFTER triggers 
C) SELECT triggers 
D) INSTEAD OF triggers 
E) UPDATE triggers D

Question 2

The GUI tool for creating a new index is the Oracle SQL Developer ________.

Accepted Answer

A) Edit Table table editor 
B) Edit Index index editor 
C) Edit Schema schema editor 
D) A and B 
E) A,B and C 
A) Edit Table table editor 
B) Edit Index index editor 
C) Edit Schema schema editor 
D) A and B 
E) A,B and C A

Question 3

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

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 B

Question 4

Which of the following is an account name for which you are asked to enter a password when Oracle Database creates a new database?

Accepted Answer

A) SYSTEM 
B) SYS 
C) INTERNAL 
D) A and B 
E) A,B and C 
A) SYSTEM 
B) SYS 
C) INTERNAL 
D) A and B 
E) A,B and C

Question 5

The type of failure that occurs when Oracle Database itself fails due to an operating system or computer hardware failure is called an instance failure.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

You can include single line comments in an Oracle Database stored procedure by starting each comment line with the /* symbol.

Accepted Answer

A) True 
 B)False

Question 8

The NextVal method provides the next value in a sequence.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Which of the following can Oracle Database not support?

Accepted Answer

A) Triggers that are fired when SQL commands create new database structures. 
B) Triggers that are fired before each row change in a table. 
C) Triggers that are fired once when changes are made to rows in a table. 
D) Triggers that are fired after each row change in a table. 
E) All of the above are supported. 
A) Triggers that are fired when SQL commands create new database structures. 
B) Triggers that are fired before each row change in a table. 
C) Triggers that are fired once when changes are made to rows in a table. 
D) Triggers that are fired after each row change in a table. 
E) All of the above are supported.

Question 11

The Oracle Database variant of SQL with additional procedural language components is:

Accepted Answer

A) T-SQL. 
B) PL/SQL. 
C) My/SQL. 
D) MS/SQL. 
E) SQL. 
A) T-SQL. 
B) PL/SQL. 
C) My/SQL. 
D) MS/SQL. 
E) SQL.

Question 12

Instead of creating a new database instance in Oracle Database,it is preferable to create a new tablespace.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) Instance failure 
B) Administrative failure 
C) Media failure 
D) Logic failure 
E) Application failure 
A) Instance failure 
B) Administrative failure 
C) Media failure 
D) Logic failure 
E) Application failure

Question 14

What is SQL*Plus?

Accepted Answer

SQL*Plus is a character-based command li

Question 15

Which method returns the next value in a sequence?

Accepted Answer

A) CountVal 
B) Next 
C) UpVal 
D) NextVal 
E) Append 
A) CountVal 
B) Next 
C) UpVal 
D) NextVal 
E) Append

Question 16

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:

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

Briefly describe how Oracle Database implements serializable transaction isolation.

Accepted Answer

Whenever a transaction begins,Oracle Dat

Question 19

Which of the following Oracle Database ReDo files are stored on disk and contain the rollback segments from recent database changes?

Accepted Answer

A) OnLine ReDo files. 
B) Active ReDo files. 
C) OffLine ReDo files. 
D) Archive ReDo files. 
E) All of the above. 
A) OnLine ReDo files. 
B) Active ReDo files. 
C) OffLine ReDo files. 
D) Archive ReDo files. 
E) All of the above.

Question 20

The PL/SQL keyword RETURN is used to exit a block of code and terminate whatever code structure is running.

Accepted Answer

A) True 
 B)False

Exam 11: Managing Databases With Oracle Database 11g

Which type of trigger is commonly used to update views?

The GUI tool for creating a new index is the Oracle SQL Developer ________.

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

Which of the following is an account name for which you are asked to enter a password when Oracle Database creates a new database?

The type of failure that occurs when Oracle Database itself fails due to an operating system or computer hardware failure is called an instance failure.

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

You can include single line comments in an Oracle Database stored procedure by starting each comment line with the /* symbol.

The NextVal method provides the next value in a sequence.

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

Which of the following can Oracle Database not support?

The Oracle Database variant of SQL with additional procedural language components is:

Instead of creating a new database instance in Oracle Database,it is preferable to create a new tablespace.

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

What is SQL*Plus?

Which method returns the next value in a sequence?

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 Oracle Database security,a Role can have many system privileges.

Briefly describe how Oracle Database implements serializable transaction isolation.

Which of the following Oracle Database ReDo files are stored on disk and contain the rollback segments from recent database changes?

The PL/SQL keyword RETURN is used to exit a block of code and terminate whatever code structure is running.

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