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 a dbrm in db2?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is check constraint in db2?
List out the data types available.
What is the difference between db2 and oracle?
Explain various types of locks in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What do you mean by commit and rollback?
What is role in db2?
What is copy pending status in db2?
Can SQL statements/queries be included in a copybook?
What DB2 Catalog column tell you when an index needs table reorganized ?