Oracle 1z0-144

Frage 1 von 10

1

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

Wähle eine der folgenden:

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.

Erklärung

Frage 2 von 10

1

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

Wähle eine der folgenden:

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.

Erklärung

Frage 3 von 10

1

Examine the following block of code:

Wähle eine der folgenden:

line 5
line 8
line 2
line 7

Erklärung

Frage 4 von 10

1

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

Wähle eine oder mehr der folgenden:

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.

Erklärung

Frage 5 von 10

1

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

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 6 von 10

1

Identify two features of obfuscation.

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 7 von 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.

Wähle eine oder mehr der folgenden:

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.

Erklärung

Frage 8 von 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:

Wähle eine der folgenden:

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.

Erklärung

Frage 9 von 10

1

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

Wähle eine der folgenden:

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.

Erklärung

Frage 10 von 10

1

Which two statements correctly differentiate functions and procedures?

Wähle eine oder mehr der folgenden:

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.

	Erstellt von Mahbubul Alam vor fast 6 Jahre

Quiz am Oracle 1z0-144, erstellt von Mahbubul Alam am 16/02/2019.

Oracle 1z0-144

Frage 1 von 10

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

Wähle eine der folgenden:

Erklärung

Frage 2 von 10

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

Wähle eine der folgenden:

Erklärung

Frage 3 von 10

Examine the following block of code:

Wähle eine der folgenden:

Erklärung

Frage 4 von 10

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

Wähle eine oder mehr der folgenden:

Erklärung

Frage 5 von 10

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

Wähle eine oder mehr der folgenden:

Erklärung

Frage 6 von 10

Identify two features of obfuscation.

Wähle eine oder mehr der folgenden:

Erklärung

Frage 7 von 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.

Wähle eine oder mehr der folgenden:

Erklärung

Frage 8 von 10

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

Wähle eine der folgenden:

Erklärung

Frage 9 von 10

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

Wähle eine der folgenden:

Erklärung

Frage 10 von 10

Which two statements correctly differentiate functions and procedures?

Wähle eine oder mehr der folgenden:

Erklärung

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

Examine the following code: