IBM DB2 Interview Questions & Answers part 4

0
342
Q: – When you use "create database" command than by default which table spaces creates?

The create database command creates three default table spaces.

– SYSCATSPACE
– TEMPSPACE1
– USERSPACE1

Q: – What is REORG?  When is it used?

REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space.  It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented.

Q: – for UNIX or Linux, What is the default buffer size?

1,000 pages or 4 MB

Q: – When a database is created than which default buffer pool is created?

BMDEFAULTBP

Q: – What are the disadvantages of PAGE level lock?

High resource utilization

Q: – What is a NULL value?

A NULL value takes up one byte of storage and indicates that a value is not present as opposed to a space or zero value.

Q: – How you will give all table privileges available for the table TEST_1 (except CONTROL privilege) to the group GRP?

db2 "GRANT ALL PRIVILEGES ON TABLE TEST_1 TO GRP"

Submitted By:-Vikas            Email-ID: – vikas123.singh@yahoo.com

SHARE

LEAVE A REPLY