1Z0-144 Online Practice Questions and Answers

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

Examine the following code: Which statement is true when the procedure DELETE_DETAILS is invoked?

A. It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table

B. It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.

C. It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.

D. It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.

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

View Exhibit 2 and examine the code.

What would be the outcome when the code is executed?

A. It executes successfully.

B. It gives an error because the SAL variable is not visible in the INCREASE function.

C. It gives an error because the INCREASE function cannot be called from the RAISE_SALARY procedure.

D. It gives an error because the INCREASE function and the RAISE_SALARY procedure should be declared at the beginning of the DECLARE section before all the other declarations.

Identify two situations where the DBMS_SQL package should be used. (Choose two.)

A. The SELECT list is not known until run time.

B. The dynamic SQL statement retrieves rows into records.

C. You do not know how many columns a SELECT statement will return, or what their data types will be.

D. You must use the % FOUND SQL cursor attribute after issuing a dynamic SQL statement that is an INSERT or UPDATE statement.

Which two statements are true about statement-level and row-level triggers? (Choose two.)

A. A row trigger fires once even if no rows are affected.

B. A statement trigger fires once even if no rows are affected.

C. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

D. Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

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

View Exhibit 2 and examine the code.

EKPNOS 7845 and 7900 exist in the EMP table.

Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)

A. call in line 6

B. call in line 7

C. call in line 8

D. call in line 9

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.

View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables.

EMPLOYEES

DEPARTMENTS

EMP_BY_DEPT

Examine the following code:

What is the outcome on execution of the above code?

A. It executes successfully but the output statements show different values.

B. It executes successfully and both output statements show the same values.

C. It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLECT.

D. It gives an error because the INSERT SELECT construct cannot be used with the FORALL

Which two statements are true about the %ROWTYPE attribute? (Choose two.)

A. It is used to declare a record that can hold multiple rows of a table.

B. The attributes of fields in the record with the %ROWTYPE attribute can be modified manually.

C. The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable.

D. It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered.

Examine the following PL/SQL code; The execution of the code produces errors. Identify the error in the code.

A. The OPEN cursor is missing.

B. The FETCH clause is missing.

C. The EXIT WHEN condition is missing.

D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.

View the Exhibit and examine the partial data in the PRODUCTS table. PROD_ID is the primary key.

Examine the following code: What is the outcome on execution of the above code?

A. It executes successfully.

B. It gives an error because the DECODE function can be used only in a SQL statement.

C. It gives an error because the SUBSTR and INSTR functions can be used only in a SQL statement.

D. It gives an error because both the MAX and DECODE functions can be used only in a SQL statement.