Question 1
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?
Correct Answer:
C. 2500
Free Oracle Database 19c: Program with PL/SQL 1Z0-149 Exam Questions
Question 2
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
A.
B.
C.
D.
Correct Answer:
C. Option C
Question 3
Examine the structure of the ora1.depts table:
Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:
Which is true?
Correct Answer:
B. It will run successfully producing a result of 4.
Question 4
Examine these statements and output:
The procedure is created successfully.
User ora2 has password ora2 in pdb1.
Which script will execute successfully?
A.
B.
C.
D.
Correct Answer:
B. Option B
Question 5
Examine this code:
What will be the outcome?
Correct Answer:
B. It will result in an error as the range of the error code can only be from ''-20000 to -20999.''
Question 6
In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:
EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)
Correct Answer:
B. Call HR.HELPER.H1 from the SH schema.; D. Call HR.API.P1 from the SH schema.
Question 7
Which two are true about using the ACCESSIBLE BY clause? (Choose two.)
Correct Answer:
A. It can be used in the declaration of object types.; D. It can be used for individual procedures and functions declared in a package specification.
Question 8
Examine these statements from a block of code:
Which two are true? (Choose two.)
Correct Answer:
A. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.; D. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
Question 9
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)
Correct Answer:
B. PL/SQL code can be compiled and executed based on different versions of Oracle.; E. The PL/SQL compiler can conditionally include selected parts of a program.
Question 10
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.)
A.
B.
C.
D.
Correct Answer:
C. Option C; D. Option D