[Oct-2022] Valid Way To Pass Oracle Exam Dumps with 1Z0-144 Exam Study Guide
All 1Z0-144 Dumps and Oracle Database 11g: Program with PL/SQL Training Courses Help candidates to study and pass the Exams hassle-free!
NEW QUESTION 54
ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code:
Which statement is correct about the above code?
- A. It gives an error in line 6
- B. It executes successfully and displays the output.
- C. It gives an error in line 3
- D. It gives an error in line 4
Answer: B
NEW QUESTION 55
View the Exhibit and examine the structure of the departments table in SCOTT's schema.
Examine the following block of code:
The above procedure is created by user SCOTT. Another user JONES needs to use the procedure.
Which two statements are true in the above scenario? (Choose two.)
- A. JONES executes the procedure with definer's rights.
- B. SCOTT should grant both the execute privilege for the procedure and insert privilege for the table to JONES.
- C. SCOTT should grant only the execute privilege for the procedure to JONES.
- D. JONES executes the procedure with invoker's rights.
Answer: A,C
Explanation:
Explanation/Reference:
NEW QUESTION 56
Which two statements are true about the continue statement? (Choose two.)
- A. The current iteration of the loop completes immediately and control passes to the next iteration of the loop
- B. The CONTINUE statement cannot appear outside a loop.
- C. The loop completes immediately and control passes to the statement after end loop.
- D. The PL/SQL block execution terminates immediately.
- E. The statements after the continue statement in the iteration are executed before terminating the LOOP.
Answer: A,B
NEW QUESTION 57
Which two statements are true about anonymous blocks and named subprograms?
(Choose two)
- A. The declare section is optional for both anonymous blocks and subprograms.
- B. Subprograms are by default executed with definer's rights.
- C. Both anonymous blocks and subprograms execute by default with invoker's rights.
- D. The declare section is mandatory for anonymous blocks and optional for subprograms.
Answer: A,B
NEW QUESTION 58
Which statements are true about PL/SQL procedures? (Choose all that apply.)
- A. Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time.
- B. A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java.
- C. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.
- D. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.
Answer: A,B
NEW QUESTION 59
Which two statements are true about the handling of internally defined or user-defined PL7SQL exceptions? (Choose two.)
- A. An exception handler should commit the transaction.
- B. Add exception handlers whenever errors occur.
- C. Handle named exceptions whenever possible instead of using when others in exception handlers
- D. Instead of adding exception handlers to your PL/SQL block, check for errors at every point where they may occur.
Answer: C,D
NEW QUESTION 60
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, green's session displays 5.
- C. SCOTT'S session displays 5, and then 0, green's session displays 0.
- D. SCOTT'S session displays 5, and then 5, again; green's session displays 5.
Answer: C
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 61
View the Exhibit and examine the structure of the departments table in SCOTT's schema.
Examine the following block of code:
CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS
BEGIN
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
The above procedure is created by user SCOTT. Another user JONES needs to use the procedure.
Which two statements are true in the above scenario? (Choose two.)
- A. JONES executes the procedure with definer's rights.
- B. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to
- C. SCOTT should grant only the execute privilege for the procedure to JONES.
- D. JONES executes the procedure with invoker's rights.
Answer: A,C
NEW QUESTION 62
Which two statements are true about the %ROWTYPE attribute? (Choose two.)
- A. The attributes of fields in the record with the %ROWTYPE attribute can be modified manually.
- B. It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered.
- C. It is used to declare a record that can hold multiple rows of a table.
- D. The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable.
Answer: B,D
NEW QUESTION 63
View Exhibit1 and examine the structure of the employees table.
View Exhibit2 and examine the code.
What would be the outcome when the code is executed?
- A. It gives an error because the SAL variable is not visible in the increase function.
- B. It gives an error because the increase function cannot be called from the RAISE_SALARY procedure.
- C. It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declarations.
- D. It executes successfully.
Answer: D
NEW QUESTION 64
Examine the following partial declare section from a block of PL/SQL code
Which line(s) in the above code are NOT valid? (Choose all that apply.)
- A. line 5
- B. line 4
- C. line 3
- D. line 2
Answer: A,C
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 65
Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)
- A. AFTER LOGON
- B. BEFORE SHUTDOWN
- C. AFTER SERVERERROR
- D. AFTER STARTUP
Answer: A,C
Explanation:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064
NEW QUESTION 66
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 gives an error because the when condition is not valid.
- B. It compiles successfully.
- C. It gives an error because the statements under updating are not valid.
- D. It gives an error because when cannot be used for row-level triggers.
- E. It gives an error because the new qualifier in the when clause requires a colon prefix.
Answer: B
NEW QUESTION 67
View the Exhibit to examine the PL/SQL code.
SERVEROUTPUTis on for the session.
Which statement is true about the execution of the code?
- A. The execution is successful even if there is no employee with EMPLOYEE_ID 115.
- B. The execution fails and throws exceptions if no employee with EMPLOYEE_ID 115is found.
- C. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.
- D. The execution fails because of the misplaced elseclause.
Answer: B
NEW QUESTION 68
Examine the following code:
What is the outcome?
- A. The procedure gives errors because the parameters should be in out mode.
- B. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure.
- C. The procedure is created successfully and displays the values 20 and 30 when it is called.
- D. The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedure.
Answer: B
NEW QUESTION 69
Which two statements are true about the exit statement encountered in loop? (Choose two.)
- A. The loop completes immediately and control passes to the statement after END LOOP.
- B. The current iteration of the loop completes immediately and control passes to the next iteration of the loop.
- C. The statements after the exit statement in the Iteration are not executed before terminating the LOOP.
- D. The PL/SQL block execution terminates immediately after the exit statement.
Answer: A,C
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 70
View the Exhibit and examine the structure of the EMP table.
You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number.
Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)
- A. The procedures should be created only as stand-alone subprograms
- B. Each subprogram's formal parameters should differ in both name and data type.
- C. The procedures can be either stand-alone or packaged.
- D. The procedures should be created only as packaged subprograms
- E. The formal parameters of each subprogram should differ in data type but can use the same names.
Answer: D,E
NEW QUESTION 71
Examine the following snippet of code from the DECLARE section of PL/SQL
DECLARE
Cut_name VERCHAR2 (20) NOT NULL := 'tom jones':
Same_name cut_name\TYPE:
Which statement is correct about the above snippets of code?
- A. The variable inherits only the data type from the CUT_NAME variable.
- B. The 3ake_nake variable inherits the data type, constraint, and default value from the CUT_NAME variable.
- C. The 3ake_nake variable inherits only the data type and constraint from the CUT_NAME variable resulting in an error
- D. The same_name variable inherits only the data type and default value from the CUT_NAME variable.
Answer: A,D
NEW QUESTION 72
Which statements are true about database triggers? (Choose all that apply.)
- A. They are implicitly fired when a triggering event occurs, depending on which user is connected
- B. They can include SQL and PL/SQL or calls to Java procedures.
- C. They can invoke only PL/SQL procedures
- D. They are implicitly fired by an event that must occur within an application
Answer: A,C
Explanation:
Reference:http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch15.htm
NEW QUESTION 73
View the Exhibit and examine the code and its outcome on execution:
What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)
- A. MY_PROC2 is recompiled but remains unchanged.
- B. MY_PROC1 is recompiled without the debugging code.
- C. MY_PROC1 is recompiled but remains unchanged.
- D. MY_PROC2 is not recompiled.
Answer: B,D
NEW QUESTION 74
......
Get Latest [Oct-2022] Conduct effective penetration tests using DumpsFree 1Z0-144: https://prep4sure.dumpsfree.com/1Z0-144-valid-exam.html