- All Exams Instant Download
While DSN is running, which of the following commands CANNOT be successfully executed?
While DSN is running, which of the following commands CANNOT be successfully executed?A . CSTOP DB2B . CSTART DB2C . CTERM UTILITYD . CDISPLAY UTILITYView AnswerAnswer: D
Which package level privileges does the user smith have when the following statement is executed?
Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;A . GRANT, COPY, BIND, RUNB . BIND, EXECUTE, COPY, RUNC . CREATE, COPY, RUN, EXECUTED . COPY, BINDADD, SQL, EXECUTEView AnswerAnswer: B Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_grantpackageprivileges.html
Which job log would show all of these?
You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?A . MSTRB . DBM1C . DISTD . IRLMView AnswerAnswer: A
Which DB2 address space manages DB2 locking?
Which DB2 address space manages DB2 locking?A . IRLMB . DISTC . DBM1D . MSTRView AnswerAnswer: A Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/inst/src/tpc/ db2z_irlmaddrspcstgreq.html
Which Excel option should be deployed for each team?
HOTSPOT You are a Dynamics 365 Customer Engagement administrator. Each team will use Microsoft Excel in different ways. You need to select an Excel option to meet the needs of each team. Which Excel option should be deployed for each team? To answer, select the appropriate configuration in the answer...
What is the result XQuery FLWOR expression when running the following scenario?
What is the result XQuery FLWOR expression when running the following scenario? A . Joe SmithB . <name> Joe Smith </name>C . <employeeinfo><name> Joe Smith </name></employeeinfo>D . <name> Joe Smith </name><department name>DB2</department name>View AnswerAnswer: A
Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?
Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?A . COPYB . REORGC . STOSPACED . BACKUP SYSTEMView AnswerAnswer: D Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/ db2z_useutilitiespaneldb2i.html
In a unique referential constraint, which type of key does a foreign key reference?
In a unique referential constraint, which type of key does a foreign key reference?A . Child keyB . Collation keyC . Parent keyD . Secondary keyView AnswerAnswer: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0020166.html
Which of the following is NOT TRUE?
Which of the following is NOT TRUE?A . An index can be created on XML columnsB . Length must be specified for an XML columnC . XML columns can be added to existing tablesD . Triggers can be created on tables with XML columnsView AnswerAnswer: D
Which BIND option determines when DB2 will do authorization checking?
Which BIND option determines when DB2 will do authorization checking?A . DEFERB . DEPLOYC . VALIDATED . CURRENTDATAView AnswerAnswer: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/ db2z_bindoptvalidate.html
