Oracle 1Z0-144 Online Practice Questions and Exam Preparation

Oracle 1Z0-144 Online Questions & Answers

• Question 21:

  Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose two.)

  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
  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

• Question 22:

  Which statement is true about triggers on data definition language (DDL) statements?

  A. They can be used to track changes only to a table or index.
  B. They can be defined by all users in the database or only by a specific user.
  C. They are fired only when the owner of the object issues the DDL statement.
  D. They can be used to track changes to a table, tablespace, view, or synonym.
  D. They can be used to track changes to a table, tablespace, view, or synonym.

• Question 23:

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

  

  Execute the following block of code:

  SQL > SET SERVEROUTPUT ON

  

  What is the outcome?

  A. It gives an error because the variable name and column name are the same in the WHERE clause of the SELECT statement.
  B. It executes successfully and displays the sum of salaries in department 60.
  C. It gives an error because group functions cannot be used in anonymous blocks.
  D. It executes successfully and displays the incorrect sum of salaries in department 60.
  D. It executes successfully and displays the incorrect sum of salaries in department 60.

• Question 24:

  View the Exhibit to examine the PL/SQL code:

  

  DECLARE x NUMBER := 5; y NUMBER := NULL; BEGIN IF x != y THEN -- yields NULL, not TRUE DBMS_OUTPUT.PUT_LINE(`x != y'); -- not run ELSIF x = y THEN -- also yields NULL DBMS_OUTPUT.PUT_LINE(`x = y'); ELSE DBMS_OUTPUT.PUT_LINE (`Can't tell if x and y are equal or not.'); END IF; END; /

  SERVEROUTPUT is on for the session. Which statement is true about the output of the PL/SQL block?

  A. The output is x = y.
  B. It produces an error.
  C. The output is x != y.
  D. The output is Can't tell if x and y are equal or not.
  D. The output is Can't tell if x and y are equal or not.

• Question 25:

  View the Exhibit and examine the blocks of code that you plan to execute.

  

  Which statement is true about the blocks of code?

  A. All the blocks execute successfully and the anonymous block displays
  B. All the blocks execute successfully and the anonymous block displays
  C. The anonymous block gives an error because the function invocation in line 2 is not valid.
  D. The procedure creation gives an error because the function invocation in line 1 is not valid.
  A. All the blocks execute successfully and the anonymous block displays

• Question 26:

  Examine the following package specification:

  

  Which statement is true?

  A. g_comm has a value of 15 at 9:06 AM only for Jones.
  B. g_comm has a value of 10 at 9:03 AM for both Jones and Smith.
  C. g_comm has a value of 15 at 9:03 AM for both Jones and Smith.
  D. g_comm has a value of 20 at 9:06 AM for both Jones and Smith.
  A. g_comm has a value of 15 at 9:06 AM only for Jones.

• Question 27:

  Examine the following PL/SQL code:

  

  The server output is on for the session. Which statement is true about the execution of the code?

  A. The code executes successfully and gives the desired output.
  B. The code generates an error because the EMP_RECORD variable is not declared.
  C. The code generates an error because the cursor is not opened before the FOR loop.
  D. The code generates an error because the loop does not have the exit when clause.
  A. The code executes successfully and gives the desired output.

• Question 28:

  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.
  A. It compiles successfully.

• Question 29:

  /temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder.

  Examine the following commands that are executed by the DBA:

  SQL>CREATE DIRECTION my_dir AS `/temp/my_files':

  SQL>GRANT READ ON DIRECTORY my_dir To public:

  View the Exhibit and examine the procedure created by user SCOTT to read the list of faculty names from the text file.

  

  SCOTT executes the procedure as follows:

  SQL>SET SERVEROUTPUT ON

  SQL>EXEC read_file (`MY_DIR', FACULTYLIST.TXT')

  What is the outcome?

  A. It goes into an infinite loop.
  B. It executes successfully and displays only the list of faculty names.
  C. It does not execute and displays an error message because the end-of-file condition is not taken care of.
  D. It executes successfully and displays the list of faculty names followed by a "no data found" error message.
  D. It executes successfully and displays the list of faculty names followed by a "no data found" error message.

• Question 30:

  Which two statements are true about the continue statement? (Choose two.)

  A. The PL/SQL block execution terminates immediately.
  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 statements after the continue statement in the iteration are executed before terminating the LOOP.
  E. 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.
  E. The current iteration of the loop completes immediately and control passes to the next iteration of the loop.