Home » Other » Training & Certification » Please give me answers to these interview questions
Please give me answers to these interview questions [message #274532] Tue, 16 October 2007 05:47 Go to next message
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"?

Cool 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: plz give me answers to these interviw questions [message #274538 is a reply to message #274532] Tue, 16 October 2007 06:19 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Same answer for all of them.
READ THE DOCUMENTATION.
Re: plz give me answers to these interviw questions [message #274541 is a reply to message #274532] Tue, 16 October 2007 06:24 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
So you'd be quite willing to accept a job, knowing that you had deliberately mislead the company that is hiring you, and that you did not have the skills that they were going to pay you for.

Words really do fail me.
Re: plz give me answers to these interviw questions [message #274552 is a reply to message #274532] Tue, 16 October 2007 07:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post your answers and then we know what we have to reply.

Regards
Michel
Re: Please give me answers to these interview questions [message #274574 is a reply to message #274532] Tue, 16 October 2007 08:26 Go to previous message
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.
Previous Topic: SAME COLUMN VALUES COMPARISION
Next Topic: Can you please tell us OCA certification centers in Bangalore?
Goto Forum:
  


Current Time: Tue Dec 06 10:46:29 CST 2016

Total time taken to generate the page: 0.10892 seconds