SQL & PL/SQL

Hi all,

These are some interview questions, I was asked. I have given answers for few questions. Please correct me if i am wrong.

Q1. EMP Table is partitioned by range, three partitions.
If i execute SELECT * FROM EMP, will it query/touch all the three partitions OR it wont query any partition?

Q2. Product support question.
Suppose, client has asked me to add a column to a table which is in
production already. What are the issues i have to take care.

Q3. Two same statements are executed, but one statement is upper case and another one is in lower case. Will it go for soft parse or hard parse.
Statement 1: SELECT ENAME, EMPID FROM EMP;
Statement 2: select ename, empid from emp;

Q4. Two same statements are executed, Please see the following 2 statements. Will it go for soft parse or hard parse.
Statement 1: SELECT * FROM EMP;
Statement 2: SELECT EMPNO FROM EMP;
A4. It will go for hard parse

Q5. When we will go for Stored Procedure and when we will go for function ?
A5. Normally Stored procedure is used to do some task and functions are used
to compute a value. Other than this is there any ?

Q6. How MANY to MANY relationship is created between two objects ?
A6. By Junction Tables. Other than this is there any ?



Thanks in advance,
Pal