Question 1

Oracle Database provides only one method for creating an Oracle Database database.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Among its many functions,SQL*Plus is also a programming language.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) FOR 
B) WHILE 
C) BEGIN 
D) LOOP 
A) FOR 
B) WHILE 
C) BEGIN 
D) LOOP

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

The Oracle Database Enterprise Manager Database Express provides graphical facilities for managing databases.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

The Oracle Database PL/SQL block structure begins with ________.

Accepted Answer

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

Question 13

Explain the Oracle Database PL/SQL cursor statements.

Accepted Answer

The Oracle Database PL/SQL cursor statem

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 
A) DECLARE 
B) BEGIN 
C) IF...THEN...ELSE...END IF 
D) LOOP

Question 15

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 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 
A) DECLARE 
B) BEGIN 
C) IF...THEN...ELSE...END IF 
D) LOOP

Question 17

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 18

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 19

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 20

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 be written in C++. 
A) They are programs. 
B) They can have parameters. 
C) They can be invoked remotely. 
D) They can be written in C++.

Exam 11: Managing Databases With Oracle Database

Oracle Database provides only one method for creating an Oracle Database database.

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

Among its many functions,SQL*Plus is also a programming language.

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

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

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

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

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.

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

The Oracle Database Enterprise Manager Database Express provides graphical facilities for managing databases.

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

The Oracle Database PL/SQL block structure begins with ________.

Explain the Oracle Database PL/SQL cursor statements.

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

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

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

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.

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

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

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

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters