Master the 1Z0-144 Oracle Database 11g: Program with PL/SQL content and be ready for exam day success quickly with this Exambible 1Z0-144 practice question. We guarantee it!We make it a reality and give you real 1Z0-144 questions in our Oracle 1Z0-144 braindumps.Latest 100% VALID Oracle 1Z0-144 Exam Questions Dumps at below page. You can use our Oracle 1Z0-144 braindumps and pass your exam.
2017 NEW RECOMMEND
Free VCE & PDF File for Oracle 1Z0-144 Real Exam
Pass on Your First TRY 100% Money Back Guarantee Realistic Practice Exam Questions
Q41. Which two statements are true about triggers? (Choose two.)
A. All the triggers that are created on a table cannot be disabled simultaneously.
B. Any user who has the alter privilege on a table can create a trigger using that table.
C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database.
D. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation.
Q42. 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
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
The above procedure is created by user SCOTT. Another user JONES needs to use the
Which two statements are true in the above scenario? (Choose two.)
A. JONES executes the procedure with definer's rights.
B. JONES executes the procedure with invoker's rights.
C. SCOTT should grant only the execute privilege for the procedure to JONES.
D. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to
Q43. In which of the following scenarios would you recommend using associative arrays?
A. When you want to retrieve an entire row from a table and perform calculations
B. When you know the number of elements in advance and the elements are usually accessed sequentially
C. When you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries
D. When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked.
Q44. You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded.
The procedure should return an "error" condition to the caller in a manner consistent with other Oracle server errors.
Which construct should be used to handle this requirement?
A. The SQLERRM function
B. The PRAGMA EXCEPTION_INIT function
C. The RAISE_APPLICATION_ERROR procedure
D. A user-defined exception used with a raise statement
Reference: http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/exceptioninit_pragma.htm#LNPL S01315
Q45. Identify two situations where the DBMS_SQL package should be used. (Choose two.)
A. The SELECT list is not known until run time.
B. The dynamic SQL statement retrieves rows into records.
C. You do not know how many columns a select statement will return, or what their data types will.
D. You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.
Q46. Examine the following block of code:
Which two statements are correct about the code above? (Choose two.)
A. The function goes through only the parse and executes phases.
B. The function goes through the parse, bind, and execute phases.
C. The function goes through the parse, bind, execute, and fetch phases.
D. All the processing phases for the function are performed only at run time.
E. Only the EXECUTE IMMEDIATE statement inside the function is parsed at run time.
Q47. Examine the following code that you plan to execute:
What correction should be performed in the above code?
A. The PROC2 procedure code should be defined in the package body.
B. The PROC3 procedure should be declared in the package specification.
C. The PROC3 procedure header should be declared at the beginning of the package body.
D. The variable x must be declared in the package body and removed from the specification,
Q48. The STRING_TAB table has the following structure:
View the Exhibit and examine the code.
What is the outcome on execution?
A. It displays
Output buffer not long enough.
This is my test string.-.
B. It displays only
Output buffer not long enough, and exits the anonymous block.
C. It displays only
This is my test string. – Because EXCEPTION should have been defined in the anonymous
block to get the error message.
D. It does not display any of the MEMS_PUTPUT messages and gives an error because a
transaction control statement cannot be used in the exception section of a procedure.
Q49. Which two statements are true about the instead of triggers? (Choose two.)
A. Delete operations cannot be performed using the instead of triggers.
B. The instead or triggers must be created to add or modify data through any view.
C. The instead of triggers can be written only for views, and the before and after timing options are not valid.
D. The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of trigger.
Q50. 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.