Online Access Free Oracle.1Z0-144.v2022-11-03.q94 Practice Test (Page 15)

1Z0-144 Exam Question 66

Examine the following snippet of code from the DECLARE section of PL/SQL
DECLARE
Cust_name VERCHAR2 (20) NOT NULL : = 'Tom Jones':
Same_name cust_name%TYPE:
Which statement is correct about the above snippets of code?

A.The SAME_NAME variable inherits only the data type from the CUST_NAME variable.

B.The SAME_NAME variable inherits the data type, constraint, and default value from the CUST_NAME variable.

C.The SAME_NAME variable inherits only the data type and default value from the CUST_NAME variable.

D.The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME variable resulting in an error

1Z0-144 Exam Question 67

Which two tasks should be created as functions instead of as procedures? (Choose two.)

A.tasks that compute a value that must be returned to the calling environment

B.reference host or bind variables in a PL7SQL block of code

C.tasks that compute and return multiple values to the calling environment

D.tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application

1Z0-144 Exam Question 68

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

1Z0-144 Exam Question 69

Which two statements are true about PL/SQL exception propagation? (Choose two.)

A.Exception- can propagate across the remote subprograms that are called through database links.

B.The exception reproduces Itself In successive enclosing blocks until a handler is found.

C.If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception.

D.If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception.

1Z0-144 Exam Question 70

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

A.Delete operations cannot be performed using the instead of triggers.

B.The instead or triggers must be created to add or modify data through any view.

C.The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of trigger.

D.The instead of triggers can be written only for views, and the before and after timing options are not valid.

Latest Upload: 170ACSM.020-222.v2025-09-11.q48; 157VMware.5V0-31.23.v2025-09-10.q73; 131Oracle.1z0-915-1.v2025-09-10.q24; 160Citrix.1Y0-231.v2025-09-10.q87; 135SAP.C-THR85-2505.v2025-09-09.q29; 166Adobe.AD0-E727.v2025-09-09.q76; 130Oracle.1Z0-1123-25.v2025-09-09.q20; 136SAP.C_SIGPM_2403.v2025-09-08.q20; 259EXIN.ITIL.v2025-09-08.q161; 172BCS.PC-BA-FBA-20.v2025-09-08.q45

1Z0-144 Exam Question 66

1Z0-144 Exam Question 67

1Z0-144 Exam Question 68

1Z0-144 Exam Question 69

1Z0-144 Exam Question 70

Download PDF File