Important Interview Questions of Diffrent Companies..

What is sortheap ?



Defines the maximum number of private memory pages to be used for private sorts, or the maximum number of shared memory pages to be used for shared sorts

What is online Reorg/offline?


Both online and offline are there, online reorg allows other transaction to access the tables. REORG with ALLOW NO/READ/WRITE ACCESS

Which utilities do a sort? If you create an index , it will sort the corresponding column

If you are given with a query, how you tune it?

Does runstats do a sort? reorg does ? nope

Build phase of load utility does a sort ? yes

Have you done server installation? Nope ;-0 first level IBM Team only does it !!

Disaster Recovery? HADR

Increamental /Delta Back up ?

What are the db cfg parms which affect the back up strategy?

Load utility, if I want to load data with out any chance of taking the tablespace to back up pending state? LOAD with NORECOVERY option

Whats the difference between Load and import? Load is faster than import, import is like bulk insert, every thing goes to the transaction log.

Would you load data to the production tables directly? Nope .. Use staging tables

If application team is contacting you telling the application is running very slow , what all things you will check out ?

- Check for any transactions that are in lock wait state, list in doubt transactions

Table DB snap shop, Application snapshot,sql snap shopt , cpu utilization using top,check is there any stale connection( connections that very old )


- Check if any background process is running there using list utilities

- Check the number of active connections to the DB server


- Force the application/transactions which are in lock wait state

What is the difference between creating buffer pool with immediate option and default option??

How do you get tickets in your projects?

Whats star schema? Vertical portioned tables

Whats snow flow schema??


----------------------------------------------These are from First Round of CTS