Tag: databases

Questions Related to databases

Multiple choice technology databases

Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?

REVOKE CONNECT ON DATABASE FROM user2
REVOKE CREATETAB ON DATABASE FROM user2
REVOKE BIND ON DATABASE FROM user2
REVOKE BINDADD ON DATABASE FROM user2

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform DML, but no other operations on table TABLE1?

GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO user1 AND group1
GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1
GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 TO USER user1, GROUP group1
GRANT CONTROL ON TABLE table1 TO user1 AND group1

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

USER1 is the owner of TABLE1. Assuming USER1 only holds privileges for TABLE1, which of the following is the best way to remove all privileges USER1 holds?

REVOKE CONTROL ON table1 FROM user1
REVOKE ALL PRIVILEGES ON table1 FROM user1
REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1
REVOKE CONTROL, ALL PRIVILEGES ON table1 FROM user1

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which authority or privilege is granted by the DB2 Database Manager configuration file?

CONNECT
CONTROL
SYSMAINT
EXECUTE

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

A table called DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?

GRANT ALTER ON TABLE department TO user1
GRANT ALTER (dept_name) ON TABLE department TO user1
GRANT UPDATE ON TABLE department TO user1
GRANT UPDATE (dept_name) ON TABLE department TO user1

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?

GRANT DROP ON INDEX empid_x TO user1
GRANT DELETE ON INDEX empid_x TO user1
GRANT INDEX ON TABLE employee TO user1
GRANT CONTROL ON INDEX empid_x TO user1

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

What does the following statement do? GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH GRANT OPTION

Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.
Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.
Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.
Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

A view named V.VIEW1 is based on a table named T.TABLE1. A user with DBADM authority issues the following statement: GRANT INSERT ON v.view1 TO user1 WITH GRANT OPTION Which of the following statements is USER1 authorized to execute?

GRANT INSERT ON t.table1 TO user2
GRANT CONTROL ON v.view1 TO user2
GRANT ALL PRIVILEGES ON v.view1 TO user2
GRANT INSERT ON v.view1 TO user2

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Assume PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1 but not remove them?

REVOKE DROP ON T1 FROM PUBLIC
REVOKE UPDATE ON T1 FROM PUBLIC
REVOKE DELETE ON T1 FROM PUBLIC
REVOKE CONTROL ON T1 FROM PUBLIC

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

A DRDA host database resides on a z/OS or an i5/OS and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?

CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
327
328
329
330
331
332
333
334
335
…
486
487
Next →