Question 1

Explicit cursors are operated on using the special cursor commands OPEN,GRAB,and CLOSE.

Accepted Answer

A) True 
 B)False

Question 2

A special type of implicit cursor exclusive to PL / SQL is called a cursor FORALL loop.

Accepted Answer

A) True 
 B)False

Question 3

A disadvantage of Data Pump over the original Import and Export utilities is that the latter provide better parallel processing.

Accepted Answer

A) True 
 B)False

Question 4

In programming terms a block is a block of ____________________.

Accepted Answer

The answer of In programming terms a block is a...

Question 5

A labeled block is a chunk of code given a label (a procedure name),so that block of code can be stored in the database.

Accepted Answer

A) True 
 B)False

Question 6

The ____________________ character sequence concatenates two strings together.

Accepted Answer

The answer of The ____________________ character sequence concatenates two strings...

Question 7

In an anonymous procedure or block any local variables must be declared using the ____________________ keyword,in the declaration section.

Accepted Answer

The answer of In an anonymous procedure or block any...

Question 8

The ____ loop allows for a potentially infinite loop,iterating without a condition on the loop statement.

Accepted Answer

A)  FOR 
B)  WHILE 
C)  FORALL 
D)  LOOP...END LOOP 
A)  FOR 
B)  WHILE 
C)  FORALL 
D)  LOOP...END LOOP

Question 9

Oracle Database calls the area of memory in which a cursor is temporarily placed a(n)____________________.

Accepted Answer

The answer of Oracle Database calls the area of memory...

Question 10

The ____ PL / SQL datatype stores a signed integer value.

Accepted Answer

A)  NUMBER 
B)  INTEGER 
C)  BINARY_INTEGER 
D)  UNSIGNED 
A)  NUMBER 
B)  INTEGER 
C)  BINARY_INTEGER 
D)  UNSIGNED

Question 11

Direct path loads appending new blocks is the best option when rows are deleted from tables because existing blocks will never have rows slotted into them.

Accepted Answer

A) True 
 B)False

Question 12

A(n)____ is a simple wrapper for grouping multiple procedures and functions together into a blocked (packaged)unit.

Accepted Answer

A)  chunk 
B)  trigger 
C)  package 
D)  exception 
A)  chunk 
B)  trigger 
C)  package 
D)  exception

Question 13

All PL / SQL named structures can be created in various interfaces including all SQL*Plus programs,as well as the Oracle Enterprise Manager console,and the Database Control.

Accepted Answer

A) True 
 B)False

Question 14

SQL*Loader generates a log file,a(n)____________________ file,and finally a bad rows file.

Accepted Answer

The answer of SQL*Loader generates a log file,a(n)____________________ file,and finally...

Question 15

In PL / SQL cursors can be created as programming structures for holding iterations of data (equivalent to rows in a table).

Accepted Answer

A) True 
 B)False

Question 16

PL / SQL looping constructs include the FOR loop,the WHILE loop,the ____ (endless loop),and the FORALL statement.

Accepted Answer

A)  LOOP 
B)  LOOP...END 
C)  FOREVER 
D)  CYCLE 
A)  LOOP 
B)  LOOP...END 
C)  FOREVER 
D)  CYCLE

Question 17

A control structure in a programming language is a special type of keyword (or set of keywords)used to control the flow through a program.

Accepted Answer

A) True 
 B)False

Question 18

Unwanted columns can be removed from the SQL Loader loading process and replaced with NULL values by using the ____ clause.

Accepted Answer

A)  EXCEPT 
B)  REMOVE 
C)  FILLER 
D)  SKIP 
A)  EXCEPT 
B)  REMOVE 
C)  FILLER 
D)  SKIP

Question 19

A(n)____ is an event-driven procedure.

Accepted Answer

A)  function 
B)  trigger 
C)  package 
D)  exception 
A)  function 
B)  trigger 
C)  package 
D)  exception

Question 20

SQL Loader datatypes are slightly different from Oracle Database tables in that they are somewhat simpler but also easier to define.

Accepted Answer

A) True 
 B)False

Explicit cursors are operated on using the special cursor commands OPEN,GRAB,and CLOSE.

A special type of implicit cursor exclusive to PL / SQL is called a cursor FORALL loop.

A disadvantage of Data Pump over the original Import and Export utilities is that the latter provide better parallel processing.

In programming terms a block is a block of ____________________.

A labeled block is a chunk of code given a label (a procedure name),so that block of code can be stored in the database.

The ____________________ character sequence concatenates two strings together.

In an anonymous procedure or block any local variables must be declared using the ____________________ keyword,in the declaration section.

The ____ loop allows for a potentially infinite loop,iterating without a condition on the loop statement.

Oracle Database calls the area of memory in which a cursor is temporarily placed a(n)____________________.

The ____ PL / SQL datatype stores a signed integer value.

Direct path loads appending new blocks is the best option when rows are deleted from tables because existing blocks will never have rows slotted into them.

A(n)____ is a simple wrapper for grouping multiple procedures and functions together into a blocked (packaged)unit.

All PL / SQL named structures can be created in various interfaces including all SQL*Plus programs,as well as the Oracle Enterprise Manager console,and the Database Control.

SQL*Loader generates a log file,a(n)____________________ file,and finally a bad rows file.

In PL / SQL cursors can be created as programming structures for holding iterations of data (equivalent to rows in a table).

PL / SQL looping constructs include the FOR loop,the WHILE loop,the ____ (endless loop),and the FORALL statement.

A control structure in a programming language is a special type of keyword (or set of keywords)used to control the flow through a program.

Unwanted columns can be removed from the SQL Loader loading process and replaced with NULL values by using the ____ clause.

A(n)____ is an event-driven procedure.

SQL Loader datatypes are slightly different from Oracle Database tables in that they are somewhat simpler but also easier to define.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters

Exam 11: Advanced Data Management

Explicit cursors are operated on using the special cursor commands OPEN,GRAB,and CLOSE.

A special type of implicit cursor exclusive to PL / SQL is called a cursor FORALL loop.

A disadvantage of Data Pump over the original Import and Export utilities is that the latter provide better parallel processing.

In programming terms a block is a block of ____________________.

A labeled block is a chunk of code given a label (a procedure name),so that block of code can be stored in the database.

The ____________________ character sequence concatenates two strings together.

In an anonymous procedure or block any local variables must be declared using the ____________________ keyword,in the declaration section.

The ____ loop allows for a potentially infinite loop,iterating without a condition on the loop statement.

Oracle Database calls the area of memory in which a cursor is temporarily placed a(n)____________________.

The ____ PL / SQL datatype stores a signed integer value.

Direct path loads appending new blocks is the best option when rows are deleted from tables because existing blocks will never have rows slotted into them.

A(n)____ is a simple wrapper for grouping multiple procedures and functions together into a blocked (packaged)unit.

All PL / SQL named structures can be created in various interfaces including all SQL*Plus programs,as well as the Oracle Enterprise Manager console,and the Database Control.

SQL*Loader generates a log file,a(n)____________________ file,and finally a bad rows file.

In PL / SQL cursors can be created as programming structures for holding iterations of data (equivalent to rows in a table).

PL / SQL looping constructs include the FOR loop,the WHILE loop,the ____ (endless loop),and the FORALL statement.

A control structure in a programming language is a special type of keyword (or set of keywords)used to control the flow through a program.

Unwanted columns can be removed from the SQL Loader loading process and replaced with NULL values by using the ____ clause.

A(n)____ is an event-driven procedure.

SQL Loader datatypes are slightly different from Oracle Database tables in that they are somewhat simpler but also easier to define.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters