1Z0-146 Exam
What Renew 1Z0-146 Is?
Cause all that matters here is passing the Oracle 1Z0-146 exam. Cause all that you need is a high score of 1Z0-146 Oracle 11g: Advanced PL/SQL exam. The only one thing you need to do is downloading Testking 1Z0-146 exam study guides now. We will not let you down with our money-back guarantee.
Q11. Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)
A. Only local subroutines can be inlined.
B. Inlining always reduces the execution time for a PL/SQL program unit.
C. PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2.
D. The PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining.
Answer: A,C
Q12. 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?
A. The end result is the creation of DDL for the TIMECARDS table with all instances of the HR schema changed to SCOTT.
B. The end result is the creation of an XML document for all tables with all physical, storage, logging, and other segment attributes.
C. The end result is the creation of DDL for all tables with all instances of the HR schema changed to SCOTT along with all physical, storage, logging, and other segment attributes.
D. The end result is the creation of DDL for all tables and associated indexes with all instances of the HR schema changed to SCOTT along with all physical, storage, logging, and other segment attributes.
Answer: A
Q13. 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 the
PACK1 package specification and body.
You issue the following query to see all unique identifiers with a name, such as %1:
SQL> SELECT NAME, SIGNATURE, TYPE
FROM USER_IDENTIFIERS
WHERE NAME LIKE '%1' AND USAGE='DECLARATION'
ORDER BY OBJECT_TYPE, USAGE_ID;
View Exhibit2 to examine the output of the query. Which two statements are true about the output of the query? (Choose two.)
A. The SIGNATURE column has a unique value for an identifier except for identifiers with the same name.
B. The TYPE column has the value of packages, function or procedures, object types, PL/SQL types, triggers, or exceptions.
C. The query shows the output for only those identifiers for PL/SQL objects, which are created by the user and are compiled after the ALTER SESSION command.
D. The ALTER SESSION command automatically collects identifier data and the query shows the output for all the identifiers for PL/SQL objects, which are created by the user.
Answer: B,C
Q14. Examine the structure of the EMPLOYEES table in the SCOTT schema. Name Null? Type
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
SALARY NOT NULL NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
DEPARTMENT_ID NUMBER(4)
View the Exhibit and examine the code for the EMP_TOTSAL procedure created by user SCOTT.
Which statement is true regarding the EMP_TOTSAL procedure?
A. It is created successfully, but displays the correct output message only for existent employee IDs.
B. It is created successfully and displays the correct output message for both existent and nonexistent employee IDs.
C. It generates an error because the %NOTFOUND attribute cannot be used in combination with a SELECT INTO statement.
D. It generates an error because a user-defined exception has to be included whenever the %NOTFOUND attribute is used in combination with a SELECT INTO statement.
Answer: A
Q15. Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is used to create a temporary LOB? (Choose two.)
A. It can be used for transforming data in permanent internal LOBs.
B. It is used only for the migration of BasicFile to the SecureFile format.
C. It is used only for the migration of the LONG column to the LOB column.
D. It creates a LOB variable that is not associated with any table and is stored in the user's temporary tablespace.
E. It creates a LOB variable that is associated with a specific table and is temporarily stored in the user's default tablespace.
Answer: A,D
Q16. Which two statements are true about the working of fine-grained access? (Choose two.)
A. Security policies can be associated only with tables, but not with views.
B. Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements.
C. User statements are dynamically modified by the Oracle server through a security policy function.
D. Fine-grained access control policies always remain in effect until they are dropped from a table or view.
Answer: B,C
Q17. Which two queries' results cannot be cached? (Choose two.)
A. queries having the GROUP BY clause
B. queries having the ORDER BY clause
C. the query on dictionary and temporary tables
D. queries having SYSDATE and SYS_TIMESTAMP SQL functions
Answer: C,D
Q18. You issue the following command to create the PRINT_MEDIA table.
CREATE TABLE print_media
(product_id NUMBER(3),
ad_sourcetext CLOB,
ad_photo BLOB);
Evaluate the following INSERT statements:
INSERT INTO print_media VALUES (1, empty_clob(),empty_blob());
INSERT INTO print_media VALUES (2,'This is a One Line Story',null);
INSERT INTO print_media VALUES (3,'This is another One Line Story',empty_blob());
INSERT INTO print_media VALUES (4,empty_clob(),to_blob('This is new Story'));
Which of the above INSERT statements are valid?
A. Only the first statement is valid.
B. All the statements are valid.
C. Only the first and fourth statements are valid.
D. Only the first and second statements are valid.
E. Only the first, second and third statements are valid.
Answer: E
Q19. Which statements are true about temporary LOBs? (Choose all that apply.)
A. They can be created only for CLOB and NCLOB data.
B. They can be accessed only by the user who creates them.
C. They generate more redo information than persistent LOBs.
D. They exist for the duration of the session in which they are created.
E. They are stored temporarily in the default tablespace of the user who creates them.
Answer: B,D
Q20. The PLSQL_OPTIMIZE_LEVEL parameter is set to 2 for the session.
Examine the section of code given:
FUNCTION p2 (p boolean) return PLS_INTEGER IS ...
FUNCTION p2 (x PLS_INTEGER) return PLS_INTEGER IS
PRAGMA INLINE(p2, 'YES');
x := p2(true) + p2(3);
Which statement is true about the INLINE pragma procedure calls?
A. Only the call to the P2 function with BOOLEAN as the argument is inlined.
B. INLINE pragma affects both the functions named P2 and is called inline.
C. Only the call to the P2 function with PLS_INTEGER as the argument is inlined.
D. None of the functions are inlined because inlining is not supported for overloaded functions.
Answer: B