|
View previous topic :: View next topic
|
| Author |
Message |
Binaya
New User
Joined: 03 Jul 2007
Posts: 77
Location: Hyderabad
|
|
|
|
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 |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
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 |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008
Posts: 193
Location: chennai
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Makes one wonder why you posted, Raghu. |
|
| Back to top |
|
|
Binaya
New User
Joined: 03 Jul 2007
Posts: 77
Location: Hyderabad
|
|
|
|
Raghu
The answers have been given out of the options present in Q1.
Thanks Dick, for your response.
Regards
Binaya |
|
| Back to top |
|
|
|
|
