1. What is inheritance ?

Inheritance is a method by which properties and methods of an existing object are automatically passed to any object derived from it.

2. Why is an event driven program referred to a passive program ?

Because an event driven program is always waiting for something to happen before processing.

3. What does one do when one is rightsizing ?

With rightsizing, one would move applications to the most appropriate server platforms.

4. Read the following code:

     40. CREATE OR REPLACE PROCEDURE calculate_budget IS
     41. v_budget studio.yearly_budget%TYPE;
     42. BEGIN
     43. v_budget := get_budget(11);
     44. IF v_budget <>
     45. THEN
     46. set_budget(11,30000000);
     47. END IF;
     48. END;

You are about to add an argument to CALCULATE_BUDGET. What effect will this have?

•  The GET_BUDGET function will be marked invalid and must be recompiled before the next execution.
•  The SET_BUDGET function will be marked invalid and must be recompiled before the next execution.
•  Only the CALCULATE_BUDGET procedure needs to be recompiled.
•  All three procedures are marked invalid and must be recompiled.

5. What are the advantages of VIEW?

• To protect some of the columns of a table from other users.
• To hide complexity of a query.
• To hide complexity of calculations.

6. How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value?

Sequence name CURRVAL, sequence name NEXTVAL. It is not possible. Only if you access next value in the session, current value can be accessed.

7. What is the output of the following query SELECT TRUNC(1234.5678,-2) FROM DUAL;?

1200

8. What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

The privilege receiver can further grant the privileges he/she has obtained from the owner to any other user.

9. Deadlock

                 Deadlock is a unique situation in a multi user system that causes two or more users to wait indefinitely for a locked resource. First user needs a resource locked by the second user and the second user needs a resource locked by the first user. To avoid dead locks, avoid using exclusive table lock and if using, use it in the same sequence and use Commit frequently to release locks.

10. SQL*Loader

                 SQL*Loader is a product for moving data in external files into tables in an Oracle database. To load data from external files into an Oracle database, two types of input must be provided to SQL*Loader : the data itself and the control file. The control file describes the data to be loaded. It describes the Names and format of the data files, Specifications for loading data and the Data to be loaded (optional). Invoking the loader sqlload username/password controlfilename .