Oracle 1Z0-149 問題集

質問 1：
The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).
Which two blocks of code execute successfully when invoked by user SH? (Choose two.)
A.

B.

C.

D.

E.

正解：D,E

質問 2：
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

質問 3：
Which three are true about functions and procedures? (Choose three.)
A. The ACCESSIBLE BY clause can be used only for procedures.
B. In a function every RETURN statement must specify an expression.
C. Both can have only constants as actual parameters for IN mode parameters.
D. In a function, every execution path must lead to a RETURN statement.
E. In a procedure the RETURN statement cannot specify an expression.
F. Both can be invoked from within SQL statements.
正解：B,D,E

質問 4：
Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?
A. It will return an error at line 2.
B. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
C. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
D. It will return an error at line 3.
E. It will return an error at line 8.
正解：B

質問 5：
Examine these statements:

Which two are true? (Choose two.)
A. The bank_activity_proc will not compile because of the commit.
B. Neither table will have a row inserted and committed.
C. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
D. Both tables will have a row inserted and committed.
E. Only one table will have a row inserted and committed.
正解：C,E

質問 6：
Which two are true about collections and RECORD types? (Choose two.)
A. Collections and RECORD types are always dense.
B. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
C. A variable of RECORD type can contain fields of another RECORD type or any collection type.
D. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
E. All collections and RECORD types can be stored in table columns.
F. Only associative arrays and nested tables can have elements of RECORD type.
正解：D,F

質問 7：
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?
A.

B.

C.

D.

正解：B