Want to know Actualtests C2090-614 Exam practice test features? Want to lear more about IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) certification experience? Study Certified IBM C2090-614 answers to Renew C2090-614 questions at Actualtests. Gat a success with an absolute guarantee to pass IBM C2090-614 (DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614)) test on your first attempt.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-614 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-614 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-614-exam-dumps.html
Q51. The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?
A. CREATE INDEX sales_idx ON sales (region)
B. CREATE INDEX sales_idx ON sales (sales_person)
C. CREATE INDEX sales_idx ON sales (region, sales_person)
D. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)
Answer: C
Q52. Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?
A. Check constraints
B. Default constraints
C. Informational constraints
D. Referential integrity constraints
Answer: C
Q53. What type of file system is used to store data and logs in a DB2 pureScale environment?
A. Network File System (NFS)
B. General Parallel File System (GPFS)
C. Common Internet File System (CIFS)
D. Enhanced Journaled File System (JFS2 or EXT4)
Answer: B
Q54. In which situation would you NOT use a redirected restore?
A. To redefine the paths of a defined storage group.
B. To move table space containers onto different physical devices.
C. To restore a backup image from one operating system to another.
D. To restore a backup image to a target machine that is different from the source machine.
Answer: C
Q55. Which configuration parameter setting(s) are needed to force authentication to happen at the data source in a federated database environment?
A. FEDERATED set to YES
B. FEDERATED set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT
C. FEDERATED set to YES FED_NOAUTH set to YES
D. FEDERATED set to YES FED_NOAUTH set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT
Answer: D
Q56. If the AUDIT_BUF_SZ configuration parameter is set to zero (0), what will happen?
A. The audit facility writes records to disk at the same time the statements generating the audit records are executing.
B. Statements generating audit records must wait for the records to be written to disk before they can complete execution.
C. The writing of audit records to disk will be delayed until a minimum number of records (based on record size and memory available in the database heap) have been generated.
D. There is no limit to how many audit records can be stored in an internal memory buffer for one single statement generating audit records.
Answer: B
Q57. What is the FAILARCHPATH database configuration parameter used for?
A. To specify a path that DB2 will use to look for archive log files that are needed for a rollforward recovery operation.
B. To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.
C. To specify a path to which DB2 will attempt to store a copy of both active and archive log files to protect against disk failure and power outages.
D. To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a media problem.
Answer: D
Q58. Which Range-Clustered Tables (RCT) statement is correct?
A. Reverse scans on RCTs are not supported.
B. Clustering indexes are compatible with RCTs.
C. The Design Advisor can recommend the use of RCTs.
D. The IMPORT utility can be used with the REPLACE option to populate RCTs.
Answer: A
Q59. An auditor has requested that all activities performed by those with SYSADM or DBADM authority be tracked. How can this be done with the db2audit tool?
A. By creating a SYSADM ROLE and capturing SYSMAINT event records.
B. By creating an AUDIT POLICY and associating it with SYSADM and DBADM authority.
C. By creating a SYSADM ROLE and capturing SYSADMIN and CHECKING event records.
D. By creating a AUDIT POLICY and associating it with SYSMAINT, SYSADMIN and CHECKING event records.
Answer: B
Q60. The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for optimal query performance?
A. CREATE INDEX salary_bonus_idx ON employee (salary, bonus)
B. CREATE INDEX bonus_salary_idx ON employee (bonus, salary)
C. CREATE INDEX bonus_salary_idx ON employee (bonus, salary) CLUSTER
D. CREATE INDEX salary_bonus_idx ON employee (salary, bonus) CLUSTER
Answer: C