1Z0-146 Exam Questions
129 real 1Z0-146 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1
Which two statements are true about the context of an application? (Choose two.)
- Question #2
View the Exhibit and examine the PL/SQL code. Which statement is true about the execution of the PL/SQL code?
- Question #3
Examine the following settings for a session: PLSQL_CODE_TYPE = NATIVE PLSQL_OPTIMIZE_LEVEL = 3 Which statement would be true in this scenario?
- Question #4
The database instance was started up with the following initialization parameter values: MEMORY_TARGET = 500M RESULT_CACHE_MODE = FORCE RESULT_CACHE_MAX_SIZE = 0 After the database...
- Question #5
Examine the structure of the PRODUCTS table. Name Null? Type --------------- ------------ --------------- PRODUCT_ID NOT NULL NUMBER(6) PRODUCT_NAME VARCHAR2(50) CATEGORY_ID NUMBER...
- Question #9
Which two statements are true about associative arrays and varrays? (Choose two.)
- Question #10
You executed the following command: SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL'; You create a new package called PACK1. View Exhibit1 to examine the PL/SQL code for...
- Question #11
You enabled PL/SQL tracing in a user session using the following command: SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ALL_CALLS); View Exhibit1 to examine the output....
- Question #12
Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection? (Choose three.)
- Question #13
Which two statements are true about nested tables and varrays? (Choose two.)
- Question #14
Which two statements are true about associative arrays and nested tables? (Choose two.)
- Question #16
Examine the following line of code that is part of a PL/SQL application: stmt:='SELECT session_id FROM sessions WHERE ' || p_where_stmt; Identify a solution for preventing SQL inje...
- Question #17
Which two conditions must be true for a PL/SQL function to be result cached? (Choose two.)
- Question #18
You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared...
- Question #19
DATA_FILES is a directory object that contains the DETAILS.TXT text file. You have the required permissions to access the directory object. You create a table using the following c...
- Question #20
Which ALTER command would you use to reinstate a disabled primary key constraint?
- Question #21
You need to perform a major update on the EMPLOYEE table. You have decided to disable the PRIMARY KEY constraint on the empid column and the CHECK constraint on the job column. Wha...
- Question #22
Which statement is valid within the executable section of a PL/SQL block?
- Question #23
Which two statements are true about cursor variables? (Choose two.)
- Question #24
Examine the PL/SQL code for the GET_TABLE_MD function given below: CREATE OR REPLACE FUNCTION get_table_md RETURN CLOB IS h NUMBER; th NUMBER; doc CLOB; BEGIN h := DBMS_METADATA.OP...
- Question #25
View the Exhibit to examine a Java source file. You have the corresponding Java class file and you execute the command as follows: SQL> CREATE OR REPLACE PROCEDURE ccformat (x IN O...
- Question #26
View the Exhibit and examine the structure of the EMPLOYEES table. Examine the following PL/SQL block for storing the salary of all sales representatives from the EMPLOYEES table i...
- Question #27
Examine the section of code taken from a PL/SQL program: PROCEDURE p1 (x PLS_INTEGER) IS ... ... PRAGMA INLINE (p1, 'NO'); x:= p1(1) + p1(2) + 17; -- Call 1 ... x:= p1(3) + p1(4) +...
- Question #28
Which statements are true about temporary LOBs? (Choose all that apply.)
- Question #29
View Exhibit1 and examine the structure of the EMPLOYEES table. View the Exhibit2 and examine the PL/SQL block that you execute for displaying the last name and hire date of the em...
- Question #30
Which two guidelines should be considered when designing and using cursors in a PL/SQL block? (Choose two.)
- Question #31
Which two statements are true about the initialization of internal LOBs? (Choose two.)
- Question #34
Examine the structure of the EMPLOYEES table that exists in your schema. Name Null? Type ---------------- ----------- -------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCH...
- Question #35
Identify the two types of PL/SQL programs for which you consider setting the compilation method to native mode. (Choose two.)
- Question #36
Identify the method that is used by fine-grained access (FGA).
- Question #37
Which statements are true about the SecureFile storage paradigm? (Choose two.)
- Question #38
You created an application context successfully. The user OE was granted the EXECUTE privilege on the DBMS_SESSION package. The user receives this error while setting the value for...
- Question #39
To examine the dependencies between all PL/SQL objects and the tables and views they reference, you executed the following query as the user OE: SQL> SELECT owner || '.' || NAME re...
- Question #40
You set RESULT_CACHE_MAX_SIZE to a nonzero value to enable result caching. You executed the following command to check the status for the result cache:, SQL> select dbms_result_cac...
- Question #41
You execute the following command in the user session: SQL> ALTER SESSION SET PLSQL_DEBUG=true; Which statement is true about the effect of the command?
- Question #42
In which two situations is the body of a result-cached function executed? (Choose two.)
- Question #44
Which two types of metadata can be retrieved by using the various procedures in the BMS_METADATA PL/SQL package? (Choose two.)
- Question #45
The database instance was recently started up. Examine the following parameter settings for the database instance: NAME TYPE VALUE ---------------------- --------- ----------- .......
- Question #46
In a user session, tracing is enabled as follows: SQL> EXECUTE. DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_LINES); PL/SQL procedure successfully completed. You executed th...
- Question #47
Which two statements are true about SecureFile LOB options? (Choose two.)
- Question #48
View the Exhibit and examine the structure of the EMPLOYEES table. Examine the following PL/SQL block: DECLARE TYPE EmpList IS VARRAY(2) OF employees.employee_id%TYPE NOT NULL; v_e...
- Question #49
View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the procedure. Which three statements are appropriate for protecting the cod...
- Question #50
Which statement describes the purpose of the plshprof command?
- Question #51
Examine the structure of the DEPARTMENTS table. Name Null? Type -------------------- ------------ ---------- DEPARTMENT_ID NOT NULL NUMBER(4) DEPARTMENT_NAME NOT NULL VARCHAR2(30)...
- Question #52
Which two statements correctly describe the features of SecureFiles? (Choose two.)
- Question #53
View the Exhibit to examine the PL/SQL code for the GET_METADATA function. Which statement is true about the metadata gathered by the function?
- Question #54
DATA_FILES is a directory object that contains the DETAILS.TXT text file. You have the required permissions to access the directory object. You create a table using the following c...
- Question #55
Which two statements are true about associative arrays and varrays? (Choose two.)
- Question #56
Examine the commands: CREATE TYPE typ_course_tab IS VARRAY(5) OF VARCHAR2(20) / CREATE TYPE typ_course_nst AS TABLE OF typ_course_tab / CREATE TABLE faculty (faculty_id NUMBER(5),...
- Question #57
Examine the structure of the EMPLOYEES table in the SCOTT schema. Name Null? Type --------------- ---------- --------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20)...