|
View previous topic :: View next topic
|
| Author |
Message |
Binaya
New User
Joined: 03 Jul 2007
Posts: 77
Location: Hyderabad
|
|
|
|
Hello
I need Help on the below 11 questions.
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: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)
Q.3: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.4:Which is used to return an error or warning condition with no SQLSTATE operand to the calling program?
RESIGNAL
SIGNAL
RAISE
ERROR
Q.5: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.6:Point out types of join?
Equi-Join,Non-equijoin,self-join
Outer joins, Inner joins
None of the options
All of the options
Q.7:which isolation levels holds the transaction till commit?
Q.8:which isolation levels holds the transaction till UOW?
Q.9:which isolation level gives access to other users to update rows in table?
Q.10:When the RLF cancels a dynamic SQL statement, DB2 returns an SQLCODE __________
-906
-904
-907
-905
Q.11:What compound index?(Is it Composite Index? As I know what is composite index)
Regards,
Binaya |
|
| Back to top |
|
 |
Binaya
New User
Joined: 03 Jul 2007
Posts: 77
Location: Hyderabad
|
|
|
|
Can I get some help on this please.
Regards,
Binaya. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
Binaya
New User
Joined: 03 Jul 2007
Posts: 77
Location: Hyderabad
|
|
|
|
Hello
For the remaining queries, I browsed net and I feel These are the answers. Please let me know if I am correct or not.
Point out types of join?
Equi-Join,Non-equijoin,self-join
Outer joins, Inner joins---> I feel this is correct.
None of the options
All of the options
Which is used to return an error or warning condition with no SQLSTATE operand to the calling program?
RESIGNAL---> I feel this is correct.
SIGNAL
RAISE
ERROR
When the RLF cancels a dynamic SQL statement, DB2 returns an SQLCODE __________
-906
-904
-907
-905---> I feel this is correct.
What compound index?(Is it Composite Index? As I know what is composite index)
Regards
Binaya |
|
| Back to top |
|
|
|
|
