Act now and download your Oracle 1Z0-146 test today! Do not waste time for the worthless Oracle 1Z0-146 tutorials. Download Renovate Oracle Oracle 11g: Advanced PL/SQL exam with real questions and answers and begin to learn Oracle 1Z0-146 with a classic professional.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-146 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-146 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-146-exam-dumps.html
Q61. Identify the two types of PL/SQL programs for which you consider setting the compilation method to native mode. (Choose two.)
A. PL/SQL programs that are still in the debugging phase of development
B. PL/SQL programs that have computation-intensive procedural operations
C. A PL/SQL program, which is called with the same parameters by multiple sessions
D. PL/SQL programs that spend most of their execution time in executing SQL statements
Answer: B,C
Q62. You executed the following command to alter the session parameter:
SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL'
Which two statements are true in this scenario? (Choose two.)
A. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope does not collect data for the compiled object.
B. All the identifiers declared in compiled program units before altering the parameter settings appear in the *_IDENTIFIER static data dictionary views.
C. All the identifiers declared in compiled program units before altering the parameter settings do not appear in the *_IDENTIFIER static data dictionary views.
D. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope collects data for the compiled object and stores it in the SYSTEM tablespace.
Answer: A,C
Q63. Examine the structure of the TEST_DETAILS table: Name Null? Type
TEST_ID NUMBER DESCRIPTION CLOB DESCRIPTION data was entered earlier and saved for TEST_ID 12.
You execute this PL/SQL block to add data to the end of the existing data in the DESCRIPTION column for TEST_ID 12:
DECLARE
clob_loc CLOB;
buf CHAR(12);
BEGIN
SELECT description INTO clob_loc FROM test_details WHERE test_id = 12 ;
buf := '0123456789'
DBMS_LOB.WRITEAPPEND(clob_loc,DBMS_LOB.GETLENGTH(buf), buf);
COMMIT;
END;
/
It generates an error on execution.
What correction should you do to achieve the required result?
A. WRITEAPPEND must be replaced with APPEND.
B. The BUF variable data type must be changed to CLOB. C. FOR UPDATE must be added to the SELECT statement.
D. The GETLENGTH routine must be replaced with the LENGTH built-in function in WRITEAPPEND.
Answer: C
Q64. Which statements are true about internal LOBs? (Choose all that apply.)
A. They cannot use redo logging.
B. They can be used as attributes of a user-defined data type.
C. They cannot be passed as parameters to PL/SQL subprograms.
D. They can be stored in a tablespace that is different from the tablespace that stores the table containing the LOB column.
Answer: B,D
Q65. You issue this command to create a table called LOB_STORE:
CREATE TABLE lob_store
(lob_id NUMBER(3),
photo BLOB DEFAULT EMPTY_BLOB(),
cv CLOB DEFAULT NULL,
ext_file BFILE DEFAULT NULL)
/
What is the outcome?
A. The table is created successfully.
B. It generates an error because DEFAULT cannot be set to EMPTY_BLOB() during table creation.
C. It generates an error because DEFAULT cannot be set to null for a CLOB column during table creation.
D. It generates an error because DEFAULT cannot be set to null for a BFILE column during table creation.
Answer: A
Q66. Examine the structure of the PRODUCTS table. Name Null? Type
PRODUCT_ID NOT NULL NUMBER(6)
PRODUCT_NAME VARCHAR2(50)
CATEGORY_ID NUMBER(2)
SUPPLIER_ID NUMBER(6)
LIST_PRICE NUMBER(8,2)
View the Exhibit and examine the PL/SQL block.
On execution, the PL/SQL block generates the following error:
ORA-01001: invalid cursor
What could be the reason?
A. Both the cursor variable arguments should have been passed in IN mode.
B. The contents of one cursor variable cannot be assigned to another cursor variable using the := operator.
C. The CLOSE statement closes both the cursor variables, therefore the last FETCH statement cannot execute.
D. The name of the cursor variables defined and the name of the cursor variables passed as arguments must be the same.
Answer: C
Q67. You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the ORDERS table in the OE schema. The user sessions are able to access only the desired rows. The database administrator (DBA) uses the following command:
SQL> EXECUTE
DBMS_RLS.ENABLE_POLICY('OE','ORDERS','OE_ORDERS_ACCESS_POLICY',FALSE);
Which statement is true about user sessions that are connected currently?
A. The security policy remains in effect till the end of the current session.
B. The subsequent queries on the ORDERS table produce an ORA-01031: insufficient privileges error.
C. The subsequent queries on the ORDERS table within the current session are not controlled by the security policy.
D. The subsequent queries on the ORDERS table produce an ORA-28112: failed to execute policy function error.
Answer: C
Q68. Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.)
A. It can be performed only on tables with a single LOB column.
B. It automatically creates an interim table during the migration process.
C. It allows the table that is migrated to be accessed throughout the migration process.
D. It requires free space that is at least equal to the space used by the table that is migrated.
E. It requires all constraints defined on the original table to be re-created manually after the migration.
Answer: C,D
Q69. Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)
A. You can describe remote objects.
B. You can describe anonymous PL/SQL blocks.
C. You can describe a stored procedure, stored function, packaged procedure, or packaged function.
D. You can obtain information about the position, name, and data type of the arguments of a procedure.
Answer: C,D
Q70. 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 an attribute within the context: SQL> EXECUTE DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); BEGIN DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); END; * ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SESSION", line 94
ORA-06512: at line 1
What is the reason for this error?
A. The context was created with a package name in the USING clause.
B. The attribute can be set only in the package associated with the context.
C. The package associated with the context did not exist at the time of creation of the context.
D. The value for an attribute of a user-defined context can be set only by the ALTER SESSION command.
Answer: B