READ Free Dumps For Oracle- 1z0-007

Question ID 8005	Which two tasks can you perform using only the TO_CHAR function? (Choose two.)
Option A	convert 10 to 'TEN'
Option B	convert '10' to 10
Option C	convert 10 to '10'
Option D	convert 'TEN' to 10
Option E	convert a date to a character expression
Option F	convert a character expression to a date
Correct Answer	CE

Explanation Explanation/Reference: Explanation : converting data type into characters. Incorrect answer : A does not serve TO_CHAR function B does not serve TO_CHAR function D does not serve TO_CHAR function F does not serve TO_CHAR function Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 3-31

Question ID 8006	The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?
Option A	no privileges
Option B	only the SELECT privilege
Option C	only the CONNECT privilege
Option D	all the privileges of a default user
Correct Answer	A

Explanation Explanation/Reference: Explanation : when a user is created, by default no privilege is granted Incorrect answer : B SELECT is not grant C CONNECT is not grant D default profile is grant by default not privilege. Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 13-6

Previous-Page 1 2. . . 130 131 132 133 134 135 136. . . 160 161 Next-Page

Send email to admin@getfreedumps for new dumps request!!!