Mention a credible reason why select* is never given preference in an sql program that has been embedded.
No Answer is Posted For this Question
Be the First to Post Answer
What is the clustering index in the db2 database?
What is the use of runstats in db2?
What is runstats utility in db2?
What is consistency token in db2?
wht displays the number of times a query modified ?
Why select is not preferred in embedded sql programs?
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.
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
Where is the access path logic created by the DB2 Optimizer stored?
what are the SQL codes u freequently got?
What is check constraint in db2?
What's the difference between DB2 active log and archive log? Thanks a lot...