Oracle 1Z0-144 Free Practice Questions 2021

NEW QUESTION 1
Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)

• A. Reference tables indirectly by using view
• B. Reference tables directly avoid using view
• C. When adding new items to a package, add them to the end of the packag
• D. When adding new items to a package, add them to the beginning of the packag

Answer: AC

NEW QUESTION 2
Identify two situations where the DBMS_SQL package should be used. (Choose two.)

• A. The SELECT list is not known until run tim
• B. The dynamic SQL statement retrieves rows into record
• C. You do not know how many columns a select statement will return, or what their data types wil
• D. You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statemen

Answer: AC

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

View Exhibit2 and examine the code.

What is the outcome when the code is executed?

• A. Both blocks compile and execute successfully when calle
• B. Both blocks compile successfully but the CALC_SAL procedure gives an error on executio
• C. The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedur
• D. The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase functio

Answer: A

NEW QUESTION 4
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 5
Which statement is true about transactions in PL/SQL?

• A. A transaction can span multiple block
• B. A block can contain only a single transactio
• C. SERVERPOINTS cannot be created in a PL/SQL bloc
• D. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the bloc

Answer: A

NEW QUESTION 6
Which two statements are true about the handling of internally defined or user-defined PL7SQL exceptions? (Choose two.)

• A. Add exception handlers whenever errors occu
• B. An exception handler should commit the transactio
• C. Handle named exceptions whenever possible instead of using when others in exception handler
• D. Instead of adding exception handlers to your PL/SQL block, check for errors at every point where they may occu

Answer: CD

NEW QUESTION 7
View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables.
EMPLOYEES

DEPAERTMENT

EMP_BY_DEPT

Examine the following code:

What is the outcome on execution of the above code?

• A. It executes successfully but the output statements show different value
• B. It executes successfully and both output statements show the same value
• C. It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLEC
• D. It gives an error because the INSERT SELECT construct cannot be used with the FORALL

Answer: A

NEW QUESTION 8
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 statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as ‘ST_CLERK’ and salary greater than 3000.

• 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);

Answer: D

NEW QUESTION 9
Identify two features of obfuscation. (Choose two.)

• A. The Import and Export utilities accept wrapped file
• B. SQL' Plus cannot process the obfuscated source file
• C. Only the wrap utility can obfuscate multiple programs at a tim
• D. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a tim
• E. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View

Answer: AC

NEW QUESTION 10
Which three statements are true about anonymous blocks and subprograms? (Choose three.)

• A. Only subprograms can be parameterize
• B. Only subprograms are persistent database object
• C. Both anonymous blocks and subprograms can be parameterize
• D. Both anonymous blocks and subprograms are persistent database objects
• E. Only subprograms can return values that persist after the execution of the subprogra
• F. Both anonymous blocks and subprograms can return values that persist In SQL*Plus variables after their executio

Answer: BEF

NEW QUESTION 11
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 tabl
• B. The attributes of fields in the record with the %ROWTYPE attribute can be modified manuall
• C. The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variabl
• D. It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altere

Answer: CD

NEW QUESTION 12
View the Exhibit to examine the PL/SQL code.

The record for the employee with employee__id 100 in the employees table is as follows;

Identify the correct output for the code.

• A. King 17-JUN-87 1500
• B. King 17-JUN-87 24000
• C. King current sysdate 1500
• D. King current sysdate 24000

Answer: A

NEW QUESTION 13
View the Exhibit and examine the structure of the SALGRADE table.

Examine the following code:

What is the outcome?

• A. It is created successfull
• B. It gives an error because the return clause condition is invali
• C. It gives an error because the usage of the host variables is invali
• D. It gives an error because the data type of the return clause is invali

Answer: B

NEW QUESTION 14
View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green.

Examine the following sequence of commands issued by SCOTT:

What is the outcome?

• A. SCOTT’S session displays 5, and then 0, greets session displays 0.
• B. SCOTT’S session displays 5, and then 0; green's session displays 5.
• C. SCOTT’S session displays 5, and then 5 again, green's session displays 0.
• D. SCOTT’S session displays 5, and then 5 again; green's session displays 5.

Answer: B

NEW QUESTION 15
View the Exhibit and examine the structure of the AUDIR_CUST table.
Exhibit Missing
CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table.
Examine the following trigger code:

Which statement is true about the above trigger?

• A. It gives an error on compilation because it should be a statement-level trigge
• B. It compiles and fires successfully when the credit limit is updated in the customer tabl
• C. It gives an error on compilation because of the commit command in the trigger code
• D. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigge

Answer: D

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

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

View Exhibit2 and examine the code created by the user SCOTT:

SCOTT grants the necessary privileges to green to access the EMP table and execute the package.
Examine the following sequence of activities:
SCOTT starts a session and issues the SQL>EXEC CURS_PKG.OPEN command.
SCOTT then issues the SQL>EXEC CURS_PKG.NEXT command.
green starts a session while SCOTT’s session is running and issues THE SQL>EXEC
CURS_PKG.NEXT command.
SCOTT issues the SQI>>EXEC SCOTT.CURS_PKG.NEXT command.
The EMP table contains sequential EMPNOS from 100 through 108.
Which statement correctly describes the output?

• A. SCOTT’s session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT’s session shows an erro
• B. SCOTT’s session shows the EMPNO 100, GREEN'S session shows EMPNO 100, and SCOTT’s session shows the EMPNO 101.
• C. SCOTT’s session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT’s session shows the second EMPNO 101.
• D. SCOTT’s session shows the EMPNO 100, GREEN'S session shows EMPNO 101, and SCOTT’s session shows the second EMPNO 102.

Answer: C