先試後買

A. Line 5

B. Line 3

C. Line 6

D. Line 7

E. Line 2

A. Replace the NAMES_VARRAY declaration with names_varray 1_name_type := 1_name_type ();

B. Add names_varray.EXTEND after the FOR ...LOOP statement.

C. Add name_rec name_cur%ROWTYPE; at the end of the DECLARE section.

D. Replace the FOR loop with FOR name_rec IN names_varray.FIRST .. names_varray.LAST LOOP.

E. Replace the NAMES_VARRAY declaration with names_varray 1_name_type := null;

F. Replace the L_NAME_TYPE declaration with TYPE 1_name_type IS VARRAY (25) OF SYS_REFCURSOR;

A. It produces HTML output from raw profiler output.

B. It stores hash values in hierarchical profiler tables in the database.

C. It produces raw profiler output for the most recently executed PL/SQL block.

D. It executes a script to create hierarchical profiler tables in the database.

E. It produces HTML output from hierarchical profiler tables in the database.

A. DECLARETYPE names_t IS TABLE OF SYS_REFCURSOR INDEX BY PLS_INTEGER;cv1 names_t;v_dept_name departments.department_name%TYPE;BEGINOPEN cv1 FOR SELECT department_name FROM departments WHERE department_id=10;FETCH cv1 INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);CLOSE cv1;END;

B. DECLARETYPE dept_cur IS REF CURSOR;cv1 dept_cur;v_dept_name departments.
department_name%TYPE;BEGINOPEN cv1 FOR SELECT department_name FROM departments WHERE department_id=10;IF cv1 IS NOT NULL THENFETCH cv1 INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);END IFCLOSE cv1;END;

C. DECLARETYPE dept_cur IS REF CURSOR RETURN departments%ROWTYPE;cv1
dept_cur;v_dept_name departments.department_name%TYPE;BEGINOPEN cv1 FOR SELECT * FROM departments WHERE department_id=10;FETCH cv1. department_name INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);CLOSE cv1;END;

D. DECLAREcv1 SYS_REFCURSOR;v_dept_name
departments.department_name%TYPE;BEGINEXECUTE IMMEDIATE 'BEGIN OPEN: cv1 FORSELECT department_name FROM departmnets WHERE department_id=10: END;'USING IN cv1;FETCH cv1 INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);CLOSE cv1;END;

A. LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
___anonymous_block1 5 TEST_PKG.DO_STUFF2 4 TEST_PKG.DO_STUFF.NP13 3
TEST_PKG.DO_STUFF.NP1.NP24 2 TEST_PKG.DO_STUFF.NP1.NP2.NP30 1
FORMAT_CALL_STACK_12C

B. LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
___anonymous_block1 5 DO_STUFF2 4 NP13 3 NP24 2 NP30 1 FORMAT_CALL_STACK_12C

C. LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
___anonymous_block1 5 package body HR.TEST_PKG2 4 package body HR.TEST_PKG3 3 package body HR.TEST_PKG4 2 package body HR.TEST_PKG0 1 procedure HR.
FORMAT_CALL_STACK_12C

D. LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
___anonymous_block1 5 package body HR.TEST_PKG2 4 package body HR.TEST_PKG2 3 package body HR.TEST_PKG2 2 package body HR.TEST_PKG0 1 procedure HR.
FORMAT_CALL_STACK_12C

E. LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
___anonymous_block1 5 TEST_PKG.DO_STUFF2 4 TEST_PKG.DO_STUFF.NP12 3
TEST_PKG.DO_STUFF.NP1.NP22 2 TEST_PKG.DO_STUFF.NP1.NP2.NP30 1
FORMAT_CALL_STACK_12C

A. As a column in a table when you want to store no more than 10 elements in each row's collection.

B. When the amount of data to be held in the collection is widely variable.

C. When you want to delete elements from the middle of the collection.

D. As a column in a table when you want to retrieve the collection data for certain rows by ranges of values.

A. 30

B. PLS-00382: expression is of wrong type

C. PLS-00316: PL/SQL TABLEs must use a single index

D. ORA-06533: Subscript beyond count

E. 60

A. ALL_SOURCE

B. ALL-DEPENDENCIES

C. ALL_DESCRIBE

D. ALL_ARGUMENTS

E. ALL_PROCEDURES

A. CREATE PACKAGE pkg ASTYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER);END pkg;/CREATE PROCEDURE calc_price (price_rec IN OUT pkg. rec_typ) ASBEGINprice_rec.price := price_rec.price + (price_rec.price * price_rec.inc_pct)/100;END/DECLARE1_rec pkg.rec_typ;BEGINEXECUTE IMMEDIATE 'BEGIN calc_price (:rec); END;' USING IN OUT 1_rec (100, 50);END;

B. DECLARETYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER);1_rec
rec-typ;PROCEDURE calc_price (price_rec IN OUT rec_typ) ASBEGINprice_rec.price := price-rec.price+ (price_rec.price * price_rec.inc_pct)/100;END;BEGIN1_rec_price :=100;1_rec.inc_pct
:=50;EXECUTE IMMEDIATE 'BEGIN calc_price (:rec); END;' USING IN OUT 1_rec;END;

C. CREATE PACKAGE pkg ASTYPE rec_typ IS RECORD (price NUMBER, inc_pct
NUMBER);PROCEDURE calc_price (price_rec IN OUT rec_typ);END pkg;/CREATE PACAKGE BODY pkg ASPROCEDURE calc_price (price_rec IN OUT rec_typ) ASBEGINprice_rec.price := price_rec.price + (price_rec.price * price_rec.inc_pct)/100;END calc_price;END pkg;/DECLARE1_rec pkg. rec_typ;BEGIN1_rec_price :=100;1_rec.inc_pct :=50;EXECUTE IMMEDIATE 'BEGIN pkg.
calc_price (:rec); END;' USING IN OUT 1_rec;END;

D. CREATE PACKAGE pkg ASTYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER);END pkg;/CREATE PROCEDURE calc_price (price_rec IN OUT pkg. rec_typ) ASBEGINprice_rec.price := price_rec.price + (price_rec.price * price_rec.inc_pct)/100;END ;/DECLARE1_rec pkg.
rec_typ;BEGIN1_rec_price :=100;1_rec.inc_pct :=50;EXECUTE IMMEDIATE 'BEGIN calc_price (1_rec); END;';END;

A. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@') FROM dual;

B. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@my_dblink') FROM dual;

C. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('"10_Employees"') FROM dual;

D. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME (' Emp_Dept_information_table ') FROM dual;

E. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employee_Department_information_table') FROM dual;