D this statement creates a stored function named

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: d. C. This statement creates a stored function named get_sal with a status of invalid. D. This statement creates a stored function named get_sal. Actualtests.com - The Power of Knowing 1Z0-147 E. This statement fails. Answer: E Explanation: This statement will fail. Remove the STORED from CREATE OR REPLACE STORED FUNCTION Incorrect Answers A. This statement is attempting to create a Function B. If there was not a syntax error, this function would return a raise amount based on the raise amount & employee id passed to the function. C. The incorrect syntax will prevent the function from being created with a status of invalid. D. The incorrect syntax will prevent the function from being. QUESTION 61: You need to disable all triggers on the EMPLOYEES table. Which command accomplishes this? A. None of these commands; you cannot disable multiple triggers on a table in one command. B. ALTER TRIGGERS ON TABLE employees DISABLE; C. ALTER employees DISABLE ALL TRIGGERS; D. ALTER TABLE employees DISABLE ALL TRIGGERS; Answer: D Explanation: You can disable all triggers using the ALTER TABLE command. The syntax to disable or re-enable all triggers on a particular table is: ALTER TABLE <table name> DISABLE | ENABLE ALL TRIGGERS Incorrect Answers A. This is not true, you can disable all triggers on a table using the ALTER TABLE command B & C are incorrect syntax for disabling a Trigger QUESTION 62: An internal LOB is _____. A. A table. B. A column that is a primary key. Actualtests.com - The Power of Knowing 1Z0-147 C. Stored in the database. D. A file stored outside of the database, with an internal pointer to it from a database column. Answer: C Explanation: Internal LOBs are stored inside the database. To access the internal LOBs, Oracle provides the DBMS_LOB package, which uses the locator to access the LOB values. Incorrect Answers A. An Internal LOB is a Data Type not a Table B. An internal LOB is not a column that is a primary key D. External LOBs are stored outside the database. QUESTION 63: Examine this code: CREAT...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online