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
 

 

Need answers of db2 questions

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

New User


Joined: 09 Dec 2005
Posts: 16

PostPosted: Tue Dec 27, 2005 5:07 pm    Post subject: Need answers of db2 questions
Reply with quote

Anyone help me on this..

1. A unit of work is using an isolation level of uncommitted read, and
allows scanning through the table more than once
within the unit of work. Which of the following can occur during processing of this unit of work?

1. It can access uncommitted changes made by other transactions.
2. It can update uncommitted changes made by other transactions.
3. It can update rows and have those updated rows be changed by other transactions from one scan to next.
4. It can update rows and have those updated rows be committed by other transactions from one scan to next.

2. CREATE TABLE T4
(c1 INTEGER NOT NULL,
c2 INTEGER,
c3 DECIMAL(3,2) NOT NULL));
CREATE UNIQUE INDEX i4 ON t4(c1,c3);
ALTER TABLE t4 ADD PRIMARY KEY(c1,c3);

WHich of the fol.statements is true?
1.Alter table statement will fail.
2.Primary key will use t4 unique index.
3.primary key will need to create on the composite key(c1,c3)
4.An additional unique index will automatically be created on the composite key(c1,c3).


3. WHich of the fol. toola can be used to catalog a database?

1. Journal
2..Task center
3. License center.
4. Configuration Assistant
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Tue Dec 27, 2005 7:44 pm    Post subject: Re: Need answers of db2 questions
Reply with quote

Quote:
3. WHich of the fol. toola can be used to catalog a database?

Configuration Assistant

Regards,

Priyesh.
Back to top
View user's profile Send private message
bonniem

New User


Joined: 09 Aug 2005
Posts: 67

PostPosted: Tue Dec 27, 2005 8:05 pm    Post subject:
Reply with quote

1.
Quote:
It can access uncommitted changes made by other transactions.
Back to top
View user's profile Send private message
Candy

New User


Joined: 09 Dec 2005
Posts: 16

PostPosted: Wed Dec 28, 2005 9:57 am    Post subject: Re: Need answers of db2 questions
Reply with quote

Thanks for yr replies.
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 Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am
No new posts File Aid DB2 Questions niks_jude Mainframe Interview Questions 1 Mon Aug 24, 2015 5:13 pm


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