Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm
No new posts Find out a active PGM jpsager JCL & VSAM 10 Fri Oct 07, 2016 4:32 pm
No new posts How to find a CICS resource used in C... Arunkumar Chandrasekaran CICS 8 Thu Sep 29, 2016 1:45 pm
No new posts how to find clist's or view library Andrew Hsia CLIST & REXX 4 Tue Jun 28, 2016 6:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us