Deck 11: Advanced Data Management

Question 1

PL / SQL is a restricted form of SQL.

Answer 1

False

Question 2

A block of code is a self-contained sequence of one or more commands.

Answer 2

True

Question 3

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

Answer 3

False

Question 4

PL / SQL uses some (but not all)of the datatypes used in SQL.

Question 5

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

Question 6

SQLERR is a built-in procedure that returns an error message,determined by the value of SQLCODE.

Question 7

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

Question 8

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.

Question 9

An automatic cursor is declared automatically by PL / SQL.

Question 10

An advantage of Data Pump over the original Import and Export utilities is that Data Pump has metadata filters allowing inclusion and exclusion of specific metadata items.

Question 11

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

Question 12

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.

Question 13

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

Question 14

By reference (BYREF)implies that a variable is a pointer and can be passed into,but not out of,a procedure within procedure parameters.

Question 15

Associative arrays are currently only allowed in PL / SQL and not Oracle SQL.

Question 16

Oracle Database comes with a multitude of pre-prepared packages.

Question 17

An advantage of Data Pump over the original Import and Export utilities is its better handling of bulk loading and unloading,allowing complete restart or a temporary halt

Question 18

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.

Question 19

A sequencing control is allowed to disrupt the logical flow of a program through its lines of code.

Question 20

The LOOP...END loop continues as long as a condition holds true.

Question 21

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.

Question 22

A conventional path load is potentially much faster than direct path loads.

Question 23

Exporting and importing is allowed at all logical layers such as export of individual tables,entire schemas,groups of objects,or even an entire database.

Question 24

The ____ utility is generally the most efficient tool for the mass loading of data into an Oracle database.

A) imp
B) impdp
C) SQL Loader
D) Data Pump

Question 25

____ allow(s)construction of properly scripted intra-dependant SQL command structures.

A) PL / SQL
B) SQL Loader
C) Data Pump
D) Triggers

Question 26

PL / SQL sequencing controls include the GOTO command and the ____ statement.

A) CASE
B) END
C) NULL
D) FORALL

Question 27

The Data Pump export utility is called ____.

A) export
B) exprt
C) exp
D) expdp

Question 28

Direct path loads using SQL*Loader allow appending to tables.

Question 29

Database exports can be used to migrate and upgrade between different versions of Oracle Database.

Question 30

SQL*Loader is not limited to individual table loads.

Question 31

A load filter in SQL Loader uses a DISCARD clause,which can be used to discard rows from the loading process,potentially placing discarded rows in the discard file and not loading them into target database tables.

Question 32

The original Export utility is called ____.

A) export
B) exprt
C) exp
D) expdp

Question 33

The JUMP statement allows branching from one part of a program to another,either up or down the code.

Question 34

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

Question 35

The original Import utility is called ____.

A) imp
B) imprt
C) import
D) impdp

Question 36

The CHAR datatype in SQL*Loader is different from the CHAR datatype in an Oracle 10g table.

Question 37

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

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

Question 38

Data Pump (import and export)and ____ are used to perform bulk loads and dumps into and out of an Oracle database.

A) SQL*Plus
B) SQL*Plus Worksheet
C) iSQL*Plus
D) SQL*Loader

Question 39

The Data Pump import utility is called ____.

A) imp
B) imprt
C) import
D) impdp

Question 40

Indirect path loads are very important to performance as they allow much faster performance during imports,by to the ends of datafiles,without having to pass through the SQL engine.

Question 41

A ____ is like a procedure except it allows a return value and can thus be embedded in an expression.

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

Question 42

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

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

Question 43

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

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

Question 44

A(n)____ is executed based on an event occurring in the database.

A) trigger
B) exception
C) RAISE
D) condition

Question 45

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

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

Question 46

In a(n)____ path load rows are parsed into an array structure according to field specification,as defined by SQL Loader and the table to be added to;then,all elements in the array are processed by a bulk SQL INSERT command,passing through the SQL engine,and being added to a table as any INSERT statement would do.

A) direct
B) conventional
C) indirect
D) parallel direct

Question 47

A(n)____ path load is a variation on a direct path load and is potentially faster than a direct path load.

A) conventional direct
B) conventional
C) indirect
D) parallel direct

Question 48

____ is a term given to a PL / SQL procedure or block of code that is not named,and is not stored in the database.

A) Anonymous
B) Default
C) Unnamed
D) Undeclared

Question 49

If using SQL*Plus and not SQL*Plus Worksheet,you should not forget the ____ character on the last line as the code block will not execute without it.

A) \
B) /
C) #
D) ;

Question 50

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

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

Question 51

Before using export or import utilities you can go into a shell and bring up the help screen for the utility by typing utilname ____.

A) -help
B) --help
C) help=y
D) help=TRUE

Question 52

SQL Loader allows loading of operating system ____ files into one or more tables at once.

A) flat
B) control
C) hidden
D) configuration

Question 53

The usability of ____ technology is in question because it is only available to database- and operating-system level administrative personnel.

A) Data Pump
B) Import and Export
C) SQL*Loader
D) SQL*Plus

Question 54

Data Pump has an interactive command mode allows monitoring of ongoing ____________________.

Question 55

The ____ statement has both search condition and selector-expression variations.

A) IF
B) CASE
C) GOTO
D) FORALL

Question 56

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

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

Question 57

A(n)____ trap is a block of code,within the main block,that will execute if a coding error occurs that is not trapped by the compiler.

A) catch
B) exception
C) trigger
D) error

Question 58

PL / SQL stands for _________________________ SQL.

Question 59

A ____ is a block of code that allows by value and by reference parameters with no return value.

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

Question 60

A(n)____ path load writes data to the end of a table into new block and extent structures,creating new blocks as it goes.

A) direct
B) conventional
C) indirect
D) parallel direct

Question 61

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

Question 62

The idea of the export and import utility is to allow a copy from a database of a complete set of data and its ____________________.

Question 63

Oracle requires a single quote to apply a(n)____________________ to the second,ignoring the quote as a string terminator.

Question 64

A(n)____________________ cursor is a by reference cursor.

Question 65

A(n)____________________ block of code is stored and can be recalled later and re-executed again,without having to retype the entire block of code.

Question 66

The ____________________ keyword causes an error to be returned from a block of code.

Question 67

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

Question 68

The LOOP...END construct can be used as a(n)____________________ loop (iterates until a condition is true)by placing an EXIT WHEN clause just before the END LOOP statement.

Question 69

In programming terms a block is a block of ____________________.

Question 70

The ____________________ character sequence concatenates two strings together.

Question 71

The simplest block of code you can create in PL / SQL is a block,enclosed between BEGIN and END commands,containing the command ____________________.

Question 72

In PL / SQL a block is a chunk of code containing both PL / SQL and ____________________ commands.

Question 73

In their current form Data Pump utilities are for ____________________-level users only.

Question 74

A package consists of a definitional section and a(n)____________________ section.

Question 75

A cursor ____________________ is an implicit cursor on the basis that it does not require use of the OPEN,FETCH,and CLOSE statements.

Question 76

The PL / SQL ____________________ datatype stores a TRUE,FALSE or null value.

Question 77

The ____________________ keyword is required in PL / SQL in to copy unique values retrieved by a SELECT statement into program variables.

Question 78

A PL / SQL ____________________ is a composite structure similar to a VARRAY or TABLE datatype that allows the creation of a table row structure in memory.

Question 79

Every SQL statement issued stores its resulting state into a(n)____________________.

Question 80

The ____________________ loop iterates through a known set of values.