Oracle SQL :Interview questions Part-2

1Oracle database automatically creates an index for the primary key of a table and for columns included in a unique constraint.
Options
- True
- False

CORRECT ANSWER : True



2 Which statements are true about the WHEN OTHERS exception handler? (Choose all that apply)
A. It can be the first exception handler.
B. It can be the only exception handler for the code.
C. It traps all the exceptions that are not already trapped.
D. You can have multiple OTHERS clauses to trap all the multiple unhandled exceptions.
Answer: C


 3)DROP PACKAGE manage_emp;
What is the outcome?
A. It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.
B. It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.
C. It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.
D. It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET
package.
Answer: B

4) The _____________ operator returns rows that are retrieved by both queries.
Options
- Inter
- Intersect
- Union
- Both a and b

CORRECT ANSWER : Intersect