1z1-148無料問題集「Oracle Database: Advanced PL/SQL」

質問 1

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

（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 :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;

（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、C 解答を投票する

質問 2

Which three statements are true about varrays in a database table column? (Choose three.)

（A）A varray may be stored outside the table segment in which it is defined but still in the same tablespace.

（B）The data in a single element of a varray can be changed through either PL/SQL or SQL.

（C）A varray's size can be increased beyond the maximum number of elements specified in the definition.

（D）A varray used as a column in a database table must be initialized to null.

（E）The data in a single element of a varray can only be changed through PL/SQL.

（F）A varray is always stored in the same segment as the table in which it is defined.

（G）A varray used as a column in a database table must be initialized to empty.

（H）A varray's size can be both increased and decreased from the maximum number of elements specified in the definition.

正解：A、B、H 解答を投票する

質問 3

Examine this function:

Execute the query:
SELECT remap_schema FROM dual;
Which is the correct output from the query?

（A）CREATE TABLE "EMP" ("EMPNO" NUMBER (4, 0), "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4, 0), "HIREDATE" DATE, "SAL" NUMBER (7, 2), "COMM" NUMBER (7, 2), "DEPTNO" NUMBER (2, 0),CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")USING INDEX ENABLE,CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")REFERENCES "DEPT" ("DEPTNO") ENABLE)

（B）CREATE TABLE "EMP" ("EMPNO" NUMBER (4,0), "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4,0), "HIREDATE"DATE, "SAL" NUMBER (7, 2) , "COMM" NUMBER (7, 2), "DEPTNO" NUMBER (2,0),CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255STORAGE (INITIAL
65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2417483645PCTINCREASE 0 FREELISTS
1 FREELIST GROUPS 1BUFFER_POOL DEFAULT FLASH_CHACHE DEFAULT
CELL_FLASH_CACHE DEFAULT)TABLESPACE "SYSAUX" ENABLE,CONSTRAINT
"FK_DEPTNO" FOREIGN KEY ("DEPTNO")REFERENCES "DEPT" ("DEPTNO") ENABLE)
SEGMENT CREATION IMMEDIATEPCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255NOCOMPRESS LOGGINGSTORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1
MAXEXTENTS 2147483645PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS
1BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE
DEFAULT)TABLESPACE "SYSAUX"

（C）CREATE TABLE "EMP" ("EMPNO" NUMBER (4,0), "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4,0), "HIREDATE"DATE, "SAL" NUMBER (7,2) , "COMM" NUMBER (7,2), "DEPTNO" NUMBER (2,0),CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255STORAGE (INITIAL
65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2417483645PCTINCREASE 0 FREELISTS
1 FREELIST GROUPS 1BUFFER_POOL DEFAULT FLASH_CHACHE DEFAULT
CELL_FLASH_CACHE DEFAULT)TABLESPACE "USERS" ENABLE,CONSTRAINT
"FK_DEPTNO" FOREIGN KEY ("DEPTNO")REFERENCES "DEPT" ("DEPTNO") ENABLE)
SEGMENT CREATION IMMEDIATEPCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255NOCOMPRESS LOGGINGSTORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1
MAXEXTENTS 2147483645PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS
1BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE
DEFAULT)TABLESPACE "USERS"

（D）CREATE TABLE "SCOTT". "EMP" ("EMPNO" NUMBER (4, 0), "ENAME" VARCHAR2 (10),
"JOB" VARCHAR2 (9), "MGR" NUMBER (4, 0), "HIREDATE" DATE, "SAL" NUMBER (7, 2),
"COMM" NUMBER (7, 2), "DEPTNO" NUMBER (2, 0),CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")USING INDEX ENABLE,CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")REFERENCES "DEPT" ("DEPTNO") ENABLE)

正解：A 解答を投票する

質問 4

Which three statements are correct when using collections? (Choose three.)

（A）Associative arrays may be used when you need to process information of unknown volume.

（B）Do not use nested tables when you need to delete elements.

（C）Varrays should be used when you need to pass the collection as a parameter.

（D）Nested tables should be used when the index values are non-sequential.

（E）Nested tables may be used when there is no predefined upper bound for index values.

（F）Use associative arrays when you need numeric and string indices.

正解：B、C、E 解答を投票する

質問 5

Which statement is true about internal and external LOBs?

（A）When using DBMS_LOB.INSTR for internal and external LOBs, DBMS_LOB.OPEN should be called for each LOB.

（B）Internal and external LOBs can be written using DBMS_LOB.

（C）After an exception transfers program control outside a PL/SQL block, all references to open external LOBs are lost.

（D）A NOEXIST_DIRECTORY exception can be raised when using internal and external LOBs.

（E）An external LOB can be loaded into an internal LOB variable using the DBMS_LOB package.

正解：A、C 解答を投票する

質問 6

Which two statements are correct for collecting data about identifiers in PL/SQL source code?

（A）ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS: ALL'

（B）ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS: NONE'

（C）ALTER <function/Procedure> COMPILE PLSCOPE_SETTINGS = 'IDENTIFIERS: ALL'

（D）ALTER SYSTEM SET PLSCOPE_SETTINGS = 'IDENTIFIERS: NONE'

（E）CREATE < function/Procedure> PLSCOPE_SETTINGS = 'IDENTIFIERS: ALL' AS ...

正解：A、C 解答を投票する

質問 7

Which is the correct method for releasing unused money after deleting elements of a collection?

（A）Use the TRUNCATE method on the collection.

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

（C）Execute DBMS_SHARED_POOL.UNKEEP.

（D）Execute DBMS_SESSION.FREE_UNUSED_USER_MEMORY.

正解：D 解答を投票する

質問 8

Examine this code:

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

（A）Line 3

（B）Line 7

（C）Line 2

（D）Line 6

（E）Line 5

正解：B、C 解答を投票する

質問 9

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

（A）Only DBAs can create or run parallel execution tasks.

（B）DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.

（C）To execute chunks in parallel, users must have CREATE JOB system privilege.

（D）No specific system privileges are required to create or run parallel execution tasks.

（E）Users with CREATE TASK privilege can create or run parallel execution tasks.

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

Which two statements are true regarding edition-based redefinition (EBR)?

（A）When you change an editioned object, all of its dependents remain valid.

（B）Editions are non-schema objects.

（C）There is no default edition defined in the database.

（D）You never use EBR to copy the database objects and redefine the copied objects in isolation.

（E）EBR does not let you upgrade the database components of an application while in use.

（F）Tables are not editionable objects.

正解：A、F 解答を投票する

1z1-148 無料問題集「Oracle Database: Advanced PL/SQL」

弊社を連絡する

関連リンク

トップ試験