最新的Oracle Database: Advanced PL/SQL - 1z1-148免費考試真題

A. Execute DBMS_SESSION.FREE_UNUSED_USER_MEMORY.

B. Flush the shared pool using the ALTER SYSTEM command.

C. Execute DBMS_SHARED_POOL.UNKEEP.

D. Use the TRUNCATE method on the collection.

A. It displays 3 for the row count and 2 for the total.

B. It displays 3 for both the row count and the total.

C. It throws a PL/SQL: numeric or value error: NULL index table key value exception.

D. It throws a NO_DATA_FOUND exception.

A. It fails compilation.

B. There are no compilation warnings or errors.

C. A performance compilation warning is generated.

D. An information compilation warning is generated.

E. A severe compilation warning is generated.

A. It implements security rules through functions and associates these security rules with tables, views or synonyms.

B. It can be used to implement column masking.

C. The DBMS_FGA package is used to set up fine-grained access control.

D. It is implemented by end users.

E. Separate policies are required for queries versus INSERT/UPDATE/DELETE statements.

A. user-created PL/SQL program units

B. triggers

C. package DBMS_STANDARD

D. wrapped PL/SQL program units

E. package STANDARD

A. DBMS_LOB can be used to compress SecureFiles columns.

B. An online redefinition of SecureFiles by DBMS_REDEFINIITON can be performed with PDML (Parallel DML).

C. When using DBMS_DATAPUMP, if SecureFiles LOB data needs to be encrypted then ENCRYPTION=ALL must be specified.

D. If a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE, an exception will be raised.

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 := '''%' | | 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. 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;

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 ' | | 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) ASv_bind VARCHAR2 (400);BEGINv_bind := '%' | | p_prodname | | '%';FOR rec IN ('SELECT name, price FROM prod_info WHERE name like ' | | v_bind) LOOPDBMS_OUTPUT.PUT_LINE ('Product Info: ' | | rec.name | | ',' | | rec.price);END LOOP;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 := 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;

A. BEGINpkg2.proc3;END;

B. BEGINpkg1.proc1a;END;

C. BEGINpkg2.proc2;END;

D. BEGINMy_proc;END;

E. BEGINpkg1.proc1b;END;

A. ALL-DEPENDENCIES

B. ALL_DESCRIBE

C. ALL_PROCEDURES

D. ALL_ARGUMENTS

E. ALL_SOURCE

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

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

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

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