Interview questions.. please help answer [message #116933] |
Sat, 23 April 2005 11:24 |
vgs2005
Messages: 123 Registered: April 2005
|
Senior Member |
|
|
Hi,
I'm preparing for an interview. It will be very helpful in my preparation if you can provide the answers for the following questions.
- How will you copy the structure of a table without copying the data?
- What is DYNAMIC SQL method 4?
- How to remove duplicate records from a table?
- What is the use of ANALYZing the tables?
- What is a "transaction"? Why are they necessary?
- How to convert RAW datatype into TEXT?
- What are "HINTS"?
- What is "index covering" of a query?
- Difference between "VARCHAR" and "VARCHAR2" datatypes.
- How to create a database link ?
- Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?
- How do you measure the performance of a stored procedure?
thanks in advance...
|
|
|
|
Re: Interview questions.. please help answer [message #117462 is a reply to message #117171] |
Wed, 27 April 2005 07:57 |
vgs2005
Messages: 123 Registered: April 2005
|
Senior Member |
|
|
Thanks a lot! Found some of the answers from a book, too. By the way, (please bear with me) - what does it mean when a WHERE condition has an equation with 2 integers - like what you wrote:
..SELECT * FROM T2 WHERE 1=2;
I saw this once before, but failed to understand.
|
|
|
Re: Interview questions.. please help answer [message #117470 is a reply to message #116933] |
Wed, 27 April 2005 08:19 |
smartin
Messages: 1803 Registered: March 2005 Location: Jacksonville, Florida
|
Senior Member |
|
|
Because it is two constant integers, it is something you can control to always be true or always be false. where 1=2 is never going to happen, because one will never equal two. where 1=1 will always happen.
|
|
|
Re: Interview questions.. please help answer [message #117748 is a reply to message #117470] |
Fri, 29 April 2005 07:42 |
vgs2005
Messages: 123 Registered: April 2005
|
Senior Member |
|
|
So if
Select * from emp;
returns 5 rows (with columns: name, id, dept, salary)
what does
Select * from emp where 1=1;
return? OR how will the output be?
How about
Select * from emp where 1=2;
Sorry, I know I can easily answer this if I have a SQLPLus in my PC. Unfortunately, I just moved in to a new place and yet to find a 'job' so don't have my PC with me right now..
Thanks in advance...
|
|
|
|
|
|