1Z0-144 Practice Oracle Verified Answers - Pass Your Exams For Sure! [2022]

Valid Way To Pass Other Oracle Certification's  1Z0-144 Exam

NEW QUESTION 36
View Exhibit 1 and examine the structure of the DO table.

View Exhibit 2 and examine the code.

The anonymous block gives an error on execution. What is the reason?

• A. The SQL does not support the Boolean data type.
• B. A null value cannot be applied to the bind arguments in the using clause in line 10.
• C. The names of bind variables must be the same as the using clause bind arguments in line 10.
• D. The assignment in line 7 is not valid.

Answer: A

Explanation:
Explanation/Reference:
Explanation:

 

NEW QUESTION 37
View Exhibit1 and examine the structure of the employees table.

User SCOTT needs to generate a text report that contains the names of all employees and their salaries.
Examine the following commands issued by the DBA: SQL_CREATE DICTORY my_dir AS '/temp/my_files* ; SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;
View Exhibit2 and examine the procedure code. You issue the following command: You issue the following command:

SQL_EXEC sal_5tatus ('MY_DIR', 'EMPREPORT.TXT')
What is the outcome?

• A. It gives an error because the text file should be opened in append mode.
• B. It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.
• C. It gives an error because the "no data found" condition is not handled to come out of the loop.
• D. It executes but no data is written to the text file because the FFLUSH subprogram is not used to write all the data buffered in memory to a file.
• E. It executes successfully and creates the report.

Answer: E

 

NEW QUESTION 38
View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the code.

EKPNOS 7845 and 7900 exist in the EMP table.
Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)

• A. call in line 9
• B. call in line 6
• C. call in line 7
• D. call in line 8

Answer: A,D

 

NEW QUESTION 39
View Exhibit1 and examine the structure of the product table.

View Exhiblt2 and examine the procedure you created. The procedure uses the prod id to determine whether the list price is within a given range.

You then create the following trigger on the product table.
CREATE OR REPLACE TRIGGER check_price__trg
BEF0RE INSERT OR UPDATE OF prod_id, prod_list_price
ON product FOR EACH ROW
WHEN (nev.prod_id <> NVX(old.prod_id,0) OR
New.prod__list_price <> NVL(old.prod_list_price, 0) )
BEGIN
check_price (:new.prod_id) ;
END
/
Examine the following update command for an existing row in the product table.
SQL> UPDATE produce SET prod_list_price = 10 WHERE prod_id=115;
Why does it generate an error?

• A. because both the procedure and trigger access the same table
• B. because the procedure call in the trigger is not valid "
• C. because the WHEN clause cannot be used with a row-level trigger
• D. because the condition specified in the when clause is not valid
• E. because the column list specified with UPDATE in the trigger is not valid

Answer: A

 

NEW QUESTION 40
Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

• A. Line 4
• B. Line 3
• C. Line 2
• D. Line 6
• E. Line 5

Answer: C

Explanation:
Explanation/Reference:
Explanation:

 

NEW QUESTION 41
Which statements are true about PL/SQL procedures? (Choose all that apply.)

• A. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.
• B. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.
• C. 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.
• D. 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.

Answer: C,D

 

NEW QUESTION 42
Examine the following PL/SQLcode;

The execution of the code produces errors. Identify the error in the code.

• A. The exit when condition is missing
• B. The open cursor is missing
• C. The fetch clause is missing
• D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.

Answer: C

 

NEW QUESTION 43
Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor.

• A. when you want to ensure that the current rows fetched by the cursor are updated or deleted
• B. when you want the database not to wait if the requested rows are locked by another user
• C. when you want to lock the rows fetched by the cursor
• D. when you want to update or delete the result set without affecting the rows in the table '

Answer: D

 

NEW QUESTION 44
View the Exhibit to examine the PL/SQL code:

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

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

Answer: D

 

NEW QUESTION 45
Examine the following PL/SQL code;

The execution of the code produces errors. Identify the error in the code.

• A. The fetch clause is missing.
• B. The open cursor is missing.
• C. The exit when condition is missing.
• D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.

Answer: D

Explanation:
Explanation/Reference:
Explanation:

 

NEW QUESTION 46
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 should be created only as packaged subprograms
• D. The formal parameters of each subprogram should differ in data type but can use the
  same names.
• E. The procedures can be either stand-alone or packaged.

Answer: C,D

 

NEW QUESTION 47
View the Exhibit and examine the structure of the employees table.

Execute the following block of code:

What is the outcome?

• A. It gives an error because group functions cannot be used in anonymous blocks.
• B. It executes successfully and incorrectly gives the result of the sum of salaries in department 60.
• C. It gives an error because the variable name and column name are the same in the where clause of the select statement.
• D. It executes successfully and correctly gives the result of the sum of salaries in department 60.

Answer: B

Explanation:
Explanation/Reference:
Explanation:

 

NEW QUESTION 48
/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 pubiic:
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 does not execute and displays an error message because the end-of-file condition is not taken care of.
• B. It goes into an infinite loop.
• C. It executes successfully and displays the list of faculty names followed by a "no data found" error message.
• D. It executes successfully and displays only the list of faculty names.

Answer: D

 

NEW QUESTION 49
Which two statements are true about the PL/SQL initialization parameters? (Choose two.)

• A. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation- intensive procedural operations.
• B. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled.
• C. The default value of 2 for PLSQL_OPTIMIZE_LEVEL allows the compiler to rearrange code for better performance.
• D. To use native code compilation, PLSQL_OPTIMIZE_LEVEL should be set to a value less than or equal to l.

Answer: A,C

Explanation:
Explanation/Reference:
Explanation:

 

NEW QUESTION 50
User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger: CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, 'Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?

• A. SCOTT and HR
• B. Only SCOTT
• C. Only HR
• D. SCOTT, HR, and SYS

Answer: C

 

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

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

Answer: A

 

NEW QUESTION 52
......

Oracle 1Z0-144 Pre-Exam Practice Tests | VCE4Dumps: https://prep4sure.vce4dumps.com/1Z0-144-latest-dumps.html