Which of the following can activate a trigger?
Which of the following can activate a trigger?A . A row is insertedB . A table or view is createdC . A check constraint is definedD . A referential constraint is violatedView AnswerAnswer: D...
What access path does this represent?
January 22, 2021PdfprepC2090-320IBM Certified Database Administrator, C2090-320 exam questions, C2090-320 practice exam
Pdfprep2021-01-22T20:17:45+00:00An application program is running much longer than expected. The PLAN_TABLE shows the following access path information: ACCESSTYPE = ‘R’ PREFETCH = ‘S’ What access path does this represent?A . IN-list accessB . Direct...
If a scrollable cursor is INSENSITIVE, which of the following applies?
January 20, 2021PdfprepC2090-320IBM Certified Database Administrator, C2090-320 exam questions, C2090-320 practice exam
Pdfprep2021-01-20T01:19:18+00:00If a scrollable cursor is INSENSITIVE, which of the following applies?A . The cursor is read onlyB . WITH ROWSET POSITIONING is not allowedC . The select-statement must not contain an SQL data change...
Which statement about an application-period temporal table is TRUE?
January 19, 2021PdfprepC2090-320IBM Certified Database Administrator, C2090-320 exam questions, C2090-320 practice exam
Pdfprep2021-01-19T02:35:25+00:00Which statement about an application-period temporal table is TRUE?A . It has SYSTEM_TIME definedB . It has an end column defined using WITH DEFAULT NULLC . It must have the index clause BUSINESS_TIME WITHOUT...
Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?
January 17, 2021PdfprepC2090-320IBM Certified Database Administrator, C2090-320 exam questions, C2090-320 practice exam
Pdfprep2021-01-17T13:01:00+00:00Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?A . TRUNCATE employee;B . DELETE FROM employee;C...
If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?
January 13, 2021PdfprepC2090-320IBM Certified Database Administrator, C2090-320 exam questions, C2090-320 practice exam
Pdfprep2021-01-13T22:57:33+00:00Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to...
In a unique referential constraint, which type of key does a foreign key reference?
January 13, 2021PdfprepC2090-320C2090-320 exam questions, C2090-320 practice exam, IBM Certified Database Administrator
Pdfprep2021-01-13T19:40:17+00:00In 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 statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?
January 13, 2021PdfprepC2090-320C2090-320 practice exam, IBM Certified Database Administrator, C2090-320 exam questions
Pdfprep2021-01-13T07:49:36+00:00Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?A . All held LOB locators are retainedB . All locks that are implicitly acquired during the unit of recovery...
What is the command to potentially change the access path for a static package?
January 12, 2021PdfprepC2090-320IBM Certified Database Administrator, C2090-320 exam questions, C2090-320 practice exam
Pdfprep2021-01-12T01:33:00+00:00You have created a new index. What is the command to potentially change the access path for a static package?A . FREEB . RESETC . REBINDD . REFRESHView AnswerAnswer: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/perf/src/tpc/ db2z_influenceaccesspaths.html
Which DB2 command displays the status information about DB2 database MYDB and displays the status of all objects in this database?
January 9, 2021PdfprepC2090-320C2090-320 exam questions, C2090-320 practice exam, IBM Certified Database Administrator
Pdfprep2021-01-09T11:24:04+00:00Which DB2 command displays the status information about DB2 database MYDB and displays the status of all objects in this database?A . CDISPLAY DATABASE(MYDB) OVERVIEWB . CDISPLAY DATABASE(MYDB) SPACENAM(*)C . CDISPLAY DATABASE(MYDB) SPACENAM(*) RESD...