1Z0-146 | All About Accurate 1Z0-146 examcollection
Q11. 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
Q12. Which two statements are true about the tuning of PL/SQL code? (Choose two.)
A. Redundant SQL statements in PL/SQL code should be avoided.
B. Implicit data type conversion in PL/SQL code can improve performance.
C. Usage of the NOT NULL constraint in PL/SQL code can degrade performance.
D. If you have one PL/SQL program unit instead of multiple smaller executable sections, performance can be improved.
Answer: A,C
Q13. When do you use static SQL as a technique for avoiding SQL injection?
A. when the WHERE clause values are unknown
B. when the code contains data definition language (DDL) statements
C. when all Oracle identifiers are known at the time of code compilation
D. when the SET clause values are unknown at the time of code compilation
Answer: C
Q14. Which two statements are true about cursor variables? (Choose two.)
A. A cursor variable points to the current row in the result set of a multirow query stored in a work area.
B. A cursor variable is an explicitly named work area in which the results of different multirow queries can be stored.
C. A cursor variable can be used only if a query is performed and its results are processed in the same subprogram.
D. A cursor variable can be used to perform a query in one subprogram, and process the results in a different subprogram.
Answer: A,D
Q15. You executed this command to gather information about the memory allocation for storing query results:
SQL> execute dbms_result_cache.memory_report
View the Exhibit and examine the output for the execution of the
DBMS_RESULT_CACHE.MEMORY_REPORT procedure.
Which two statements are true about the output in the Exhibit? (Choose two.)
A. In total, four blocks are used by the result cache.
B. Currently 52 KB is allocated to the result cache.
C. Currently 32 KB is allocated to the result cache.
D. The result cache can be increased by 65628 bytes.
Answer: C,D
Q16. Which statements are true about the SecureFile storage paradigm? (Choose two.)
A. SecureFile storage can be used for internal and external LOBs.
B. Automatic Segment Space Management must be enabled for a tablespace to store SecureFile LOBs.
C. SecureFile options enabled for a LOB column can be overridden on a per-LOB basis within the column.
D. SecureFile is the default storage paradigm for all LOBs that are stored in locally managed tablespaces if the DB_SECUREFILE parameter is set to ALWAYS.
Answer: B,C
Q17. There is a Java class file in your system and you publish it using the following command:
CREATE OR REPLACE PROCEDURE ccformat
(x IN OUT VARCHAR2)
AS LANGUAGE JAVA
NAME 'FormatCreditCardNo.formatCard(java.lang.String[])'
However, you receive the following error when executing the CCFORMAT procedure:
ERROR at line 1:
ORA-29540: class FormatCreditCardNo does not exist
ORA-06512: at "SH.CCFORMAT", line 1
ORA-06512: at line 1
What would you do to execute the procedure successfully?
A. Change the listener configuration.
B. Create a directory object and link it to the Java class file.
C. Rebuild the Java class file when the database instance is running.
D. Use the loadjava utility to load the Java class file into the database.
Answer: D
Q18. 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
Q19. 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
Q20. Examine the following settings for a session:
PLSQL_CODE_TYPE = NATIVE
PLSQL_OPTIMIZE_LEVEL = 3
Which statement would be true in this scenario?
A. The compiler would automatically inline subprograms.
B. The compiler would inline the code for external subroutines.
C. The compiler would inline the code even if the INLINE pragma is set to NO.
D. The compiler would not inline the code unless the INLINE pragma is set to YES.
Answer: A