Question 1

Explain the Oracle Database PL/SQL cursor statements.

Accepted Answer

The Oracle Database PL/SQL cursor statem

Question 2

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 3

The NextVal method provides the next value in a sequence.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is not a transaction isolation level supported by Oracle Database?

Accepted Answer

A) Read Committed 
B) Serializable 
C) Repeatable Read 
D) Read Only 
E) All of the above are supported. 
A) Read Committed 
B) Serializable 
C) Repeatable Read 
D) Read Only 
E) All of the above are supported.

Question 6

When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

Accepted Answer

A) True 
 B)False

Question 7

The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements as long as some condition is true 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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

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 11

The Oracle Database Configuration Assistant is the easiest Oracle Database tool to use when you are creating an Oracle database.

Accepted Answer

A) True 
 B)False

Question 12

All Oracle Database triggers work at the row level.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

Accepted Answer

A) They can be written using C++. 
B) They must include the data type and length of parameters. 
C) They can raise exceptions. 
D) They do not contain variables. 
E) They cannot invoke other procedures. 
A) They can be written using C++. 
B) They must include the data type and length of parameters. 
C) They can raise exceptions. 
D) They do not contain variables. 
E) They cannot invoke other procedures.

Question 15

You can use the Edit Table table editor to create an index in Oracle Database.

Accepted Answer

A) True 
 B)False

Question 16

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

Question 17

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 18

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 19

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

Question 20

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

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

Explain the Oracle Database PL/SQL cursor statements.

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 NextVal method provides the next value in a sequence.

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

Which of the following is not a transaction isolation level supported by Oracle Database?

When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements as long as some condition is true is ________.

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

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

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

The Oracle Database Configuration Assistant is the easiest Oracle Database tool to use when you are creating an Oracle database.

All Oracle Database triggers work at the row level.

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

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

You can use the Edit Table table editor to create an index in Oracle Database.

Which type of trigger is commonly used to update views?

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?

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

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

Which of the following commands does Oracle Database not support?

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