Oracle 1z0-144

Question 1 of 10

1

View the exhibit and examine the structure of the products table.

Select one of the following:

It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in
packaged procedures.
It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION
cannot be called from the exception section.

Explanation

Question 2 of 10

1

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

Select one of the following:

It executes successfully.
It gives an error because the SAL variable isnot visible in the increase function.
It gives an error because the increase function cannot be called from the RAISE_SALARY procedure.
It gives an error because the increase function and the RAISE_SALARY procedure should be
declared at the beginningof the declare section before all the other declarations.

Explanation

Question 3 of 10

1

Examine the following block of code:

Select one of the following:

line 5
line 8
line 2
line 7

Explanation

Question 4 of 10

1

Which two statements are true about the instead of triggers? (Choose two.)

Select one or more of the following:

Delete operations cannot be performed using the instead of triggers.
The instead or triggers must be created to add or modify datathrough any view.
The instead of triggers can be written only for views, and the before and after timing options are
not valid.
The check option for views is not enforced when Insertions or updates to the view are performed
by using the instead of triggers.

Explanation

Question 5 of 10

1

View the Exhibit and examine the structure of the departments table in SCOTT’s schema.

Select one or more of the following:

JONES executes the procedure with definer's rights.
JONES executes the procedure with invoker's rights.
SCOTT should grant only the execute privilege for the procedure to JONES.
SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the
table to

Explanation

Question 6 of 10

1

Identify two features of obfuscation.

Select one or more of the following:

The Import and Export utilitiesaccept wrapped files.
SQL' Plus cannot process the obfuscated source files.
Only the wrap utility can obfuscate multiple programs at a time.
Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
The sourcecode is visible only through the DBA_SOURCE view and not through the
USER_SOURCE or ALL_SOURCE View

Explanation

Question 7 of 10

1

You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.

Select one or more of the following:

It should be an after trigger.
It should be a before trigger.
It should be a row-level trigger.
It should be astatement-level trigger.
It can be a before or an after trigger.

Explanation

Question 8 of 10

1

ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2)

Examine the following code:

Select one of the following:

It givesan error in line 3.
It gives an error in line 4.
It gives an error in line 6.
It executes successfully and displays the output.

Explanation

Question 9 of 10

1

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

Select one of the following:

All the blocks execute successfully and the anonymous block displays123cant: 4545cnt: 45.
All the blocks execute successfully and the anonymous block displays123cut: 045cart: 1.
The anonymous block gives an error because the function invocation in line 2 is not valid.
The procedure creation gives an error because the function invocation in line 1 is not valid.

Explanation

Question 10 of 10

1

Which two statements correctly differentiate functions and procedures?

Select one or more of the following:

A function can be called only as part of a SQL statement, whereas a procedure can be called only
as a PL/SQL statement.
A function must return a value to the calling environment, whereas a procedure can return zero or
more values to its calling environment.
A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure
can be called only as a PL/SQL statement.
A function may return one or more valuesto the calling environment, whereas a procedure must
return a single value to its calling environment.

	Created by Mahbubul Alam over 5 years ago

Quiz on Oracle 1z0-144, created by Mahbubul Alam on 02/16/2019.

Oracle 1z0-144

Oracle 1z0-144

Question 1 of 10

View the exhibit and examine the structure of the products table.

Select one of the following:

Explanation

Question 2 of 10

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

Select one of the following:

Explanation

Question 3 of 10

Examine the following block of code:

Select one of the following:

Explanation

Question 4 of 10

Which two statements are true about the instead of triggers? (Choose two.)

Select one or more of the following:

Explanation

Question 5 of 10

View the Exhibit and examine the structure of the departments table in SCOTT’s schema.

Select one or more of the following:

Explanation

Question 6 of 10

Identify two features of obfuscation.

Select one or more of the following:

Explanation

Question 7 of 10

You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.

Select one or more of the following:

Explanation

Question 8 of 10

ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code:

Select one of the following:

Explanation

Question 9 of 10

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

Select one of the following:

Explanation

Question 10 of 10

Which two statements correctly differentiate functions and procedures?

Select one or more of the following:

Explanation

ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2)

Examine the following code: