IBM Certified Database Administrator Archives - Page 5 of 10

Which type of constraint is NOT enforced by DB2 during SQL processing?

December 14, 2020PdfprepC2090-320IBM Certified Database Administrator, C2090-320 exam questions, C2090-320 practice exam

Which type of constraint is NOT enforced by DB2 during SQL processing?A . CheckB . ReferentialC . Primary keyD . Informational referentialView AnswerAnswer: D Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0020149.html

Read more +

What will happen to Jeff’s SELECT privilege?

December 13, 2020PdfprepC2090-616IBM Certified Database Administrator, C2090-616 exam questions, C2090-616 practice exam

Consider the following sequence of events: Eddie grants SELECT WITH GRANT OPTION privilege to Mike. Mike grants SELECT privilege to Jeff. Eddie revokes SELECT privilege from Mike. What will happen to Jeff’s SELECT privilege?A...

Read more +

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

December 12, 2020PdfprepC2090-320IBM Certified Database Administrator, C2090-320 exam questions, C2090-320 practice exam

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?A . A viewB . A temporal tableC . A created global temporary tableD . A declared global...

Read more +

Which database object can be locked explicitly?

December 11, 2020PdfprepC2090-616C2090-616 practice exam, IBM Certified Database Administrator, C2090-616 exam questions

Which database object can be locked explicitly?A . RowB . ViewC . IndexD . TableView AnswerAnswer: D Explanation:https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html

Read more +

Which statement about NOT ENFORCED unique constraints is TRUE?

December 11, 2020PdfprepC2090-600C2090-600 exam questions, C2090-600 practice exam, IBM Certified Database Administrator

Which statement about NOT ENFORCED unique constraints is TRUE?A . NOT ENFORCED unique constraints can not be defined on primary key columnsB . The query optimizer will consider a NOT ENFORCED unique constraint when...

Read more +

Where does the DB2 Problem Determination tool (db2pd) get information from?

December 10, 2020PdfprepC2090-600C2090-600 exam questions, C2090-600 practice exam, IBM Certified Database Administrator

Where does the DB2 Problem Determination tool (db2pd) get information from?A . DB2memory setsB . the db2diag.log fileC . Monitoring table functionsD . A set of pre-defined event monitorsView AnswerAnswer: A

Read more +

Which of the following authorities are sufficient for creating a database? (Choose two.)

December 8, 2020PdfprepC2090-616C2090-616 exam questions, C2090-616 practice exam, IBM Certified Database Administrator

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

Read more +

Which of the following statements is TRUE?

December 8, 2020PdfprepC2090-320IBM Certified Database Administrator, C2090-320 exam questions, C2090-320 practice exam

Given the following SQL statement: GRANT DELETE ON TABLE customer TO user1; Which of the following statements is TRUE?A . User1 can only remove the customer tableB . User1 can only remove rows from...

Read more +

What will be the result if the user executes the following statement?

December 8, 2020PdfprepC2090-616IBM Certified Database Administrator, C2090-616 exam questions, C2090-616 practice exam

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 ....

Read more +