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?

Which statement is true about user-defined records?

Examine this statement which is submitted for compilation:

Which three are true? (Choose three.)

Which is true about EXIT and CONTINUE statements?

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.