Oracle 1Z0-144 問題集

質問 1：
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 1 2 3 cant: 45 45 cnt: 45
B. All the blocks execute successfully and the anonymous block displays 1 2 3 cut: 0 45 cart: 1
C. The procedure creation gives an error because the function invocation in line 1 is not valid.
D. The anonymous block gives an error because the function invocation in line 2 is not valid.
正解：A

質問 2：
View Exhibit1 and examine the structure of the employees table.

User SCOTT needs to generate a text report that contains the names of all employees and their salaries.
Examine the following commands issued by the DBA: SQL_CREATE DICTORY my_dir AS '/temp/my_files* ; SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;
View Exhibit2 and examine the procedure code. You issue the following command: You issue the following command:

SQL_EXEC sal_5tatus ('MY_DIR', 'EMPREPORT.TXT')
What is the outcome?
A. It gives an error because the "no data found" condition is not handled to come out of the loop.
B. It executes but no data is written to the text file because the FFLUSH subprogram is not used to write all the data buffered in memory to a file.
C. It executes successfully and creates the report.
D. It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.
E. It gives an error because the text file should be opened in append mode.
正解：C

質問 3：
Identify two features of obfuscation. (Choose two.)
A. The Import and Export utilities accept wrapped files.
B. SQL' Plus cannot process the obfuscated source files.
C. Only the wrap utility can obfuscate multiple programs at a time.
D. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
E. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
正解：A,C

質問 4：
View the exhibit and examine the structure of the EMPLOYEE table.
EMPLOYEE_SEQ is an existing sequence.
Examine the following block of code:

Which statement is true about the above block of code?
A. It gives an error on execution because sequences cannot be used in anonymous blocks.
B. It consists of a single transaction,
C. The data is automatically committed after the block execution ends,
D. It consists of two transactions
正解：D

質問 5：
Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)
A. Reference tables directly avoid using views.
B. Reference tables indirectly by using views.
C. When adding new items to a package, add them to the end of the package.
D. When adding new items to a package, add them to the beginning of the package.
正解：B,C

質問 6：
View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green.

Examine the following sequence of commands issued by SCOTT:

What is the outcome?
A. SCOTT'S session displays 5, and then 5 again, green's session displays 0.
B. SCOTT'S session displays 5, and then 0, greets session displays 0.
C. SCOTT'S session displays 5, and then 0; green's session displays 5.
D. SCOTT'S session displays 5, and then 5 again; green's session displays 5.
正解：C