Online Access Free 1Z1-144 Exam Questions

Which two statements are true about the instead of triggers? (Choose two.)

• A.The instead of triggers can be written only for views, and the before and after timing options are not valid.
• B.Delete operations cannot be performed using the instead of triggers.
• C.The instead or triggers must be created to add or modify data through any view.
• D.The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of trigger.

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 executes successfully and creates the report.
• B.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.
• C.It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.
• D.It gives an error because the "no data found" condition is not handled to come out of the loop.
• E.It gives an error because the text file should be opened in append mode.

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

Examine the following block of code:

What is the outcome when the above code is executed?

• A.It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block.
• B.It gives an error because decode cannot be used in a PL/SQL block.
• C.It executes successfully.
• D.It gives an error because the AVG function cannot be used in a PL/SQL block
• E.It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.

In which of the following scenarios would you recommend using PL/SQL records?

• A.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
• B.when you know the number of elements in advance and the elements are usually accessed sequentially
• C.when you want to retrieve an entire row from a table and perform calculations
• 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

ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code:

Which statement is correct about the above code?

• A.It gives an error in line 6
• B.It gives an error in line 4
• C.It executes successfully and displays the output.
• D.It gives an error in line 3