1. Home
  2. Oracle
  3. Oracle Database PL/SQL Developer Certified Professional
  4. 1z0-149
  5. Oracle Database 19c: Program with PL/SQL Questions and Answers

Pass the Oracle Oracle Database PL/SQL Developer Certified Professional 1z0-149 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions
Questions # 11:

Examine these statements which execute successfully:

Question # 11

Which anonymous block executes successfully?

Options:
A.

1z0-149 Question 11 Option 1

B.

11

C.

11

D.

11

Questions # 12:

In which type of trigger can :OLD and :NEW identifiers be used?

Options:
A.

ROW

B.

AFTER SUSPEND

C.

AFTER STATEMENT

D.

BEFORE STATEMENT

Questions # 13:

Examine this table in the SH schema:

Question # 13

User SH executes this code:

Question # 13

The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.

With which option must “---placeholder” be replaced?

Options:
A.

1z0-149 Question 13 Option 1

B.

13

C.

13

D.

13

E.

13

Questions # 14:

Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

Options:
A.

1z0-149 Question 14 Option 1

B.

14

C.

14

D.

14

Questions # 15:

Which three are true about the procedure overloading feature? (Choose three.)

Options:
A.

Each procedure can be a nested subprogram.

B.

Each procedure's formal parameters can differ in data type or name.

C.

Each procedure must use named notation to specify the corresponding actual parameters.

D.

Each procedure's formal parameters must differ in name.

E.

Each procedure can be a packaged subprogram.

F.

Each procedure must use positional notation to specify the corresponding actual parameters.

G.

Each procedure can be a standalone subprogram.

Questions # 16:

Examine this anonymous block of code:

Question # 16

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

Options:
A.

It will set all salaries to 0 if it executes successfully.

B.

It will always return a compile time error because it lacks an EXCEPTION section.

C.

It might return a run time error depending on who invokes it.

D.

It will always automatically initialize v_raise.

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.

Questions # 17:

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:

Question # 17

EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.

Which two will execute successfully? (Choose two.)

Options:
A.

Call HR.HELPER.H1 from the HR schema.

B.

Call HR.HELPER.H1 from the SH schema.

C.

Call HR.API.P1 from the HR schema.

D.

Call HR.API.P1 from the SH schema.

E.

Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.

Questions # 18:

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

Options:
A.

DDL

B.

AFTER AUDIT

C.

BEFORE ANALYZE

D.

SHUTDOWN

E.

SERVERERROR

F.

STARTUP

G.

BEFORE GRANT

Questions # 19:

Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

Options:
A.

Function based indexes remain usable when replacing the function on which the index depends.

B.

Object privileges to execute a replaced function must be regranted to those users who had the privilege.

C.

This clause can be used only for procedures and functions.

D.

A function definition can be modified without dropping and re-creating it.

E.

Object privileges to execute a replaced function are retained by those users who had the privileges.

Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions