1z1-149 by Oracle Actual Free Exam Q&As

Question 1

Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?

A. It executes successfully. B. It results in an error because Authid Definer is missing from MYPROC. C. It results in an error because USERB doesn't have select privilege on USERA.EMP. D. It results in an error because Authid Current_User is missing from MYPROC.

Discussion 0

Correct Answer: A Vote an answer

Question 2

Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

A. It will always automatically initialize v_raise. B. It might return a run time error depending on who invokes it. C. It will always return a compile time error because it lacks an EXCEPTION section. D. It will set all salaries to 0 if it executes successfully. E. It will set all salaries to NULL if it executes successfully. F. It will always return a run time error because v_raise is not initialized.

Discussion 0

Correct Answer: A,E Vote an answer

Question 3

Examine this code:

What will be the outcome?

A. It will result in an error as the range of the error code can only be from "-2000 to -2999." B. It will result in an error as the range of the error code can only be from "-1000 to -2000." C. It will execute successfully and will display the user-defined error message. D. It will result in an error as the range of the error code can only be from "-20000 to -20999."

Discussion 0

Correct Answer: D Vote an answer

Question 4

Which three are true about anonymous blocks and subprograms? (Choose three.)

A. Anonymous blocks must always start with the Declare keyword. B. Named subprograms cannot be called from other packages. C. Anonymous blocks cannot use packaged variables. D. PROCEDURE subprograms can accept parameters. E. A FUNCTION subprogram must return one or more values. F. FUNCTION subprograms must be called and passed through one or more parameters. G. Named subprograms are stored in the database server.

Discussion 0

Correct Answer: D,E,G Vote an answer

Question 5

Which two are true about implicit data type conversion? (Choose two.)

A. Implicit data type conversion can negatively impact performance. B. ROWIDS are always implicitly converted to a number when used in a query. C. Comparison between character value and a number value always implicitly converts the character value to the number data type. D. RAW data types are always implicitly converted to a CLOB when used in a query. E. Collections can be implicitly converted to records.

Discussion 0

Correct Answer: A,C Vote an answer

Question 6

Which is true about EXIT and CONTINUE statements?

A. They have the same effect on the execution of a loop. B. They must use labels. C. They can be used in any type of loop. D. They must have a WHEN condition.

Discussion 0

Correct Answer: C Vote an answer

Question 7

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

A. Call HR.API.P1 from the HR schema. B. Call HR.HELPER.H1 from the HR schema. C. Call HR.API.P1 from the SH schema. D. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1. E. Call HR.HELPER.H1 from the SH schema.

Discussion 0

Correct Answer: C,E Vote an answer

Oracle Database 19c: Program with PL/SQL - 1z1-149 Exam Practice Test