Oracle Database 11g: Program with PL/SQL - 1Z1-144 FREE EXAM DUMPS QUESTIONS & ANSWERS
View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables.
EMPLOYEES

DEPAERTMENT

EMP_BY_DEPT

Examine the following code:

What is the outcome on execution of the above code?
EMPLOYEES

DEPAERTMENT

EMP_BY_DEPT

Examine the following code:

What is the outcome on execution of the above code?
Correct Answer: C
Vote an answer
View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the code created by the user SCOTT:

SCOTT grants the necessary privileges to green to access the EMP table and execute the package.
Examine the following sequence of activities:
SCOTT starts a session and issues the SQL>EXEC CURS_PKG.OPEN command.
SCOTT then issues the SQL>EXEC CURS_PKG.NEXT command.
green starts a session while SCOTT's session is running and issues THE SQL>EXEC
CURS_PKG.NEXT command.
SCOTT issues the SQI>>EXEC SCOTT.CURS_PKG.NEXT command.
The EMP table contains sequential EMPNOS from 100 through 108.
Which statement correctly describes the output?

View Exhibit2 and examine the code created by the user SCOTT:

SCOTT grants the necessary privileges to green to access the EMP table and execute the package.
Examine the following sequence of activities:
SCOTT starts a session and issues the SQL>EXEC CURS_PKG.OPEN command.
SCOTT then issues the SQL>EXEC CURS_PKG.NEXT command.
green starts a session while SCOTT's session is running and issues THE SQL>EXEC
CURS_PKG.NEXT command.
SCOTT issues the SQI>>EXEC SCOTT.CURS_PKG.NEXT command.
The EMP table contains sequential EMPNOS from 100 through 108.
Which statement correctly describes the output?
Correct Answer: A
Vote an answer
Examine the following partial declare section from a block of PL/SQL code

Which line(s) in the above code are NOT valid? (Choose all that apply.)

Which line(s) in the above code are NOT valid? (Choose all that apply.)
Correct Answer: A,C
Vote an answer
Examine the following snippet of code from the DECLARE section of PL/SQL
DECLARE
Cust_name VERCHAR2 (20) NOT NULL : = 'Tom Jones':
Same_name cust_name%TYPE:
Which statement is correct about the above snippets of code?
DECLARE
Cust_name VERCHAR2 (20) NOT NULL : = 'Tom Jones':
Same_name cust_name%TYPE:
Which statement is correct about the above snippets of code?
Correct Answer: B
Vote an answer
Which two statements are true about the instead of triggers? (Choose two.)
Correct Answer: B,D
Vote an answer
Which two statements are correct about PL/SQL package components? (Choose two)
Correct Answer: C,D
Vote an answer
ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code:

Which statement is correct about the above code?

Which statement is correct about the above code?
Correct Answer: D
Vote an answer
View the Exhibit to examine the PL/SQL code:

SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQL block?

SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQL block?
Correct Answer: C
Vote an answer
You want to store values of different data types in a PL/SQL block and store one record at a time for processing the information.
Which type of composite data type would you choose to fulfill the requirement?
Which type of composite data type would you choose to fulfill the requirement?
Correct Answer: D
Vote an answer