Can All Users Have The Privilege To Use The SQL Statement
Select (DML)?
Answer Posted / s
If the SELECT privilege is granted to PUBLIC, Yes.
Otherwise privilege has to granted explicitly.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you select a row using indexes in db2?
What is rct?
Explain about open switch business continuity software?
What is meant by dclgen?
How to check table size in db2 sap?
Before you give the explain statement, what are the prerogatives?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Are views updateable?
What is netezza database?
Give a brief description of db2 isolation levels?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Describe major components of db2?
What do you mean by rollback?
What is the maximum length of sqlca?
What is dbrm? When it will be created?