Online Access Free 1z1-149 Practice Test

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.

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 is true about EXIT and CONTINUE statements?

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

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

• A.They fire only when a DDL statement is executed by the owner of the trigger.
• B.They can be fired when a table is truncated.
• C.They can be fired either before or after a DDL statement executes.
• D.They can be fired when a privilege is granted to a user.
• E.They cannot include the WHEN clause.
• F.They must be created in an enabled state.
• G.They must be created in a disabled state.

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 result in an error because table depts has been altered.
• C.It will run successfully producing a result of 5.
• D.It will run successfully producing a result of 4.