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. AFTER STARTUP
C. BEFORE SHUTDOWN
D. AFTER SERVERERROR
In which of the following scenarios would you recommend using PL/SQL records?
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 in
memory each time a subprogram is invoked
A. It gives an error because group functions cannot be used in anonymous blocks
B. It executes successfully and correctly gives the result of the sum of salaries in department 60.
C. It executes successfully and incorrectly gives the result of the sum of salaries in department 60.
D. It gives an error because the variable name and column name are the same in the where clause of the select statement.
Examine the following snippet of PL/SQL code:
View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.
Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as `ST_CLERK’ and salary greater than 3000.
A. OPEN c1 (NULL, 3000);
B. OPEN c1 (emp_job, 3000);
C. OPEN c1 (3000, emp_salary);
D. OPEN c1 (`ST_CLERK’, 3000)
E. OPEN c1 (EMP_job, emp_salary);
A. It gives an error because only the innermost block is labeled
B. It gives an error because the same variable name cannot be used across all the nested blocks.
C. It executes successfully and displays the resultant values in the following sequence- 1000, 2800
D. It executes successfully and displays the resultant values in the following sequence: 1000, 2800,
Which two statements are true about the usage of the cursor for loops? (Choose two.)
A. The cursor needs to be closed after the iteration is complete.
B. The implicit open, fetch, exit, and close of the cursor happen.
C. The record type must be explicitly declared to control the loop.
D. The PL/SQL creates a record variable with the fields corresponding to the columns of the cursor result set.
A. The program abruptly terminates and an exception is raised.
B. The program executes successfully and the output is No ROWS_FOUND.
C. The program executes successfully and the query fetches a null value in the V_LNAME variable.
D. Program executes successfully, fetches a NULL value in the V_LNAME variable and an exception is raised.
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.
Examine the following snippet of code from the DECLARE section of PL/SQL
Cut_name VERCHAR2 (20) NOT NULL := `tom jones’:
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 same_name variable inherits only the data type and default value from the CUT_NAME variable.
C. The 3ake_nake variable inherits the data type, constraint, and default value from the CUT_NAME
D. The 3ake_nake variable inherits only the data type and constraint from the CUT_NAME variable
resulting in an error
Passing your Oracle 1Z0-144 Exam by using the latest 1Z0-144 Exam Demo Full Version: http://www.braindump2go.com/1z0-144.html