What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE? REVOKE SELECT ON TABLE mytable FROM USER myuser A. An error is returned B. An entry is mane in SYSCAT.TABAUTH C. The REVOKE statement succeeds with no effect D. All privileges are granted to user MYUSER on MYTABLE
Which database object can be locked explicitly?
Which database object can be locked explicitly? A. Row B. View C. Index D. Table Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html
Which three facilities are used to control authorization in DB2?
Which three facilities are used to control authorization in DB2? A. privileges, db2ssh, LBAC credentials B. privileges, authority levels, certificates C. db2ssh, trusted contexts, authority levels D. privileges, authority levels, LBAC credentials Reference: https://www.ibm.com/support/knowledgecenter/zh/SSEPGG_9.5.0/com.ibm.db2.luw.admin.sec.doc/doc/c0006307.html
Which of the following editions of DB2 include support for Federation with Oracle database?
Which of the following editions of DB2 include support for Federation with Oracle database? A. DB2 Express-C B. DB2 Developer Edition C. DB2 Enterprise Server Edition D. DB2 Workgroup Server Edition Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1311db2compare/index.html
You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The applicati
You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data […]
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with “CREATE INDEX AAA ON…”. Which of the following statements must precede the CREATE statement so that you can create the index? A. SET CURRENT […]
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL sta
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed? A. SQLCA B. SQLDA C. SQLCODE D. SQLSTATE
Which statement is TRUE regarding ROLLBACK processing?
Which statement is TRUE regarding ROLLBACK processing? A. It only reads active logs B. It always needs archive logs C. It can never be processed just from memory D. It uses output buffers, active and archive logs
Which of the following elements is affected by a ROLLBACK statement?
Which of the following elements is affected by a ROLLBACK statement? A. LOB table spaces B. Changes in cursor positioning C. Acquisition and release of locks D. Caching of rolled back statements Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_rollback.html
The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the fol
The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location? A. SELECT * FROM MYUSER.EMP; B. CONNECT TO MYREMOTE; SELECT * FROM MYUSER.EMP; C. SELECT * FROM MYUSER.MYREMOTE.EMP; D. CREATE ALIAS EMP_ALIAS […]