You must remove both the package body and the

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: dy first B. Removing a package specification removes the body too C. Removing the package body removes the specification too D. You must remove both the package body and the specification separately E. Removing a package specification removes all stand alone stored functions named in the specification Answer: B Explanation: Answer D is incorrect To remove the package specification and the package body you use the command: DROP PACKAGE <Package_Name> To remove the package body from the database, you use the following Actualtests.com - The Power of Knowing 1Z0-147 command: DROP PACKAGE BODY <Package_Name> Answer B is the correct response - Removing a package specification removes the body too. QUESTION 110: Which two statements are true about LOBs? (Choose two.) A. BFILES are stored in the database B. All LOBs have read and write access C. NCLOB represents a multi-byte character object D. The Oracle9i server performs implicit conversions between BLOBs and NUMBER data types E. The Oracle9i server performs implicit conversions between CLOBs and VARCHAR2 data types Answer: C, E Explanation: A. The BFILE data type is an external LOB. External LOBs are stored outside the database in operating system files. B. BFILEs are read-only, and they cannot participate in transactions that occur within the database. D. You can perform Implicit conversions between LONG and CLOB columns and RAW and BLOB columns but you can't implicitly convert between BLOBS and NUMBER. QUESTION 111: You want to create procedures, functions and packages Which privilege do you need? A. EXECUTE CODE object privilege B. CREATE ANY CODE object privilege C. CREATE PACKAGE system privilege D. CREATE PROCEDURE system privilege E. CREATE FUNCTION, CREATE PROCEDURE, CREATE PACKAGE system privileges Answer: D Explanation: The privilege CREATE PROCEDURE gives the grantee the right to create procedures, Actualtests.com - The Power of Knowing 1Z0-147 functions, and packages within their schema. This privilege does not give the right to drop or alter the program constructs. Incorrect Answers A, B & C are not valid object or system privileges. Actualtests.com - The Power of Knowing...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online