Interview Questions

Row Level Trigger :
Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.

Statement Level Trigger :
This kind of trigger fires when a SQL statement affects the rows of the table. The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement.

The throughput garbage collector uses a parallel version of the young generation collector and is meant to be used with applications that have medium to large data sets. On the other hand, the serial collector is usually adequate for most small applications (those requiring heaps of up to approximately 100MB on modern processors).

A Budget is a financial plan of expected cash inflows and outflows that a business generates.
It is generally a long-term statement involving ammual updates. It is best described as A formal statement of a company's future plans usually expressed in monetary terms.

If an error occurs in program, then only exception object is created otherwise, It will not be created. So it’s expensive to use in the program.

True .That event occurs whenever a new user visits

ANALYZE command is used to perform various functions on index, table, or cluster, as listed below:
- It helps in dentifying migrated and chained rows of the table or cluster.
- It helps in validating the structure of the object.
- It helps in collecting the statistics about object used by the optimizer. They are then stored in the data dictionary.
- It helps in deleting statistics used by object from the data dictionary.

Sample Answers :

(i) Be prepared for the incoming crew. Ensure the ambulance is clean and fully stocked. Arrive early so that shift changes can take place on time, still leaving you enough time to check the ambulance and be ready to go if you get a call.

(ii) Show up a little early for your shift for rig check and to receive any information from outgoing crew. When you are the outgoing crew,leave rig in a better state than you found it. Communicate with incoming/outgoing crew allowing a smooth transition.