Question 1

The Oracle Database PL/SQL block structure begins with:

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 2

With Oracle Database,stored procedures cannot use a cursor variable,so another method must be used to access a table on a row by row basis.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is the easiest tool for creating a database with Oracle 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 C 
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 C 
E) A,B and C

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Oracle Database uses a System Change Number (SCN)to identify before images in rollback segments to prevent dirty reads.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statements would cause Oracle Database to include a new column named C5,which is a two-digit whole number,to a table named T2?

Accepted Answer

A) UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2); 
B) ALTER TABLE T2 ADD COLUMN C5 NUMBER (2); 
C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0); 
D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0); 
E) ALTER TABLE T2 ADD C5 NUMBER (2); 
A) UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2); 
B) ALTER TABLE T2 ADD COLUMN C5 NUMBER (2); 
C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0); 
D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0); 
E) ALTER TABLE T2 ADD C5 NUMBER (2);

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

What is the Database Configuration Assistant (DBCA)?

Accepted Answer

The Oracle Database Configuration Assist

Question 10

Which of the following commands does Oracle Database not support?

Accepted Answer

A) CREATE TABLE 
B) CREATE CONSTRAINT 
C) ALTER TABLE 
D) ON UPDATE CASCADE 
E) ON DELETE CASCADE 
A) CREATE TABLE 
B) CREATE CONSTRAINT 
C) ALTER TABLE 
D) ON UPDATE CASCADE 
E) ON DELETE CASCADE

Question 11

The default file extension for text files created for SQL Develope is .sql.

Accepted Answer

A) True 
 B)False

Question 12

With Oracle Database,using a sequence does not guarantee valid surrogate key values.

Accepted Answer

A) True 
 B)False

Question 13

Oracle Database supports the ON UPDATE CASCADE constraint.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is true of Oracle Database when the isolation level is set to Serializable?

Accepted Answer

A) It will update any row having an SCN greater than the Transaction SCN. 
B) It will delete any row having an SCN greater than the Transaction SCN. 
C) It will read any row having an SCN greater than the Transaction SCN. 
D) It will wait for a blocking transaction to release an exclusive lock. 
E) It will not generate an error if the transaction must be rolled back. 
A) It will update any row having an SCN greater than the Transaction SCN. 
B) It will delete any row having an SCN greater than the Transaction SCN. 
C) It will read any row having an SCN greater than the Transaction SCN. 
D) It will wait for a blocking transaction to release an exclusive lock. 
E) It will not generate an error if the transaction must be rolled back.

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

For which of the following types of failure would Oracle Database use Offline 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 17

The PL/SQL keyword DECLARE is used to begin the basic PL/SQL block structure.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The Oracle Enterprise Manager 11g Database Control is a Web-based Oracle Database administration utility.

Accepted Answer

A) True 
 B)False

Question 20

Sequences are most often used to provide values for surrogate keys.

Accepted Answer

A) True 
 B)False

Exam 11: Managing Databases With Oracle Database 11g

The Oracle Database PL/SQL block structure begins with:

With Oracle Database,stored procedures cannot use a cursor variable,so another method must be used to access a table on a row by row basis.

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

Which of the following is the easiest tool for creating a database with Oracle Database?

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

Oracle Database uses a System Change Number (SCN)to identify before images in rollback segments to prevent dirty reads.

Which of the following statements would cause Oracle Database to include a new column named C5,which is a two-digit whole number,to a table named T2?

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

What is the Database Configuration Assistant (DBCA)?

Which of the following commands does Oracle Database not support?

The default file extension for text files created for SQL Develope is .sql.

With Oracle Database,using a sequence does not guarantee valid surrogate key values.

Oracle Database supports the ON UPDATE CASCADE constraint.

Which of the following is true of Oracle Database when the isolation level is set to Serializable?

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

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

The PL/SQL keyword DECLARE is used to begin the basic 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.

The Oracle Enterprise Manager 11g Database Control is a Web-based Oracle Database administration utility.

Sequences are most often used to provide values for surrogate keys.

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