최신Oracle Database 19c: Program with PL/SQL - 1Z0-149무료샘플문제
문제1
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
정답: B,C,F
문제2
Which is true about EXIT and CONTINUE statements?
Which is true about EXIT and CONTINUE statements?
정답: D
문제3
Examine these statements which execute successfully:
Which anonymous block executes successfully?
Examine these statements which execute successfully:
Which anonymous block executes successfully?
정답: A
문제4
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
정답: A
문제5
Examine this row of data from the EMPLOYEES table:
Now, examine this block of code which executes successfully:
What is the value of v_commission?
Examine this row of data from the EMPLOYEES table:
Now, examine this block of code which executes successfully:
What is the value of v_commission?
정답: B
문제6
Examine this table definition in the SH schema.
A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)
Examine this table definition in the SH schema.
A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)
정답: C,D
문제7
Examine this DECLARE section:
Which line will cause an error upon execution?
Examine this DECLARE section:
Which line will cause an error upon execution?
정답: B