Oracle database 11g:advanced pl/sql - 1Z0-146 Exam Practice Test
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?
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?
Correct Answer: E
Vote an answer
Which two statements are true about associative arrays and varrays? (Choose two.)
Correct Answer: A,B
Vote an answer
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?
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?
Correct Answer: D
Vote an answer
View the Exhibit.
How do you reduce the chances of SQL injection for the procedure?
How do you reduce the chances of SQL injection for the procedure?
Correct Answer: C
Vote an answer
Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB package? (Choose two.)
Correct Answer: A,B
Vote an answer
Which two statements are true about nested tables and varrays? (Choose two.)
Correct Answer: A,C
Vote an answer
Identify three guidelines for the DBMS_ASSERT package. (Choose three.)
Correct Answer: A,D,E
Vote an answer
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.)
Identify the sections of the code that need to be modified for better performance gains. (Choose all that apply.)
Correct Answer: B,D
Vote an answer