which authority can be granted to group of users using the
GRANT stmt?
A) SYSCTRL
B) SYSADM
C) DBCTRL
D) DB ADM
- 3 Answers
- 10230 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nickyhuang
(D)Database level authorities, DBADM and LOAD, are granted
to a user or a group of user by the GRANT statement; SYSADM
grant/revoke DBADM.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / shweta
SYSCTRL and SYADM can be granted only to groups while
DBCTRL and DBADM can be granted to both users and groups.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mehdee
- All the above group are Data Base Admin. they are not
users. The following are the type of grant to users:
GRANT SELECT ON TABLE
GRANT DELETE ON TABLE
GRANT BIND,EXECUTE ON PACKAGE
GRANT UPDATE ON TABLE
GRANT INSERT ON TABLE
GRANT ALL ON TABLE
| Is This Answer Correct ? | 1 Yes | 1 No |
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is collection in db2 bind?
how can u nderstand the sql stmts executed successfully or not ?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What will the DB2 optimizer do?
What is isolation level?
What is runstats and reorg in db2?
What are some SQL aggregates and other built-in functions?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Describe the elements of the SELECT query syntax?
COBOL 
