Database Interview Questions | Technical Interview & Viva Questions : KyaPoocha.com

Database Interview Questions

Pages (999999): [1] 2 3 » ... Last »

How can one determine the status of a tablespace ?

View the Answer

How is the status of a utility reset after it has been stopped by DB2 ?

View the Answer

Which command is issued to establish the Boot Strap Data Set after an I/O failure ?

View the Answer

Which DB2 command is used to retrieve environmental information ?

View the Answer

Can you access the DB2 Directory table using SQL? ?

View the Answer

Where besides the DB2 catalog is database object information stored by DB2 ?

View the Answer

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored ?

View the Answer

How does one remove entries from the SCT02 table ?

View the Answer

When is the skeleton cursor table created ?

View the Answer

Where is the access path logic created by the DB2 Optimizer stored ?

View the Answer

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible ?

View the Answer

How would one remove old reorg information from the DB2 catalog ?

View the Answer

What Utility is used to migrate DB2 from one release to the next ?

View the Answer

Which catalog table stores referential constraints ?

View the Answer

Which catalog tables contain authorization information ?

View the Answer

Pages (999999): [1] 2 3 » ... Last »