It is impossible to pass Oracle 1Z0-146 exam without any help in the short term. Come to Ucertify soon and find the most advanced, correct and guaranteed Oracle 1Z0-146 practice questions. You will get a surprising result by our Rebirth Oracle 11g: Advanced PL/SQL practice guides.
2017 NEW RECOMMEND
Free VCE & PDF File for Oracle 1Z0-146 Real Exam
Pass on Your First TRY 100% Money Back Guarantee Realistic Practice Exam Questions
Q51. Which statement describes the purpose of the plshprof command?
A. It produces HTML output from raw profiler output.
B. It produces HTML output from profiler tables in the database.
C. It populates profiler tables in the database from raw profiler output.
D. It produces raw profiler output on the most recently run applications.
Q52. Identify three guidelines for the DBMS_ASSERT package. (Choose three.)
A. Prefix all calls to DBMS_ASSERT with the SYS schema name.
B. Embed DBMS_ASSERT verification routines inside the injectable string.
C. Escape single quotes when you use the ENQUOTE_LITERAL procedure.
D. Define and raise exceptions explicitly to handle DBMS_ASSERT exceptions.
E. Prefix all calls to DBMS_ASSERT with a schema name that owns the subprogram that uses the DBMS_ASSERT package.
Q53. Which two statements are true about nested tables and varrays? (Choose two.)
A. Only varrays must have consecutive numbers as subscripts.
B. Only nested tables can be used as column types in database tables.
C. Both nested tables and varrays must have consecutive numbers as subscripts.
D. Both nested tables and varrays can be used as column types in database tables.
Q54. Examine the following line of code that is part of a PL/S QL application: stmt:='SELECT session_id FROM sessions WHERE ' || p_where_stmt; Identify a solution for preventing SQL injection in the above code.
A. Replace P_WHERE_STMT with a bind variable.
B. Do not use APIs that allow arbitrary query parameters to be exposed.
C. Use the RESTRICT_REFERENCES clause in the PL/SQL subprogram that contains the code.
D. Use DBMS_SQL to detect that the expression provided for P_WHERE_STMT is free from SQL injection.
Q55. 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
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.
Q56. 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.
Q57. You created a procedure as follows:
CREATE OR REPLACE PROCEDURE query_prod(twhr VARCHAR2)
stmt:='SELECT product_name FROM products WHERE product_id=:2';
EXECUTE IMMEDIATE stmt INTO pname USING twhr;
View the Exhibit to examine the structure of PRODUCTS table.
Which statement is true about the procedure?
A. It produces an error when invoked.
B. It can be invoked only from a PL/SQL block.
C. It reduces the chances of SQL injection by using bind arguments.
D. The values for bind arguments remain persistent in the session after the execution of the procedure.
Q58. Which two statements are true about associative arrays and varrays? (Choose two.)
A. Only varrays must start with the subscript 1.
B. Only varrays can be used as column types in database tables.
C. Both associative arrays and varrays must start with the subscript 1.
D. Both associative arrays and varrays can be used as column types in database tables.
Q59. The following command is executed to start tracing in a user session: SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_EXCEPTIONS); Which statement is true about the effect of the command?
A. It allows tracing of exceptions raised by all subprograms executed in the session.
B. It allows tracing of user-defined exceptions raised by all subprograms executed in the session.
C. It allows tracing of system-defined exceptions raised by all subprograms executed in the session.
D. It allows tracing of exceptions raised by subprograms compiled with the DEBUG option and executed in the session.
Q60. 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.