Exam Code: 1Z0-146 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle 11g: Advanced PL/SQL
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-146 Exam.
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
Q41. In which two situations is the body of a result-cached function executed? (Choose two.)
A. if the memory allocated for the result cache is increased
B. if a session on this database instance invokes the function with the same parameter values
C. if the first time a session on this database instance invokes the function with a parameter value
D. if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function
Q42. 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 library exists in the system. Which statement is true in this scenario?
A. The corresponding shared library is also removed from the system.
B. PL/SQL subprograms can be used to invoke the external C procedure.
C. The existing extproc process is terminated and a new extproc is started.
D. The PL/SQL subprogram that depends on the external C program becomes invalid.
Q43. Which two statements are true about BFILES? (Choose two.)
A. BFILES support only sequential reads.
B. BFILES can be used as attributes in an object type.
C. When LOB is deleted, the corresponding physical file is automatically deleted.
D. The RMAN backup automatically backs up the BFILE locators and the corresponding physical files.
E. The physical file corresponding to a BFILE locator must reside on the file system that is accessible from the server where the database exists.
Q44. 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
Q45. View the Exhibit and examine the PL/SQL code.
Which statement is true about the execution of the PL/SQL code?
A. It executes successfully and displays 101 and 200000 values.
B. The ASSIGN_VAL function generates an error during compilation because nested tables cannot be returned by functions.
C. The SELECT statement generates an error because the nested table has not been initialized in the ASSIGN_VAL function.
D. The ASSIGN_VAL function generates an error during compilation because the EXTEND method cannot be used with nested tables.
Q46. Examine the following structure: SQL> DESCRIBE user_identifiers Name Null? Type
OBJECT_NAME NOT NULL VARCHAR2(30)
Identify two scenarios in which information is stored in the USAGE column. (Choose two.)
A. an assignment made to VARIABLE
B. declaration of a variable or formal parameter
C. an identifier passed to a subprogram in IN OUT mode
D. execution of the GOTO statement or raise of an exception
Q47. Examine the structure of the DEPARTMENTS table.
Name Null? Type
DEPARTMENT_ID NOT NULL NUMBER(4)
DEPARTMENT_NAME NOT NULL VARCHAR2(30)
View the Exhibit and examine the code that you plan to use for creating a package to obtain the
details of an employee using a host variable on the client side.
In SQL*Plus, you plan to use the following commands:
SQL> VARIABLE x REFCURSOR
SQL> EXECUTE emp_data.get_emp(195,:x)
SQL> PRINT x
Which statement is true about the above scenario?
A. The package executes successfully and passes the required data to the host variable.
B. The package specification gives an error on compilation because cursor variable types cannot be defined in the specification.
C. The package specification gives an error on compilation because the cursor variable parameter was specified before you defined it.
D. The package executes successfully, but does not pass the required data to the host variable because the cursor is closed before the PRINT statement runs.
Q48. View the Exhibit and examine the PL/SQL code.
Identify the sections of the code that need to be modified for better performance gains. (Choose all that apply.)
A. Use cursors to fetch values.
B. Remove redundant SQL statements in the procedures.
C. Avoid the NOT NULL constraint when declaring the variable.
D. Define and compile procedures independently, and not as part of a package.
Q49. Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection? (Choose three.)
A. Detect a wrong user.
B. Check input string length.
C. Verify qualified SQL names. D. Validate TNS connect strings.
E. Verify an existing schema name.
F. Enclose string literals within double quotation marks.
Q50. 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 startup, to enable the result cache, you issued the following command:
SQL> ALTER SYSTEM SET result_cache_max_size = 2M SCOPE = MEMORY;
Which is the effect of this command?
A. The query result cache is enabled and 2 MB of the memory target is allocated to the result cache.
B. The query result cache is enabled and 0.25% of the memory target is allocated to the result cache.
C. The command produces an error because the database instance is started up with the RESULT_CACHE_MAX_SIZE parameter set to 0.
D. The query result cache is not enabled because the database instance is started up with the RESULT_CACHE_MAX_SIZE parameter set to 0.