1Z0-144 | Rebirth 1Z0-144 Exam Study Guides With New Update Exam Questions
Q51. View the Exhibit and examine the structure of the customer table.
Examine the following trigger code:
What is the outcome when the above trigger is compiled?
A. It compiles successfully.
B. It gives an error because the when condition is not valid.
C. It gives an error because when cannot be used for row-level triggers.
D. It gives an error because the statements under updating are not valid.
E. It gives an error because the new qualifier in the when clause requires a colon prefix.
Answer: A
Q52. Examine the following PL/SQL code;
The execution of the code produces errors. Identify the error in the code.
A. The open cursor is missing
B. The fetch clause is missing
C. The exit when condition is missing
D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.
Answer: B
Q53. Which tasks must be performed during the installation of the UTL_MAIL package? (Choose all that apply.)
A. setting the UTL_FILE_DIR initialization parameter
B. running the UTLMAIL.SQL and prvtmail.plb scripts
C. setting the SMTP_OUT_SERVER initialization parameter
D. using the CREATE DIRECTORY statement to associate an alias with an operating system directory
E. granting read and WRITE privileges to control the type of access to files in the operating system
Answer: B,C
Q54. Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)
A. When a query returns multiple rows
B. When a column name in a where clause is unknown at compile time.
C. When the number of columns selected in a query is not known until run time
D. When a table needs to be created based on an existing table structure at run time
E. When privileges need to be granted to a new user to access an existing schema at run time
Answer: B,C
Q55. Consider the following scenario:
Local procedure a calls remote procedure B
Procedure A was compiled at 8 AM.
Procedure A was modified and recompiled at 9 AM.
Remote procedure B was later modified and recompiled at 11 AM.
The dependency mode is set to timestamp.
Which statement correctly describes what happens when procedure A is invoked at 1 PM?
A. Procedure A is invalidated and recompiled immediately.
B. There is no effect on procedure A and it runs successfully.
C. Procedure B is invalidated and recompiled again when invoked.
D. Procedure A is invalidated and recompiles when invoked the next time.
Answer: D
Q56. What is the correct definition of the persistent state of a packaged variable?
A. It is a private variable defined in a procedure or function within a package body whose
value is consistent within a user session.
B. It is a public variable in a package specification whose value is consistent within a user session.
C. It is a private variable in a package body whose value is consistent across all current active sessions.
D. It is a public variable in a package specification whose value is always consistent across all current active sessions.
Answer: B
Q57. View Exhibit1 and examine the structure of the EMP table.
View Exhibit2 and examine the code.
EKPNOS 7845 and 7900 exist in the EMP table.
Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)
A. call in line 6
B. call in line 7
C. call in line 8
D. call in line 9
Answer: C,D
Q58. 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 0, greets session displays 0.
B. SCOTT’S session displays 5, and then 0; green's session displays 5.
C. SCOTT’S session displays 5, and then 5 again, green's session displays 0.
D. SCOTT’S session displays 5, and then 5 again; green's session displays 5.
Answer: B
Q59. View the Exhibit to examine the PL/SQL code.
The record for the employee with employee__id 100 in the employees table is as follows;
Identify the correct output for the code.
A. King 17-JUN-87 1500
B. King 17-JUN-87 24000
C. King current sysdate 1500
D. King current sysdate 24000
Answer: A
Q60. View Exhibit1 and examine the structure of the product table.
View Exhiblt2 and examine the procedure you created. The procedure uses the prod id to determine whether the list price is within a given range.
You then create the following trigger on the product table.
CREATE OR REPLACE TRIGGER check_price__trg
BEF0RE INSERT OR UPDATE OF prod_id, prod_list_price
ON product FOR EACH ROW
WHEN (nev.prod_id <> NVX(old.prod_id,0) OR
New.prod__list_price <> NVL(old.prod_list_price, 0) )
BEGIN
check_price (: new.prod_id) ;
END
/
Examine the following update command for an existing row in the product table.
SQL> UPDATE produce SET prod_list_price = 10 WHERE prod_id=115;
Why does it generate an error?
A. Because the procedure call in the trigger is not valid
B. Because the condition specified in the when clause is not valid
C. Because both the procedure and trigger access the same table
D. Because the WHEN clause cannot be used with a row-level trigger
E. Because the column list specified with UPDATE in the trigger is not valid
Answer: B