- All Exams Instant Download
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 myuserA . An error is returnedB . An entry is mane in SYSCAC . TABAUTHD . The REVOKE statement succeeds with no effectE . All privileges are...
What will be the result if the user executes the following statement?
A user executes the following statements: СREATE TABLE t1 (c1 INT, c2 INT); CREATE ALIAS a1 FOR t1; What will be the result if the user executes the following statement? DROP ALIAS a1;A . The alias A1 will be droppedB . The table T1 will be droppedC . Both T1...
When an RS-232 serial cable is connected between a service laptop and SC Series hardware, which parameters need to be selected?
When an RS-232 serial cable is connected between a service laptop and SC Series hardware, which parameters need to be selected?A . Baud Rate = 9600, Parity = None Data Bits = 8, Stop Bits =1, Flow Control = XON/XOFFB . Baud Rate = 115200, Parity = None Data Bits...
year. Keep data size on disk to a minimum is a priority?
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...
Which of the following should the technician check NEXT?
Several computers are having network connectivity issues. Two of the computers are wired and are not having any issues. The technician verifies that none of the computers having issues have been assigned a static IP. Which of the following should the technician check NEXT?A . Check the closest AP for...
Which of the following authorities are sufficient for creating a database? (Choose two.)
Which of the following authorities are sufficient for creating a database? (Choose two.)A . DBADMB . SYSADMC . SECADMD . SYSCTRLE . SYSMAINTView AnswerAnswer: BD Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html
Which of the following statements about triggers are TRUE? (Choose two.)
Which of the following statements about triggers are TRUE? (Choose two.)A . There is a limit of 8 for the maximum number of cascading trigger activationsB . Triggers can be activated as a result of changes due to referential constraint enforcementC . Multiple INSTEAD OF triggers are allowed for each...
Which three facilities are used to control authorization in DB2?
Which three facilities are used to control authorization in DB2?A . privileges, db2ssh, LBAC credentialsB . privileges, authority levels, certificatesC . db2ssh, trusted contexts, authority levelsD . privileges, authority levels, LBAC credentialsView AnswerAnswer: D Explanation:https://www.ibm.com/support/knowledgecenter/zh/SSEPGG_9.5.0/ com.ibm.db2.luw.admin.sec.doc/doc/c0006307.html
statements on a table?
Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?A . COMMITB . SAVEPOINTC . ROLLBACK WORKD . UPDATE TERMINATEView AnswerAnswer: C Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_rollback.html
Which of the following authorities is sufficient for connecting to a database?
Which of the following authorities is sufficient for connecting to a database?A . SQLADMB . CONNECTC . DATAACESSD . ACCESSCTRLView AnswerAnswer: B Explanation:http://www-01.ibm.com/support/docview.wss?uid=swg21427232
