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 - Isolation level queries.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Binaya

New User


Joined: 03 Jul 2007
Posts: 77
Location: Hyderabad

PostPosted: Tue Jun 16, 2009 8:30 am    Post subject: DB2 - Isolation level queries.
Reply with quote

Hello

I think I should have asked my queries in this DB2 forum.
Can anybody help me on the below questions please?

Q.1: A database contains a read-only lookup table. In order to provide optimum read concurrency, transactions accessing this table should be run using which of the following isolation levels?

Options:
Cursor Stability
Read Stability
Uncommitted Read
Repeatable Read

Q.2:In case of read only cursor with RR isolation level whcih statement is correct?
a. Program will lock the record till the rollback issue/ or end of program b. RR isolation will be ignored

Q.3:which isolation level gives access to other users to update rows in table?

Q.4:Dynamic SQL when compared to Statc SQL.
a. Needs more System Resources
b. Needs more time for execution
c. Needs more time to bind
d. None

Q.5:which isolation levels holds the transaction till commit?

Q.6:which isolation levels holds the transaction till UOW?

Q.7:Given the table definition:
CREATE TABLE student (name CHAR(30), age INTEGER)

To list the names of the 10 youngest students, which of the following index definition statements on the student table may improve the query performance?

Options:
CREATE INDEX youngest ON student (age, name)
CREATE INDEX youngest ON student (name, age)
CREATE INDEX youngest ON student (name, age DESC)
CREATE INDEX youngest ON student (name DESC) INCLUDE (age)


Regards,
Binaya
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Jun 16, 2009 8:43 am    Post subject:
Reply with quote

1.a
2.a
3.a
4.a
5.a
6.a
7.a

i put a little more effort in answering than you did,
and by the way,
I think this should have stayed in interview questions.
Back to top
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 186
Location: chennai

PostPosted: Tue Jun 16, 2009 3:14 pm    Post subject: Reply to: DB2 - Isolation level queries.
Reply with quote

Hi Dick

There is no choice for Q3, Q4 and Q5. Then how do you choose the answer ?

You simlpy put "a" as the answer!

Regards
Raghu
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Jun 16, 2009 5:16 pm    Post subject:
Reply with quote

Makes one wonder why you posted, Raghu.
Back to top
View user's profile Send private message
Binaya

New User


Joined: 03 Jul 2007
Posts: 77
Location: Hyderabad

PostPosted: Tue Jun 16, 2009 5:56 pm    Post subject: Reply to: DB2 - Isolation level queries.
Reply with quote

Raghu

The answers have been given out of the options present in Q1.

Thanks Dick, for your response.

Regards
Binaya
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help with below queries ashek15 DB2 0 Thu Mar 23, 2017 1:38 am
No new posts Syncsort TPF Level Majid Hussain SYNCSORT 2 Wed Apr 13, 2016 2:22 am
No new posts Need a logic to validate the data in ... sandeep kumar302 COBOL Programming 17 Mon Feb 01, 2016 3:30 pm
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts DB2 10.1 Share level locking and Sele... Mary Lewis DB2 1 Wed Apr 15, 2015 9:51 pm


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