1Z0-149 by Oracle Actual Free Exam Q&As

Question 1

Which two are true about lexical units? (Choose two.)

A. A character literal with zero characters has the BOOLEAN value NULL. B. Spaces can be embedded in delimiters. C. Identifiers include labels. D. Character literals are case-sensitive. E. All user-defined identifiers must start with an alphabet.

Discussion 0

Correct Answer: D,E Vote an answer

Question 2

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. It will run successfully producing a result of 5. B. It will result in an error because table depts has been altered. C. It will run successfully producing a result of 4. D. DEP_VU must be manually recompiled to successfully run this code.

Discussion 0

Correct Answer: C Vote an answer

Question 3

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.API.P1 from the HR schema. B. Call HR.HELPER.H1 from the HR schema. C. Call HR.API.P1 from the SH schema. D. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1. E. Call HR.HELPER.H1 from the SH schema.

Discussion 0

Correct Answer: C,E Vote an answer

Question 4

Which is true about EXIT and CONTINUE statements?

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

Discussion 0

Correct Answer: C Vote an answer

Question 5

Which is true about counter variables in a FOR loop?

A. It can be modified in the body of the loop. B. It is accessible outside the body of the loop. C. It cannot be NULL. D. It must explicitly be declared.

Discussion 0

Correct Answer: C Vote an answer

Question 6

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

A. BEFORE STATEMENT B. AFTER SUSPEND C. ROW D. AFTER STATEMENT

Discussion 0

Correct Answer: C Vote an answer

Question 7

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

A.