Sql interview Question answers for 2012

Posted by Stephen thangaraj at 09:18
Q1. What is PL/SQL ?
A1. A programming language available in Oracle. It is a way of wrapping SQL with 3GL constructs such as IF..THEN..ELSE, WHILE etc.

Q2. What is locking and what is it used for ?
A2 Locking is a mechanism to restrict access to data. It prevents one user updating data whilst another user is looking at it.
Q3. What types of locking are available with Oracle?
A3. Row locking and table locking.

Q4. What happens if a tablespace clause is left off of a primary key constraint clause?
A4. This results in the index that is automatically generated being placed in the users default tablespace. Since this will usually be the same tablespace as the table is being created in, this can cause serious performance problems.

Q5. What packages (if any) has Oracle provided for use by developers?
A5. Oracle provides the DBMS_ series of packages. There are many which developers should be aware of such as DBMS_SQL, DBMS_PIPE, DBMS_TRANSACTION, DBMS_LOCK, DBMS_ALERT, DBMS_OUTPUT, DBMS_JOB, DBMS_UTILITY, DBMS_DDL, UTL_FILE.

Q6. When should more than one DB writer process be used? How many should be used?
A6. If the UNIX system being used is capable of asynchronous IO then only one is required, if the system is not capable of asynchronous IO then up to twice the number of disks used by Oracle number of DB writers should be specified by use of the db_writers initialisation parameter.

click the Below link download this file 

If you enjoyed this post and wish to be informed whenever a new post is published, then make sure you subscribe to my regular Email Updates. Subscribe Now!

Kindly Bookmark and Share it:



Have any question? Feel Free To Post Below:

Blog Archive


© 2011. All Rights Reserved | Interview Questions | Template by Blogger Widgets

Home | About | Top