Oracle 1Z0-144 問題集

質問 1：
You create the following table and execute the following code:

Which statement is true about the outcome of the above code?
A. It gives an error but saves the inserted rows and the update to the first row.
B. It gives an error but saves the inserted rows; however, no rows are updated.
C. It gives an error and all the data manipulation language (DML) statements are rolled back
D. It executes successfully and all the rows are updated.
正解：D

質問 2：
Examine the following code that you plan to execute:

What correction should be performed in the above code?
A. The PROC3 procedure header should be declared at the beginning of the package body.
B. The variable x must be declared in the package body and removed from the specification,
C. The PROC2 procedure code should be defined in the package body.
D. The PROC3 procedure should be declared in the package specification.
正解：C,D

質問 3：
User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger: CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, 'Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?
A. SCOTT, HR, and SYS
B. SCOTT and HR
C. Only HR
D. Only SCOTT
正解：C

質問 4：
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?
A. It executes successfully and displays the output.
B. It gives an error in line 4
C. It gives an error in line 3
D. It gives an error in line 6
正解：A

質問 5：
You want to maintain an audit of the date and time when each user of the database logs off.
Examine the following code:

Which two clauses should be used to fill in the blanks and complete the above code?
(Choose two.)
A. ON QRXABASE
B. ON SCHEMA
C. AFTER LOGOFF
D. BEFORE LOGOFF
正解：B,D

質問 6：
View the Exhibit and examine the structure of the employees table.

Execute the following block of code:

What is the outcome?
A. It executes successfully and correctly gives the result of the sum of salaries in
department 60.
B. It gives an error because the variable name and column name are the same in the where clause of the select statement.
C. It gives an error because group functions cannot be used in anonymous blocks
D. It executes successfully and incorrectly gives the result of the sum of salaries in department 60.
正解：D