Reliable C1000-078 Dumps Questions Available as Web-Based Practice Test Engine
Correct and Up-to-date IBM C1000-078 BrainDumps
NEW QUESTION # 32
Which subsystem parameter specifies whether DB2 is to create new table spaces and indexes to use a basic or extended log record format?
- A. EXTSEC
- B. OBJECT_CREATE_FORMAT
- C. CHKLOGR
- D. UTILITY OBJECT CONVERSION
Answer: B
NEW QUESTION # 33
With which authority can you create, display, activate, or inactivate DB2 audit policies?
- A. SYSADM
- B. SYSCTRL
- C. SYSOPR
- D. SECADM
Answer: B
NEW QUESTION # 34
Az/OS system has some storage constraints. The results of-DIS
STATS(INDEXMEMORYUSAGE) shows that a huge amount of storage is used for the fast index traversal processes. What can be done to avoid this storage usage?
- A. Set subsystem parameter INDEX_MEMORY_CONTROL to DISABLE
- B. Issue SQL statement ALTER INDEX ixname REGENERATE USING APPLICATION COMPATIBILITY V12R1M500 for the listed indexes
- C. Reorganize the listed indexes
- D. Set subsystem parameter INDEX_CLEANUP_THREADS to 0
Answer: D
NEW QUESTION # 35
A down level page set is identified by the following error message:
DSNB232I UNEXPECTED DATA SET LEVEL ID ENCOUNTERED
Which of the following should be performed to correct the condition?
- A. Stop the object, set the DLDFREQ subsystem parameter to OFF. and then restart the object in RW status
- B. Replace the object with an appropriate data set at the proper level and confirm with DSN1PRNT of the header page
- C. Execute a REPAIR DBD REBUILD on the object
- D. Execute a REORG on the object in question
Answer: C
NEW QUESTION # 36
Which DB2 command is used to force a physical open of a table space, index space, or partition, or remove the GBP-dependent status for a table space, index space, or partition?
- A. -DISPLAY DATABASE
- B. -ACCESS DATABASE
- C. -START DATABASE
- D. -STOP DATABASE
Answer: B
Explanation:
The Db2 command ACCESS DATABASE forces a physical open of a table space, index space, or partition, or removes the GBP-dependent status for a table space, index space, or partition, or externalizes the real-time statistics and optimizer statistics recommendations from in-memory blocks to the appropriate catalog tables. The MODE keyword specifies the desired action.
NEW QUESTION # 37
Which subsystem parameter specifies the action that DB2 takes when a problem occurs with the resource limit specification table during execution of a local, static SQL statement?
- A. RLFERRDSTC
- B. RLFERRD
- C. RLFERR
- D. RLFERRSTC
Answer: A
NEW QUESTION # 38
Which of the following allows tracking of database administration tasks performed by system DBADMs?
- A. Start the appropriate accounting trace classes and analyze the SMF records
- B. Use the REPORT utility with option TABLESPACESET
- C. Use the DIAGNOSE utility with option TRACEID
- D. Define and start an appropriate audit policy in SYSIBM.SYSAUDITPOLICIES
Answer: C
NEW QUESTION # 39
Which of the following catalog or directory table spaces maintain their recovery information in the DB2 log?
- A. DSNDB06.SYSDDF
- B. DSNDB01.SYSSPT01
- C. DSNDB01.SYSUTILX
- D. DSNDB01.SYSLGRNX
Answer: C
NEW QUESTION # 40
During DB2 restart, it is observed that it takes a significant amount of time to complete. Which of the following could be tuned to improve restart time?
- A. Specify LBACKOUT=NO
- B. Specify LOCKSIZE ANY for DB2 objects
- C. Specify CURRENTDATA(YES)
- D. Reduce system checkpoint interval
Answer: D
NEW QUESTION # 41
Which of the following can be accomplished by altering a table to use column access control?
- A. Restrict the access to specific rows for all or some users
- B. Hide column definitions from the DB2 catalog table SYSIBM.SYSCOLUMNS
- C. Pre-materialize a view with the changed values provided by the column mask
- D. Modify the values returned for table columns based on column masking definitions
Answer: D
NEW QUESTION # 42
Which DB2 command is used to turn on the recording of CPU usage information for a package?
- A. -START DYNQUERYCAPTURE
- B. -START TRACE
- C. -START PROFILE
- D. -START RLIMIT
Answer: B
NEW QUESTION # 43
The amount of memory taken up by the local dynamic statement cache is extremely high. How can this be reduced?
- A. Reduce the value specified for subsystem parameter MAX_IN_MEMORY
- B. Reduce the value specified for subsystem parameter EDMSTMTC
- C. Reduce the value specified for subsystem parameter MAXKEEPD
- D. Bind more packages using BIND option KEEPDYNAMIC(YES)
Answer: D
NEW QUESTION # 44
Where is recovery information for table space DSNDB06.SYSTSCPY stored?
- A. Directory
- B. SYSIBM.SYSCOPY
- C. Log
- D. BSDS
Answer: D
NEW QUESTION # 45
One DB2 catalog page set is corrupt and needs to be recovered to current. Which of the following is TRUE?
- A. Only the corrupt page set needs to be recovered
- B. The catalog and directory always needs to be recovered as a whole in a certain order
- C. The catalog always needs to be recovered as a whole in a certain order
- D. The corrupt page set, and all of the page sets that are required prior to this, must be recovered in a certain order
Answer: C
NEW QUESTION # 46
To simulate a new buffer pool size, what buffer pool parameter is used?
- A. PGFIX
- B. VPSIZE
- C. AUTOSI2E
- D. SPSI2E
Answer: D
NEW QUESTION # 47
......
100% Reliable Microsoft C1000-078 Exam Dumps Test Pdf Exam Material: https://www.actualcollection.com/C1000-078-exam-questions.html
Current C1000-078 dumps Preparation through Our Practice Test: https://drive.google.com/open?id=1K0len8Tt-m7w9nBfdEwRc0ooyP50Fov5