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 Interview Question - Help Needed

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

New User


Joined: 03 Jul 2007
Posts: 77
Location: Hyderabad

PostPosted: Tue Jun 16, 2009 12:07 am    Post subject: DB2 Interview Question - Help Needed
Reply with quote

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
View user's profile Send private message

Binaya

New User


Joined: 03 Jul 2007
Posts: 77
Location: Hyderabad

PostPosted: Tue Jun 16, 2009 6:54 am    Post subject: Reply to: DB2 Interview Question - Help Needed
Reply with quote

Can I get some help on this please.

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

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

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

http://www.ibmmainframes.com/viewtopic.php?t=41448&highlight=
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 12:26 pm    Post subject: Reply to: DB2 Interview Question - Help Needed
Reply with quote

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
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 Fault Analyzer - listings question. egrove IBM Tools 4 Thu Aug 11, 2016 5:31 pm
No new posts dataset copy question - REPRO or some... atulxp TSO/ISPF 2 Wed Aug 03, 2016 10:56 pm
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts SQL Order By related question Joseph K Thomas DB2 8 Fri Mar 18, 2016 12:53 pm
No new posts DFSort Question krrp DFSORT/ICETOOL 9 Mon Mar 07, 2016 7:11 pm


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