Incorrect answers a c are not valid dictionary views

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: dependencies within your schema. Incorrect Answers: A & C are not valid dictionary views D. USER_SOURCE: Provides the name and the source code for all procedures created by Actualtests.com - The Power of Knowing 1Z0-147 the owner. The source code appears in the TEXT column, and the name of the procedure appears in the NAME column. QUESTION 34: A CALL statement inside the trigger body enables you to call ______. A. A package. B. A stored function. C. A stored procedure. D. Another database trigger. Answer: C Explanation: Incorrect Answers: A. Package can't be called, we call a procedure inside the package. B. We can't call a function use CALL statement because function must return a value. D. Trigger can't be called, they are execute automatically when the trigger event occure. QUESTION 35: You need to remove the database triggerBUSINESS_HOUR. Which command do you use to remove the trigger in the SQL *Plus environment? A. DROP TRIGGER business_hour; B. DELETE TRIGGER business_hour; C. REMOVE TRIGGER business_hour; D. ALTER TRIGGER business_hour REMOVE; E. DELETE FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'BUSINESS_HOUR'; Answer: A Explanation: To permanently remove a trigger from a database, you can use the DROP TRIGGER statement. The syntax of this statement is: DROP TRIGGER ; B, C & D. Are invalid and will return an error E. This statement would attempt to delete a record from the USER_Triggers View Actualtests.com - The Power of Knowing 1Z0-147 QUESTION 36: How can you migrate from a LONG to a LOB data type for a column? A. Use the DBMS_MANAGE_LOB.MIGRATE procedure. B. Use the UTL_MANAGE_LOB.MIGRATE procedure. C. Use the DBMS_LOB.MIGRATE procedure. D. Use the ALTER TABLE command. E. You cannot migrate from a LONG to a LOB date type for a column. Answer: D Explanation: In Oracle9i, a LONG column in a table can be migrated to a LOB column using the ALTER TABLE statement. The syntax is: ALTER TABLE <schema>.<table name> MODIFY <long column name> {CLOB | BLOB |NCLOB} Incorrect Answers: A & B These are...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online