Free 1Z0-144 Exam Dumps PDF Preview

Question 1

Single choice

Consider the following scenario:

Local procedure A calls remote procedure B.
Procedure B was compiled at 8 AM.
Procedure A was modified and recompiled at 9 AM.
Remote procedure B was later modified and recompiled at 11 AM.

The dependency mode is set to TIMESTAMP.

Which statement correctly describes what happens when procedure A is invoked at 1 PM?

A
Procedure A is invalidated and recompiled immediately.
B
There is no effect on procedure A and it runs successfully.
C
Procedure B is invalidated and recompiled again when invoked.
D
Procedure A is invalidated and recompiles when invoked the next time.

Reveal answer details Close answer details

Correct answerD

Question 2

Multiple choice

Which two statements are true about the INSTEAD OF triggers? (Choose two.)

A
DELETE operations cannot be performed using the INSTEAD OF triggers.
B
The INSTEAD OF triggers must be created to add or modify data through any view.
C
The INSTEAD OF triggers can be written only for views, and the BEFORE and AFTER timing options are not valid.
D
The CHECK option for views is not enforced when insertions or updates to the view are performed by using the INSTEAD OF triggers.

Reveal answer details Close answer details

Correct answersC, D

Question 3

Single choice

You execute the following block of code:

Which statement is true about the outcome?

A
Both output statements show different values.
B
Both output statements show exactly the same values.
C
It gives an error because the nested blocks are not labeled.
D
It gives an error because the V_CUSTOMER variable cannot have different types in the nested blocks.

Reveal answer details Close answer details

Correct answerA

Question 4

Multiple choice

Which two statements are true about the handling of internally defined or user-defined PL/SQL exceptions? (Choose two.)

A
Add exception handlers whenever errors occur.
B
An exception handler should commit the transaction.
C
Handle named exceptions whenever possible instead of using when others in exception handlers.
D
Instead of adding exception handlers to your PL/SQL block, check for errors at every point where they may occur.

Reveal answer details Close answer details

Correct answersA, C

Question 5

Single choice

View the Exhibit and examine the structure of the customer table.

You create the following trigger to ensure that customers belonging to category "A" or "B" in the CUSTOMER table can have a credit limit of more than 8000.

What is the outcome?

A
The trigger is fired, a message is displayed, and the update is successful.
B
The trigger is fired and a message is displayed, but the update is rolled back.
C
The trigger is not fired because the WHEN clause should be used to specify the condition; however,
the update is successful.
D
The trigger is not fired because column names must be specified with the UPDATE event to identify
which columns must be changed to cause the trigger to fire; however, the update is successful.

Reveal answer details Close answer details

Correct answerA

Question 6

Single choice

View the Exhibit and examine the blocks of code that you plan to execute.

Which statement is true about the blocks of code?

A
All the blocks execute successfully and the anonymous block displays
B
All the blocks execute successfully and the anonymous block displays
C
The anonymous block gives an error because the function invocation in line 2 is not valid.
D
The procedure creation gives an error because the function invocation in line 1 is not valid.

Reveal answer details Close answer details

Correct answerA

Question 7

Single choice

You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded.

The procedure should return an "error" condition to the caller in a manner consistent with other Oracle server errors.

Which construct should be used to handle this requirement?

A
The SQLERRM function
B
The PRAGMA EXCEPTION_INIT function
C
The RAISE_APPLICATION_ERROR procedure
D
A user-defined exception used with a RAISE statement

Reveal answer details Close answer details

Correct answerC

Question 8

Single choice

Identify the scenario in which you would use the CURRENT OF clause for an UPDATE or DELETE statement to rows fetched from a cursor.

A
when you want to lock the rows fetched by the cursor
B
when you want to update or delete the result set without affecting the rows in the table
C
when you want the database not to wait if the requested rows are locked by another user
D
when you want to ensure that the current rows fetched by the cursor are updated or deleted

Reveal answer details Close answer details

Correct answerD

Explanation

References:
https://www.techonthenet.com/oracle/cursors/current_of.php

Question 9

Multiple choice

Which two statements are true about database triggers? (Choose two.)

A
Each trigger can be of any size.
B
Each trigger can be of a maximum size of 32 KB.
C
A trigger can contain a maximum of 32 lines of code.
D
Triggers fired by DML statements cannot cascade simultaneously.
E
Both DML and DDL statements can cascade any number of triggers.
F
Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers.

Reveal answer details Close answer details

Correct answersB, F

Question 10

Multiple choice

Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic
SQL. (Choose two.)

A
When a query returns multiple rows
B
When a column name in a where clause is unknown at compile time
C
When the number of columns selected in a query is not known until run time
D
When a table needs to be created based on an existing table structure at run time
E
When privileges need to be granted to a new user to access an existing schema at run time

Reveal answer details Close answer details

Correct answersB, C

Question 11

Multiple choice

Examine the following snippet of PL/SQL code:

View the Exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.

Identify OPEN statements for opening the cursor that fetches the result set consisting of employees with JOB_ID as `ST_CLERK' and SALARY greater than 3000. (Choose three.)

A
OPEN c1 (NULL, 3000);
B
OPEN c1 (emp_job, 3000);
C
OPEN c1 (3000, emp_salary);
D
OPEN c1 (`ST_CLERK', 3000)
E
OPEN c1 (emp_job, emp_salary);

Reveal answer details Close answer details

Correct answersB, D, E

Question 12

Single choice

/temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder.

Examine the following commands that are executed by the DBA:

SQL>CREATE DIRECTION my_dir AS `/temp/my_files':
SQL>GRANT READ ON DIRECTORY my_dir To public:

View the Exhibit and examine the procedure created by user SCOTT to read the list of faculty names from the text file.

SCOTT executes the procedure as follows:

SQL>SET SERVEROUTPUT ON
SQL>EXEC read_file (`MY_DIR', FACULTYLIST.TXT')

What is the outcome?

A
It goes into an infinite loop.
B
It executes successfully and displays only the list of faculty names.
C
It does not execute and displays an error message because the end-of-file condition is not taken care of.
D
It executes successfully and displays the list of faculty names followed by a "no data found" error message.

Reveal answer details Close answer details

Correct answerD

Question 13

Single choice

View Exhibit 1 and examine the structure of the EMP table.

View Exhibit 2 and examine the PL/SQL block of code.

What is the outcome?

A
It gives an error because the return type is not valid.
B
It gives an error because the record type is not defined within the function.
C
It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid
D
It executes successfully and displays the names and salaries of all employees who earn the highest salary.
E
It executes successfully but does not display the names and salaries of all employees who earn the highest salary.

Reveal answer details Close answer details

Correct answerE

Question 14

Multiple choice

Which two statements are true about the EXIT statement encountered in LOOP? (Choose two.)

A
The PL/SQL block execution terminates immediately after the EXIT statement.
B
The loop completes immediately and control passes to the statement after END LOOP.
C
The statements after the EXIT statement in the iteration are not executed before terminating the LOOP.
D
The current iteration of the loop completes immediately and control passes to the next iteration of the loop.

Reveal answer details Close answer details

Correct answersB, C

Question 15

Single choice

In which of the following scenarios would you recommend using PL/SQL records?

A
when you want to retrieve an entire row from a table and perform calculations
B
when you know the number of elements in advance and the elements are usually accessed sequentially
C
when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries
D
when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked

Reveal answer details Close answer details

Correct answerA

Question 16

Multiple choice

Which two statements are true about PL/SQL exception propagation? (Choose two.)

A
The exception reproduces itself in successive enclosing blocks until a handler is found.
B
Exception-can propagate across the remote subprograms that are called through database links.
C
If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception.
D
If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception.

Reveal answer details Close answer details

Correct answersA, C

VOL	TYPE	QUESTIONS
1	Single choice	9
2	Multiple choice	7

Free 1Z0-144 Exam Dumps Preview

Oracle Database 11g: Program with PL/SQL

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16