Get Oracle 1Z0-149 Exam Dumps

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?

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

Sequence S and table PRODUCTS exist in your schema.

Examine the table description:

Now, examine this block of code:

Which two lines each result in a compilation error? (Choose two.)

Examine the EMPLOYEES table structure:

Now, examine this code:

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

Examine these statements:

Which is true?