What is check constraint. Explain with example.
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
Which components manage deadlocks in db2?
What is db2 bind process?
What kind of database is db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is query for your birthday date should be in hours,minute and seconds format?
What are PACKAGES ?
What is the function of the Data Manager?
Explain transactions, commits and rollbacks in DB2.
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
What is meant by AUTO COMMIT?
what happend with out using Commit,when closing cursor and program?