Question 1

Explain the Oracle Database PL/SQL control-of-flow statements.

Accepted Answer

The Oracle Database PL/SQL control-of-fl

Question 2

Explain sequences and their relationship to surrogate keys.

Accepted Answer

A sequence is an Oracle Database object

Question 3

If you include a slash as the last line in an Oracle stored procedure,the procedure will be compiled and stored when you run the block of code.

Accepted Answer

A) True 
 B)False

Question 4

Oracle Database uses the SQL ALTER TABLE command to change the structure of a table.

Accepted Answer

A) True 
 B)False

Question 5

The default isolation level in Oracle Database is Read Committed,which provides statement level isolation.

Accepted Answer

A) True 
 B)False

Question 6

Oracle Database triggers BEFORE and AFTER are placed on tables,while the INSTEAD OF trigger is placed on views.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

The PL/SQL keyword STOP HERE is used to complete the basic PL/SQL block structure.

Accepted Answer

A) True 
 B)False

Question 9

The Oracle Database PL/SQL statement used to complete the basic PL/SQL block structure is:

Accepted Answer

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

Question 10

Which of the following Oracle Database structures is a logical subdivision of an Oracle Database database instance that is used to group related table,view,and other similar objects?

Accepted Answer

A) Namespace 
B) Filespace 
C) Tablespace 
D) A and B 
E) A,B and C 
A) Namespace 
B) Filespace 
C) Tablespace 
D) A and B 
E) A,B and C

Question 11

With Oracle Database,you can change the default transaction isolation for all transactions in a session by using the SET TRANSACTION ISOLATION LEVEL statement.

Accepted Answer

A) True 
 B)False

Question 12

The type of failure that occurs when Oracle Database is unable to write to a physical file is called a media failure.

Accepted Answer

A) True 
 B)False

Question 13

If the SQL statement SELECT C1,C2,C3
FROM T4
WHERE C2 = 'Smith';
Is frequently executed,which column(s)should be considered for indexing based only on the statement itself?

Accepted Answer

A) C1 only 
B) C2 only 
C) C3 only 
D) C1 and C2 
E) C1,C2,and C3 
A) C1 only 
B) C2 only 
C) C3 only 
D) C1 and C2 
E) C1,C2,and C3

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Explain the Oracle Database PL/SQL cursor statements.

Accepted Answer

The Oracle Database PL/SQL cursor statem

Question 16

The CurrVal method provides the current value in a sequence.

Accepted Answer

A) True 
 B)False

Question 17

The Read Only transaction isolation level is unique to Oracle Database.

Accepted Answer

A) True 
 B)False

Question 18

In Oracle Database,triggers that are fired once for each row that is changed in a table are called row triggers.

Accepted Answer

A) True 
 B)False

Question 19

With Oracle Database,stored procedures can be invoked remotely.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) The Oracle Enterprise Manager 11g Database Control 
B) The Oracle SQL*Plus command utility program 
C) The Oracle SQL Developer 
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 SQL Developer 
D) A and B 
E) A,B and C

Exam 11: Managing Databases With Oracle Database 11g

Explain the Oracle Database PL/SQL control-of-flow statements.

Explain sequences and their relationship to surrogate keys.

If you include a slash as the last line in an Oracle stored procedure,the procedure will be compiled and stored when you run the block of code.

Oracle Database uses the SQL ALTER TABLE command to change the structure of a table.

The default isolation level in Oracle Database is Read Committed,which provides statement level isolation.

Oracle Database triggers BEFORE and AFTER are placed on tables,while the INSTEAD OF trigger is placed on views.

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

The PL/SQL keyword STOP HERE is used to complete the basic PL/SQL block structure.

The Oracle Database PL/SQL statement used to complete the basic PL/SQL block structure is:

Which of the following Oracle Database structures is a logical subdivision of an Oracle Database database instance that is used to group related table,view,and other similar objects?

With Oracle Database,you can change the default transaction isolation for all transactions in a session by using the SET TRANSACTION ISOLATION LEVEL statement.

The type of failure that occurs when Oracle Database is unable to write to a physical file is called a media failure.

If the SQL statement SELECT C1,C2,C3 FROM T4 WHERE C2 = 'Smith'; Is frequently executed,which column(s)should be considered for indexing based only on the statement itself?

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

Explain the Oracle Database PL/SQL cursor statements.

The CurrVal method provides the current value in a sequence.

The Read Only transaction isolation level is unique to Oracle Database.

In Oracle Database,triggers that are fired once for each row that is changed in a table are called row triggers.

With Oracle Database,stored procedures can be invoked remotely.

Which of the following is a GUI tool for application development with Oracle 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