IBM DB2 Interview Questions & Answers part 5
Q: – What is an index key?
It is a column or set of columns in a table used to determine the order of index entries.
Q: – Give user USER1 the privileges needed to query the table MY_TABLE, along with the ability to give these privileges to other users whenever required?
db2 "GRANT SELECT ON TABLE MY_TABLE TO USER1 WITH GRANT OPTION"
Q: – What is sqlcode -922?
Q: – for Windows, What is the default buffer pool size?
250 pages or 1 MB
Q: – What is "Primary Key"?
A primary key is a key that is unique, non-null, and is part of the definition of a table. A table must have a primary key to be defined as a parent.
Q: – Which DB2 authentication types are available for DB2 9?
SERVER, SERVER_ENCRYPT, CLIENT, KERBEROS, KRB_SERVER_ENCRYPT, DATA_ENCRYPT, DATA_ENCRYPT_CMP, GSSPLUGIN, and GSS_SERVER_ENCRYPT.
Q: – What is a recovery log?
A recovery log is a collection of records that describes the sequence of events that occur in DB2 database. The information is needed for recovery in the event of a failure during execution.
Q: – What is "Buffer pools"?
The database buffer pool area is a piece of memory used to cache a table's index and data pages as they are being read from disk to be scanned or modified. The buffer pool area helps to improve database system performance by allowing data to be accessed from memory instead of from disk.
Q: – How would you find out the total number of rows in a table?
Q: – What is "system catalogs"?
A set of system catalog tables is created and maintained for each database. These tables contain information about the definitions of the database objects (tables, views, indexes, and packages, for example) and security information about the type of access that users have to these objects. These tables are stored in the SYSCATSPACE table space.
Submitted By:-Vikas Email-ID: – email@example.com