Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 700 certification did'nt find the answers

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
rohit_raajin

New User


Joined: 10 May 2005
Posts: 10
Location: india

PostPosted: Thu May 24, 2007 12:15 pm    Post subject: DB2 700 certification did'nt find the answers
Reply with quote

In which of the following is the size of the buffer used during an online backup defined ?
a. DB2_backupsz registry variable
b. DBM configuration of database instance.
c. DBM.INI file for the database instance
d. DB configuration for database being backed up.


Given the following :
CREATE TABLE tab1(col1 int CONSTRANT notnull CHECK(col1 IS NOT NULL), col2 CHAR(10)
which of the following will enforce uniqueness of col1 which currently does not contain duplicate values ?
a.Create primary key on col1.
b.Create unique index on col1
c.Create a cluster index on col1
d.Create unique constrant on col1
Back to top
View user's profile Send private message

MFRASHEED

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA

PostPosted: Thu May 24, 2007 10:10 pm    Post subject:
Reply with quote

1. (a)

backbufsz : This parameter specifies the size of the buffer used when backing up the database when a value is not explicitly specified in the backup utility.

2. (b).

Here is the explanation:

If the statement was unique constraint, then Db2 will automatically create a unique index. Since it is not unique constraint a unique index has to be created. There is a difference between defining a unique constraint and creating a unique index. Both enforce uniqueness, a unique index allows nullable columns and generally cannot be used as a primary key.
Back to top
View user's profile Send private message
deepak.vl

New User


Joined: 17 Feb 2007
Posts: 38
Location: Hyderabad

PostPosted: Sun May 27, 2007 7:12 pm    Post subject:
Reply with quote

Hi,
For the second Q, even option (a) seems to enforce uniqueness to COL1. Any specific reason why that is not the answer?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 pm
No new posts Command to find TMEMBER name for a TPIPE Siva NKK Kothamasu IMS DB/DC 0 Wed Aug 16, 2017 6:08 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us