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?
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?
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.)
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?
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?
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?
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?
Correct Answer: D Vote an answer
0
0
0
10