How we create a tables in db2,what is the process/syntax to create a table with example plz?2 13323
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.3 6525
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?2 4454
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'10 11207
why we create view.5 7154
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th5 7337
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!17 18250
How to know the primary key of a table without defining the primary key in the table?5 11630
Define buffer pool.
What is the use of dclgen in db2?
Can one database have multiple instances?
What is the maximum No of rows per page?
What is the purpose of rollback and commit?
What is netezza database?
What are db2 tables?
What is data manager?
How can you quickly find out the # of rows updated after an update statement?
What is the use of predicate?
What is scrollable cursor in db2?
What is dclgen in db2?
What is the physical storage length of the data types date, time, and timestamp?
What is coalesce in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?