Oracle 1Z0-149 問題集

質問 1：
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
A. DROP
B. ALTER
C. UPDATE
D. DELETE
E. SELECT
F. INSERT
G. CREATE
正解：C,E,F

質問 2：
Which is true about EXIT and CONTINUE statements?
A. They have the same effect on the execution of a loop.
B. They must have a WHEN condition.
C. They must use labels.
D. They can be used in any type of loop.
正解：D

質問 3：
Which two are true about implicit data type conversion? (Choose two.)
A. ROWIDS are always implicitly converted to a number when used in a query.
B. RAW data types are always implicitly converted to a CLOB when used in a query.
C. Collections can be implicitly converted to records.
D. Comparison between character value and a number value always implicitly converts the character value to the number data type.
E. Implicit data type conversion can negatively impact performance.
正解：D,E

質問 4：
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)
A. A function definition can be modified without dropping and re-creating it.
B. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
C. This clause can be used only for procedures and functions.
D. Object privileges to execute a replaced function are retained by those users who had the privileges.
E. Function based indexes remain usable when replacing the function on which the index depends.
正解：A,D

質問 5：
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
A.

B.

C.

D.

正解：C

質問 6：
Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?
A. It results in an error because Authid Current_User is missing from MYPROC.
B. It executes successfully.
C. It results in an error because Authid Definer is missing from MYPROC.
D. It results in an error because USERB doesn't have select privilege on USERA.EMP.
正解：B

質問 7：
Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)
A. a predefined PL/SQL-only data type like BOOLEAN
B. a record declared in a procedure
C. an associative array indexed by VARCHAR2
D. a record declared in a package specification
E. an associative array indexed by PLS_INTEGER
F. a record declared in an anonymous block
正解：C,D,E