Oracle 1Z0-149 問題集

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

質問 2：
User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)
A. No update happens even though the procedure executes successfully.
B. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
C. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
D. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
E. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
正解：C,E

質問 3：
Examine this table in the SH schema:

User SH executes this code:

The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must "---placeholder" be replaced?
A.
B.
C.
D.
E.
正解：B

質問 4：
Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?
A. It will fail only at line 7.
B. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
C. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
D. It will fail at lines 6 and 7.
正解：A

質問 5：
Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?
A. 10000
B. 5000
C. 15000
D. 2500
正解：D

質問 6：
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
A.
B.
C.
D.
正解：C

質問 7：
Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:

Which is true?
A. It will run successfully producing a result of 4.
B. It will result in an error because table depts has been altered.
C. DEP_VU must be manually recompiled to successfully run this code.
D. It will run successfully producing a result of 5.
正解：A