One habit separates steady candidates from stressed ones: they use small gaps in the day. With the online engine from ExamTorrent, 110 000-614 practice questions fit into the minutes you spend waiting or riding the bus.
IBM 000-614 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 10.1 Advanced DBA for Linux UNIX and Windows |
| Exam Number: | C2090-614 |
| Related Certifications: | IBM Certified Database Administrator - DB2 10.1 for Linux UNIX and Windows IBM Certified Database Associate - DB2 10.1 Fundamentals |
| Real Exam Qty: | 108 |
| Available Languages: | English |
| Exam Format: | Multiple choice |
| Sample Questions: |  |
| Exam Way: | Onsite testing via Pearson VUE or IBM authorized test centres |
| Pre Condition: | Recommended to have DB2 10.1 DBA experience and have passed foundational DB2 exams (C2090-610, C2090-611) |
| Official Syllabus URL: | https://www.ibm.com/training/certification/ibm-certified-database-administrator-db2-101-for-linux-unix-and-windows-08002107 |
IBM 000-614 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Database Design and Object Management | - Buffer pools, table spaces and data partitioning - Database object design and implementation |
| High Availability and Recovery | - High Availability Disaster Recovery (HADR) - Backup and recovery strategies and tools |
| Advanced Concepts | - Federated database systems - Advanced utilities and diagnostic tools |
| Performance and Scalability | - Performance monitoring and tuning - Query optimization and indexing |
Common Questions About IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows
Recommended to have DB2 10.1 DBA experience and have passed foundational DB2 exams (C2090-610, C2090-611)
The IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows bank is maintained by a team of IT specialists who research the 000-614 questions in depth and organize the verified answers into an effective study sequence. Their ongoing work is what keeps the material professional rather than generic.
- Performance and Scalability ()
- High Availability and Recovery ()
- Database Design and Object Management ()
Let the topic weights guide how you divide your study hours.
The online engine simulates the formal 000-614 test, lets you set your own time limit, and points out your mistakes after each session. Because it runs in a browser, you can practice anywhere and anytime, whether you are waiting for someone or sitting on a bus, and make real use of spare minutes.
The package includes 110 practice questions for the 000-614 exam, all verified by our IT specialists. A free demo is available so you can review the style before purchasing.
IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Sample Questions:
A database named TEST was created and two buffer pools named BP_GENERAL and BP_AUDITING were created as follows:
IBM 000-614 : Practice Test
The majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers thatThe majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers that would populate the table in table space TS2 each time changes were made to the database were then defined and the database was put into production.
At first, ad-hoc queries performing random I/O against the table in table space TS2 ran fine, but performance has gotten worse as the table has gotten larger. What should be done to improve query performance?
- A. Change the page size of the BP_AUDITING buffer pool to 16 or 32 K.
- B. Replace the BP_AUDITING buffer pool with a block-based buffer pool.
- C. Reduce the size of the BP_AUDITING buffer pool.
- D. Increase the size of the BP_AUDITING buffer pool.
Correct Answer: C 🗳️
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, sales_person)
- B. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)
- C. CREATE INDEX sales_idx ON sales (region)
- D. CREATE INDEX sales_idx ON sales (sales_person)
Correct Answer: A 🗳️
Which index(es) are created when a multidimensional clustering (MDC) table is defined with only one dimension?
- A. One composite clustering index and one dimension block index.
- B. One index that serves as both the dimension block index and the composite block index.
- C. One index that serves as both the dimension block index and the composite clustering index.
- D. One composite block index and one unique index.
Correct Answer: B 🗳️
Explanation: Only visible for ExamTorrent members. You can sign-up / login (it's free).
What is the FAILARCHPATH database configuration parameter used for?
- A. 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.
- B. To specify a path that DB2 will use to look for archive log files that are needed for a rollforward recovery operation.
- C. 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.
- D. To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.
Correct Answer: C 🗳️
Which statement about dropped table recovery is correct?
- A. By default, the DROPPED TABLE RECOVERY option is off when a new table space is created.
- B. The dropped table recovery feature lets you recover only dropped table data with a database-level restore operation.
- C. Multiple dropped tables can be recovered with a single table space-level restore operation.
- D. For a dropped table to be recoverable, the table space in which the table resides must have the DROPPED TABLE RECOVERY option turned on.
Correct Answer: D 🗳️
Viewing page 1 out of 22 pages.
Viewing questions 1-5 out of 110 questions.
0 Customer Reviews
