What is a LIKE table and how is it created?
Answers were Sorted based on User's Feedback
Answer / nag(igate)
the like will create the same table structure and it will
not copy data from existing table.
| Is This Answer Correct ? | 2 Yes | 0 No |
How many buffer pools are there in DB2?
What will the COMMIT accomplish?
Normalization in DB2 – first normal form, second normal form
What is a collection in db2?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is runstats db2?
List down the data types in the db2 database.
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'
What do the initials DDL and DML stand for and what is their meaning?
What is the role of data manager in the db2 database?
Can we update view in db2?
What is the reason behind not using select * in embedded sql programs?