Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

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?

A.

DEP_VU must be manually recompiled to successfully run this code.

B.

It will run successfully producing a result of 4.

C.

It will result in an error because table depts has been altered.

D.

It will run successfully producing a result of 5.

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

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.

Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

A.

It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

B.

It will return an error at line 2.

C.

It will return an error at line 3.

D.

It will return an error at line 8.

E.

It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

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.

Which three statements can process a dynamic multi-row query? (Choose three.)

A.

DECLARE

B.

OPEN

C.

INTO

D.

OPEN-FOR

E.

FETCH

F.

WHEN

G.

CLOSE

Which three statements are true about passing parameters to subprograms? (Choose three.)

A.

PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

B.

IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

C.

IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

D.

The actual parameter must be a variable when calling a subprogram with an OUT parameter.

E.

IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

F.

OUT parameters returning values to calling subprograms act like constants in the called subprogram.

G.

Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

Which two blocks of code display a numerical zero? (Choose two.)

A.

B.

C.

D.

Which three are true about DDL triggers? (Choose three.)

A.

They cannot include the WHEN clause.

B.

They must be created in an enabled state.

C.

They can be fired when a table is truncated.

D.

They fire only when a DDL statement is executed by the owner of the trigger.

E.

They can be fired either before or after a DDL statement executes.

F.

They can be fired when a privilege is granted to a user.

G.

They must be created in a disabled state.

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?

A.

5000

B.

15000

C.

2500

D.

10000

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