Oracle 1Z0-144 Exam Dumps 2021

NEW QUESTION 1
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 inde
• B. They can be defined by all users in the database or only by a specific use
• C. They are fired only when the owner of the object Issues the DDL statemen
• D. They can be used to track changes to a table, table space, view, or synony

Answer: D

NEW QUESTION 2
Examine the following PL/SQL code:

Which statement is true about the fetch statements in the PL/SQL code?

• A. Each fetch retrieves the first row and assigns values to the target variable
• B. Each fetch retrieves the next consecutive row and assigns values to the target variable
• C. They produce an error because you must close and reopen the cursor before each fetch -statemen
• D. Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an erro

Answer: B

NEW QUESTION 3
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 x =
• B. It produces an erro
• C. The output Is x !=
• D. The output Is Can't tell if x and y are equal or no

Answer: A

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

Answer: B

NEW QUESTION 5
Which type of exceptions is qualified as no predefined Oracle server errors?

• A. the exceptions that are explicitly raised by the program and can be caught by the exception handler
• B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler
• C. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly
• D. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit

Answer: C

NEW QUESTION 6
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 itsel
• B. 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 tim
• C. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performanc
• 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 Jav

Answer: BD

NEW QUESTION 7
Which two statements are correct about PL/SQL package components? (Choose two)

• A. A package must have both specification and bod
• B. A package body can exist without the package specificatio
• C. A package specification can exist without the package bod
• D. When a packaged public variable is called for the first time in a session, the entire package is loaded into memor

Answer: CD

NEW QUESTION 8
You want to store values of different data types in a PL/SQL block and store one record at a time for processing the information.
Which type of composite data type would you choose to fulfill the requirement?

• A. VARRAYS
• B. Nested table
• C. PL/SQL records
• D. Associative arrays

Answer: C

NEW QUESTION 9
Examine the following code:

What is the outcome?

• A. The procedure is created successfully and displays the values 20 and 30 when it is calle
• B. The procedure gives errors because the parameters should be in out mod
• C. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedur
• D. The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedur

Answer: C

NEW QUESTION 10
You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded.
The procedure should return an "error" condition to the caller in a manner consistent with other Oracle server errors.
Which construct should be used to handle this requirement?

• A. The SQLERRM function
• B. The PRAGMA EXCEPTION_INIT function
• C. The RAISE_APPLICATION_ERROR procedure
• D. A user-defined exception used with a raise statement

Answer: B

Explanation:
Reference: http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/exceptioninit_pragma.htm#LNPL S01315

NEW QUESTION 11
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

Answer: AD

Explanation:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064

NEW QUESTION 12
Which statements are true about database triggers? (Choose all that apply.)

• A. They can invoke only PL/SQL procedures
• B. They can include SQL and PL/SQL or calls to Java procedure
• C. They are implicitly fired by an event that must occur within an application
• D. They are implicitly fired when a triggering event occurs, depending on which user is connected

Answer: AD

Explanation: Reference: http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch15.htm

NEW QUESTION 13
Examine the following code:

Which two statements are true about the above function? (Choose two.)

• A. It can be used only in a parallelized quer
• B. It can be used in both a parallelized query and a parallelized DML statemen
• C. It can be used only in a parallelized data manipulation language (DML) statemen
• D. It can have a separate copy run in each of the multiple processes when called from a SQL statement that is run in paralle
• E. It requires a PRAGMA RESTRICT_REFERENCES declaration with RNDS, WNDS, RNPS, and WNPS specified in order to use parallel optimizatio

Answer: BE

NEW QUESTION 14
You want to maintain an audit of the date and time when each user of the database logs off.
Examine the following code:

Which two clauses should be used to fill in the blanks and complete the above code? (Choose two.)

• A. ON SCHEMA
• B. ON QRXABASE
• C. AFTER LOGOFF
• D. BEFORE LOGOFF

Answer: AD

NEW QUESTION 15
Examine the following PL/SQL code;

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

• A. The open cursor is missing
• B. The fetch clause 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 statemen

Answer: B

NEW QUESTION 16
Which two statements are true about triggers? (Choose two.)

• A. All the triggers that are created on a table cannot be disabled simultaneousl
• B. Any user who has the alter privilege on a table can create a trigger using that tabl
• C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed databas
• D. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocatio

Answer: CD

NEW QUESTION 17
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 can be either stand-alone or package
• B. The procedures should be created only as packaged subprograms
• C. The procedures should be created only as stand-alone subprograms
• D. Each subprogram's formal parameters should differ in both name and data typ
• E. The formal parameters of each subprogram should differ in data type but can use the same name

Answer: BE