Can All Users Have The Privilege To Use The SQL Statement
Select (DML)?
Answer / s
If the SELECT privilege is granted to PUBLIC, Yes.
Otherwise privilege has to granted explicitly.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is COPY PENDING status?
What is the function of buffer manager?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
Differentiate between cs and rr isolation levels? Where do you specify them?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
what is load and unload in db2
What else is there in the PLAN apart from the access path?
How to define the data items to receive the fetch items for the SQL?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
Once you create a view, where would information about the view be stored?
Explain transactions, commits and rollbacks in DB2.