| Please give me answers to these interview questions [message #274532] |
Tue, 16 October 2007 05:47  |
nagasandeep
Messages: 1
Registered: October 2007
Location: hyderabad
|
Junior Member |
|
|
hi,
i have the interview, so please send the answers to this qustions
1) how to find out the database name from SQL*PLUS command prompt?
2) Tradeoffs with having indexes?
3)"exception handling" in PL/SQL?
4)what is the difference between "NULL in c" and "NULL in oracle"?
5)what is pro*C?what is OCI?
6)Give some examples of analytical functions?
7) Difference between "Translate" and "replace"?
 What is DYNAMIC SQL method 4?
9)How to remove duplicate records from tables?
10) What is the use of analyzing the table?
11) How to run SQL script from a unix shell?
12)How to convert RAW datatype into TEXT?
13) What is the difference between primary key and aggregate key?
14)what are "HINTS"?what ia index covering" of a query?
15)what are the large object types supported by oracle?
16)what is SQL*Loader?
17)what is the difference among "dropping table","truncating table" and "deleting all records" from table?
|
|
|
|
|
|
|
|
|
|
| Re: Please give me answers to these interview questions [message #274574 is a reply to message #274532] |
Tue, 16 October 2007 08:26  |
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
|
Senior Member |
|
|
My guess is that those are not interview questions,but a homework assignment. However if they truly are interview questions then simply memorizing answers is foolhardy.
Any competent perspective employer will see through your charade as soon as you start to discuss your accomplishements and how you have implemented various applications.
If somehow you do manage to fool the interviewer, you will soon drown when you start to receive real work.
Go in with what knowledge you have and be honest.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
