Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

The Oracle Database GUI is the Oracle SQL Browser.

Accepted Answer

A) True 
 B)False

Question 6

Control files,as used by Oracle Database's backup and recovery features,contain records of database changes.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

Which of the following is not true of stored procedures in Oracle Database?

Accepted Answer

A) They are programs. 
B) They can have parameters. 
C) They can be invoked remotely. 
D) They can return values. 
E) They can be written in C++. 
A) They are programs. 
B) They can have parameters. 
C) They can be invoked remotely. 
D) They can return values. 
E) They can be written in C++.

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The Oracle SQL Developer has no facility for executing SQL statements.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

Explain the Oracle Database PL/SQL Block Structure.

Accepted Answer

The Oracle Database PL/SQL block structu

Question 15

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 16

What is SQL Developer?

Accepted Answer

SQL Developer is the GUI tool that is in

Question 17

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 18

Briefly explain the different types of files used by the Oracle Database recovery facilities.

Accepted Answer

The first type of file is the datafile.D

Question 19

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 20

Each Oracle Database tablespace has one or more datafiles associated with it.

Accepted Answer

A) True 
 B)False

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

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

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

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

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

The Oracle Database GUI is the Oracle SQL Browser.

Control files,as used by Oracle Database's backup and recovery features,contain records of database changes.

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

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

Which of the following is not true of stored procedures in Oracle Database?

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

The Oracle SQL Developer has no facility for executing SQL statements.

Which method returns the next value in a sequence?

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

Explain the Oracle Database PL/SQL Block Structure.

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

What is SQL Developer?

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

Briefly explain the different types of files used by the Oracle Database recovery facilities.

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

Each Oracle Database tablespace has one or more datafiles associated with it.

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

A: Managing Databases With SQL Server 20012

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

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 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters