[2026] Oracle Database: Advanced PL/SQL - 1z1-148 무료 시험 문제

문제1

Which two statements are true about PL/SQL AOIs for SecureFiles?

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

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

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

D. DBMS_LOB can be used to compress SecureFiles columns.

정답: B,C

문제2

Identify the three options which make a PL/SQL function highly suitable for using the RESULT_CACHE clause in its definition. (Choose three.)

A. The function has complex business logic depending on more than five tables to compute its return values.

B. The logic in the function accesses tables or uses package variables which are modified very rarely.

C. The value returned by the function is deterministic for a given set of input parameters.

D. The code in the function performs more write operations on the database when compared to the read operations.

E. The function involves highly computational logic with minimal or no database access.

F. The tables which are read in the function are very frequently updated.

정답: B,C,E

문제3

The user MY_USER has been assigned the roles CONNECT, RESOURCE, and DBA.
Which statement generates the DDL for these privileges?

A. SELECT DBMS_METADATA.GET_GRANTED_DDL ('OBJECT_GRANT', 'my_user') FROM dual;

B. SELECT DBMS_METADATA.GET_GRANTED_DDL ('ROLE_GRANT', 'my_user') FROM dual;

C. SELECT DBMS_METADATA.GET_GRANTED_DDL ('SYSTEM_GRANT', 'my_user') FROM dual;

D. SELECT DBMS_METADATA.GET_DDL ('USER', 'my_user') FROM dual;

정답: D

문제4

Examine this PL/SQL block:

If PLSQL_CCFLAGS is set to:
'flag1:TRUE, flag2:2, flag3:NULL'
What is the result of submitting this PL/SQL block for execution with SERVEROUTPUT enabled?

A. It executes successfully and outputs "Line: 10".

B. It executes successfully and outputs "Line: 3".

C. It executes successfully and outputs "Line: 5".

D. It executes successfully and outputs "Line: 8".

E. It executes successfully and outputs "Line: ".

F. It fails compilation.

정답: A

문제5

Which codes executes successfully?

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);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;

D. 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

문제6

Examine this code (all compiled into schema HR):

Execute this code:
SET SERVEROUTPUT ON;
EXEC test_pkg.do_stuff
What is the correct output?

A. 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

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 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

E. 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

문제7

Consider a function totalEmp () which takes a number as an input parameter and returns the total number of employees who have a salary higher than that parameter.
Examine this PL/SQL package AS

Which two definitions of totalEmp () result in an implicit conversion by Oracle Database on executing this PL/SQL block?

A. CREATE FUNCTION totalEmp (sal IN POSITIVEN) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/

B. CREATE FUNCTION totalEmp (sal IN PLS_INTEGER) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/

C. CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/

D. CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/

E. CREATE FUNCTION totalEmp (sal IN BINARY_FLOAT) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/

정답: C,E

문제8

Examine this code:

Assuming the default edition is ORA$BASE, what is the result of the last execution of hello?

A. Hello, edition 1.

B. An exception is raised.

C. Hello, edition 1.
Hello, edition 2.

D. Hello, edition 2.

E. Hello, edition 2.
Hello, edition 1.

정답: A

문제9

Which two statements are true with respect to fine-grained access control?

A. It can be used to implement column masking.

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

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

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

E. It is implemented by end users.

정답: B,D

Oracle Database: Advanced PL/SQL - 1z1-148무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트