KyaPoocha.com

Related Interview Questions

• What are all stored in System Catalog?  05.12.08

  a) SQL table b) SQL View...

• Difference between:-DOMAIN CONTROLLER and GLOBAL CATALOG ?  20.08.08

  1. Transmission Control Protocol: a standard protocol for transmitting the information. Remote Desktop Protocol: Used for accessing the Desktop Remotely 2...

• There are at least seven IDCAMS commands; name and explain each of them ?  11.08.08

  ALTER modifies information for a catalog, alternate index, cluster or path. BLDINDEX builds the alternate index, of course. DEFINE is used for ALTERNATEINDEX,...

• What is the catalog ?  10.08.08

  The catalog contains the names of all datasets, VSAM and non-VSAM. It is used to access these datasets....

• What does the parameter Initial Catalog define inside Connection String ?  21.04.08

  The database name to connect to....

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

  Run the MODIFY RECOVERY Utility....

• Which catalog table stores referential constraints ?  10.04.08

  The SYSIBM.SYSRELS table. DB2 Directory...

• Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database ?  10.04.08

  The catalog tables to use are the SYSIBM.SYSTABLES and the SYSIBM.SYSCOLUMNS....

• What information is used as input to the bind process?  07.03.08

  The database request module produced during the pre-compile. The SYSIBM.SYSSTMT table of the DB2 catalog....

• What is system catalog or catalog relation? How is better known as?  08.03.06

  A RDBMS maintains a description of all the data that it contains, information about every relation and index that it contains. This information is stored in a c...