Oracle Database: Advanced PL/SQL - 1z1-148 Exam Practice Test

A. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2AUTHID
DEFINERISdate_hired DATE;

B. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2RESULT_CACHE RELIES_ON (departments)AUTHID CURRENT_USERISdate_hired DATE;

C. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2RESULT_CACHE RELIES_ON (employees)AUTHID CURRENT_USERISdate_hired DATE;

D. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN
VARCHAR2RESULT_CACHEAUTHID CURRENT_USERISdate_hired DATE;

E. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN
VARCHAR2RESULT_CACHEAUTHID DEFINERISdate_hired DATE;

A. Use the TRUNCATE method on the collection.

B. Flush the shared pool using the ALTER SYSTEM command.

C. Execute DBMS_SESSION.FREE_UNUSED_USER_MEMORY.

D. Execute DBMS_SHARED_POOL.UNKEEP.

A. ALL_OBJECTS

B. ALL_SOURCE

C. ALL_PROCEDURES

D. ALL_DEPENDENCIES

E. ALL_PLSQL_OBJECT_SETTINGS

A. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@my_dblink') FROM dual;

B. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('"10_Employees"') FROM dual;

C. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME (' Emp_Dept_information_table ') FROM dual;

D. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employee_Department_information_table') FROM dual;

E. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@') FROM dual;

A. It will give an error because PDT_REC is not declared.

B. It will display the price increase by 1% only for all the products.

C. It will display the price increase by 1% only for the first product.

D. It will go into an endless loop because the loop exist condition is missing.

E. It will give an error because the calculated column in the cursor is not using a column alias in this block.

A. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a " "test" " message', TRUE));END;

B. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message ', FALSE));END;

C. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a test message"
', TRUE));END;

D. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message', TRUE));END;

E. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a "test" message" ', TRUE));END;

A. The query will only fetch records pertaining to department 30 with SAL and COMM values displayed as NULL.

B. The query will fetch records from all departments with SAL and COMM values displayed as NULL for all records other than department 30.

C. The query will only fetch records pertaining to department 30 with SAL and COMM displaying the actual data from the table.

D. The query will only fetch records pertaining to department 30 with SAL and COMM data replaced by
"xxxxx".

A. Modify the function return type to return a scalar, VARCHAR2.

B. Change RETURN p_tab.LAST to RETURN p_tab.COUNT.

C. Declare the collection type inside the function.

D. Change the INDEX BY clause from VARCHAR2 to PLS_INTEGER.

E. Declare the collection type at the schema level instead of the package.

F. Define the function as stand-alone instead of in a package body.