Home 
Do you have any collection of Interview Questions and interested to share with us!!
Please send that collection to iq@GlobalGuideline.Com along with the category and sub category information
Please send that collection to iq@GlobalGuideline.Com along with the category and sub category information
1 :: When using Oracle export/import what character set concerns might come up? How do you handle them?
Be sure to set NLS_LANG for example to "AMERCIAN_AMERICA.WE8ISO8859P1". If your source database is US7ASCII, beware of 8-bit characters. Also be wary of multi-byte characters sets as those may require extra attention. Also watch export/import for messages about any "character set conversions" which may occur.2 :: How do you use automatic PGA memory management with Oracle 9i and above?
Set the WORKAREA_SIZE_POLICY parameter to AUTO and set PGA_AGGREGATE_TARGET3 :: Explain two easy SQL optimizations.
a. EXISTS can be better than IN under various conditionsb. UNION ALL is faster than UNION (not sorting)
4 :: Name three SQL operations that perform a SORT.
a. CREATE INDEXb. DISTINCT
c. GROUP BY
d. ORDER BY
f. INTERSECT
g. MINUS
h. UNION
i. UNINDEXED TABLE JOIN
5 :: What is your favorite tool for day-to-day Oracle operation?
Hopefully we hear some use of command line as the answer!
Webmaster Said:
Thank you.