1z1-148問題集、Oracle実際の試験問題

質問 1

Examine the structure of the DEPT table which exists in both BRANCH1 and BRANCH2 schemas:

Examine this code:

Which three modifications must be done to endure the anonymous block displays the output form the BRANCH2.DEF DEPT table?

A. Add BEQUEATH CURRENT_USER to the EMP_COUNTS_VW view.

B. Add BEQUEATH DEFINER to the EMP_COUNT_VW view.

C. Change the IF condition in the anonymous block to 1_dept IS EMPTY.

D. Change the IF condition in the anonymous block to CARDINALITY (1_dept) IS NULL.

E. Add AUTHID CURRENT_USER to the EMP_COUNT function.

F. IN BRANCH2 execute GRANT INHERIT PRIVILEGES ON USER branch2 TO branch1;

正解: A,D,E

質問 2

Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?

A. The function must be created with invoker's rights or in an anonymous block.

B. The function must have an OUT or an IN OUT parameter.

C. The function must be declared as a pipelined table function.

D. The IN parameters must not include BLOB, CLOB, collection or record data types.

正解: D

質問 3

With SERVEROUTPUT enabled, you successfully create the package YEARLY_LIST:

Examine this code:

You want to display the contents of CREATE_LIST.
Which two lines need to be corrected in the PL/SQL block? (Choose two.)

A. Line 6

B. Line 7

C. Line 3

D. Line 5

E. Line 2

正解: B,C

質問 4

Which two blocks of code execute successfully?

A. DECLARETYPE tab_type IS TABLE OF NUMBERmy_tab tab_type := tab_type (2, NULL,
50);BEGINmy_tab.EXTEND (3, 2);END;

B. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type := tab_type(2);BEGINmy_tab(1)
:=55;END;

C. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab (1) :=1;END;

D. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab := tab_type ();my_tab (1) := 55;END;

E. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab. EXTEND (2);my_tab (1) := 55;END;

正解: B,D

質問 5

Examine this code:

Which two are valid correlations to the code to avoid or mitigate SQL Injection?

A. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) ASTYPE cv_pordtyp IS REF CURSOR;cv cv_prodtyp;v_prodname prod_info.name%TYPE;v_listprice prod_info.price%TYPE;v_bind VARCHAR2 (400);BEGINv_bind := DBMS_ASSERT.ENQUOTE_LITERAL ('%' | | p_product_name | | '%');OPEN cv FOR 'SELECT name, price FROM prod_info WHERE name LIKE ' | | v_bind;LOOPFETCH cv INTO v_prodname, v_listprice;EXIT WHEN cv%NOTFOUND;DBMS_OUTPU.PUT_LINE ('Product Info: ' | | v_prodname | | ',' | | v_listprice);END LOOP;CLOSE cv;END;

C. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) ASTYPE cv_pordtyp IS REF CURSOR;cv cv_prodtyp;v_prodname prod_info.name%TYPE;v_listprice prod_info.price%TYPE;v_bind VARCHAR2 (400);BEGINv_bind := '%' | | p_product_name | |
'%';OPEN cv FOR 'SELECT name, price FROM prod_info WHERE name LIKE :b' USING v_bind;LOOPFETCH cv INTO v_prodname, v_listprice;EXIT WHEN cv%NOTFOUND;DBMS_OUTPU.PUT_LINE ('Product Info: ' | | v_prodname | | ',' | | v_listprice);END LOOP;CLOSE cv;END;

D. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) ASTYPE cv_pordtyp IS REF CURSOR;cv cv_prodtyp;v_prodname prod_info.name%TYPE;v_listprice prod_info.price%TYPE;v_bind VARCHAR2 (400);BEGINv_bind := '''%' | | p_product_name | |
'%''';OPEN cv FOR 'SELECT name, price FROM prod_info WHERE name LIKE ' | | v_bind;LOOPFETCH cv INTO v_prodname, v_listprice;EXIT WHEN cv%NOTFOUND;DBMS_OUTPU.PUT_LINE ('Product Info: ' | | v_prodname | | ',' | | v_listprice);END LOOP;CLOSE cv;END;

E. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) ASTYPE cv_pordtyp IS REF CURSOR;cv cv_prodtyp;v_prodname prod_info.name%TYPE;v_listprice prod_info.price%TYPE;v_bind VARCHAR2 (400);BEGINv_bind := '%' | | p_product_name | |
'%';OPEN cv FOR 'SELECT name, price FROM prod_info WHERE name LIKE ' | | v_bind;LOOPFETCH cv INTO v_prodname, v_listprice;EXIT WHEN cv%NOTFOUND;DBMS_OUTPU.PUT_LINE ('Product Info: ' | | v_prodname | | ',' | | v_listprice);END LOOP;CLOSE cv;END;

正解: B,E

質問 6

Which two PL/SQL blocks give the output "this is a test message"?

A. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message ', FALSE));END;

B. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message', TRUE));END;

C. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a "test" message" ', TRUE));END;

D. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a " "test" " message', TRUE));END;

E. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a test message"
', TRUE));END;

正解: A,E

質問 7

You execute this PL/SQL block:

What will be the outcome?

A. It will fail compile because of errors at lines 5 and 6.

B. It will fail compile because of errors at lines 6 and 12.

C. It will fail compile because of error at line 7.

D. It will fail compile and execute successfully.

E. It will fail compile because of errors at lines 11 and 12.

正解: B

質問 8

Examine this block:

Which two will be correct after line 5?

A. va. LAST and va. LIMIT will return the same value.

B. va. LIMIT and va. COUNT will return the same value.

C. va. LAST and va. COUNT will return the same value.

D. va. LIMIT and va. NEXT (199) will return the same value.

E. va. LAST will return 200.

F. va. NEXT (199) will return NULL.

正解: C,F

質問 9

You are logged on to the SCOTT schema and the schema has EMP and DEPT tables already created:
Examine this PL/SQL procedure:

Which PL/SQL block will raise an exception?

A. EXEC get_tab_row_count ('emp');

B. EXEC get_tab_row_count ('SCOTT.EMP');

C. EXEC get_tab_row_count ('DEPT, EMP')

D. EXEC get_tab_row_count ('DEPT');

E. EXEC get_tab_row_count (' "EMP" ');

正解: C

Oracle Database: Advanced PL/SQL - 1z1-148 模擬練習