最新的Oracle 1Z0-146免費考試真題

問題1

You set RESULT_CACHE_MAX_SIZE to a nonzero value to enable result caching. You executed
the following command to check the status for the result cache:,
SQL> select dbms_result_cache.status() from dual;
You receive the following output:
DBMS_RESULT_CACHE.STATUS()
DISABLED
Identify the reason for the output.

A. The database instance was started with the RESULT_CACHE_MAX_SIZE parameter set to 0.

B. The database instance is not able to allocate memory for the result cache.

C. The RESULT_CACHE_MODE parameter is set to MANUAL.

D. The RESULT_CACHE_MODE parameter is set to FORCE.

正確答案: A

問題2

Examine the PL/SQL code for the GET_TABLE_MD function given below:
CREATE OR REPLACE FUNCTION get_table_md RETURN CLOB IS
h NUMBER;
th NUMBER;
doc CLOB;
BEGIN
h := DBMS_METADATA.OPEN('TABLE');
DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR');
DBMS_METADATA.SET_FILTER(h,'NAME','TIMECARDS');
th := DBMS_METADATA.ADD_TRANSFORM(h,'DDL');
doc := DBMS_METADATA.FETCH_CLOB(h);
DBMS_METADATA.CLOSE(h);
RETURN doc;
END;
Which statement is true about the compilation and execution of the function?

A. The execution of the function produces an error because multiple objects are fetched and DBMS_METADATA.FETCH_CLOB is not called in a LOOP.

B. The compilation produces an error because DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR')is not placed in the correct order.

C. The function retrieves the metadata as a data definition language (DDL) statement for creating the TIMECARDS table in the HR schema.

D. The function retrieves the metadata in Extensible Markup Language (XML) format for creating the TIMECARDS table in the HR schema.

正確答案: C

問題3

When do you use static SQL as a technique for avoiding SQL injection?

A. when the SET clause values are unknown at the time of code compilation

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 WHERE clause values are unknown

正確答案: C

問題4

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.

正確答案: C,D

問題5

Which two statements correctly describe the features of SecureFiles? (Choose two.)

A. Compression does not entail table or index compression and vice-versa.

B. Encryption stores the encryption keys for the LOB columns inside the database.

C. Compression stores identical data occurring two or more times in the same LOB column as a single copy for the table.

D. Encryption stores the encryption keys for the LOB columns outside the database.

正確答案: A,D

問題6

To examine the dependencies between all PL/SQL objects and the tables and views they
reference, you executed the following query as the user OE:
SQL> SELECT owner || '.' || NAME refs_table
, referenced_owner || '.' || referenced_name AS table_referenced
FROM all_dependencies
WHERE owner = USER
AND TYPE IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION')
AND referenced_type IN ('TABLE', 'VIEW')
AND referenced_owner NOT IN ('SYS', 'SYSTEM')
ORDER BY owner, NAME, referenced_owner, referenced_name;
Which statement is true about the output of the query?

A. It displays only those PL/SQL code objects created by the user OE that reference a table or view created by the user SYS.

B. It displays all PL/SQL code objects that reference a table or view directly for all the users in the database.

C. It displays all PL/SQL code objects created by user OE that reference any table or view owned by other users except SYS and SYSTEM..

D. It displays no rows because this query needs to be executed as the user SYS for required results.

正確答案: C

問題7

Identify three guidelines for the DBMS_ASSERT package. (Choose three.)

A. Prefix all calls to DBMS_ASSERT with the SYS schema name.

B. Define and raise exceptions explicitly to handle DBMS_ASSERT exceptions.

C. Prefix all calls to DBMS_ASSERT with a schema name that owns the subprogram that uses the DBMS_ASSERT package.

D. Embed DBMS_ASSERT verification routines inside the injectable string.

E. Escape single quotes when you use the ENQUOTE_LITERAL procedure.

正確答案: A,B,E

問題8

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. It generates an error because DEFAULT cannot be set to EMPTY_BLOB() during table creation.

B. It generates an error because DEFAULT cannot be set to null for a BFILE column during table creation.

C. The table is created successfully.

D. It generates an error because DEFAULT cannot be set to null for a CLOB column during table creation.

正確答案: C

問題9

Examine the structure of the TEXT_TAB table. Name Null? Type
TEXT_ID NUMBER
DOC1 CLOB
DOC2 CLOB
You issue the following INSERT commands:
INSERT INTO text_tab VALUES (1, 'This is line 1',null);
INSERT INTO text_tab VALUES (2, 'This is line 1','This is line 2');
Then you execute the following block of the PL/SQL code:
DECLARE
vc1 VARCHAR2(1000):= 'This is the preface';
lb1 CLOB;
lb2 CLOB;
BEGIN
SELECT doc1 INTO lb1 FROM text_tab WHERE text_id=1;
SELECT doc1 || doc2 INTO lb1 FROM text_tab WHERE text_id=2;
lb2 := vc1|| lb1;
UPDATE text_tab SET doc2 = lb2 WHERE text_id = 1;
END;
/
What is the outcome?

A. It executes successfully.

B. It gives an error because VARCHAR2 should be explicitly converted to CLOB.

C. It gives an error because CLOB variables should be initialized to EMPTY_CLOB().

D. It gives an error because the concatenation operator cannot be used with the CLOB data type.

正確答案: A

最新的Oracle database 11g:advanced pl/sql - 1Z0-146免費考試真題

聯系我們

站內鏈接

最新更新