Oracle 1Z0-144 Online Practice Questions and Exam Preparation

Oracle 1Z0-144 Online Questions & Answers

• Question 101:

  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 statements for opening the cursor that fetches the result set consisting of employees with JOB_ID as `ST_CLERK' and SALARY greater than 3000. (Choose three.)

  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);
  B. OPEN c1 (emp_job, 3000);
  D. OPEN c1 (`ST_CLERK', 3000)
  E. OPEN c1 (emp_job, emp_salary);

• Question 102:

  Which three statements are true about wrapping? (Choose three.)

  A. The PL/SQL wrapper detects and reports only syntactic errors.
  B. The PL/SQL wrapper detects and reports both syntactic and semantic errors.
  C. When wrapping a package or object type, both the body and specification should be wrapped.
  D. When wrapping a package or object type, only the body should be wrapped, not the specification.
  E. To change a wrapped object, the original source code needs to be modified and then wrapped again.
  F. To change a wrapped object, the wrapped code can be unwrapped, modified in a text file, and then wrapped again.
  D. When wrapping a package or object type, only the body should be wrapped, not the specification.
  E. To change a wrapped object, the original source code needs to be modified and then wrapped again.
  F. To change a wrapped object, the wrapped code can be unwrapped, modified in a text file, and then wrapped again.

• Question 103:

  Which two statements are true about the %ROWTYPE attribute? (Choose two.)

  A. It is used to declare a record that can hold multiple rows of a table.
  B. The attributes of fields in the record with the %ROWTYPE attribute can be modified manually.
  C. The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable.
  D. 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. The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable.
  D. It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered.

• Question 104:

  Which two statements are true about PL/SQL exception propagation? (Choose two.)

  A. The exception reproduces itself in successive enclosing blocks until a handler is found.
  B. Exception- can propagate across the remote subprograms that are called through database links.
  C. If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception.
  D. If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception.
  A. The exception reproduces itself in successive enclosing blocks until a handler is found.
  C. If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception.

• Question 105:

  View the exhibit and examine the structure of the EMPLOYEES table.

  

  The salary of EMPLOYEE_ID 195 is 2800. You execute the following code: What is the outcome?

  

  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 50000, 2800.
  D. It executes successfully and displays the resultant values in the following sequence: 1000, 2800, 50000, 1000.
  C. It executes successfully and displays the resultant values in the following sequence- 1000, 2800 50000, 2800.

• Question 106:

  You create the following table and execute the following code:

  

  Which statement is true about the outcome of the above code?

  A. It executes successfully and all the rows are updated.
  B. It raises an exception but saves the inserted rows and the update to the first row.
  C. It gives an error but saves the inserted rows; however, no rows are updated.
  D. It gives an error and all the data manipulation language (DML) statements are rolled back.
  B. It raises an exception but saves the inserted rows and the update to the first row.