Home > Databases > Quizzes > DB2 Administration Fundamentals Test
DB2 Administration Fundamentals Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 30% • Most missed: “What is an example of an environmental consideration in DB2 administration?”
DB2 Administration Fundamentals Test
Time left 00:00
25 Questions

1. What is the parameter to configure the default database path?
2. To prepare an embedded SQL program for use with a host-language compiler - which of the following database components is required?
3. Why would you want to specify an optimization class when compiling an SQL query?
4. Which of the following is a parameter that would specify the maximum size of a memory segment?
5. What is a federated database?
6. What object types is the lock mode S (Share) applicable to?
7. What does it mean if the the null indicator = 0
8. Why is a primary key needed on a table?
9. What condition would lead to distribution statistics not being collected?
10. Which of the following DB2 objects allows multiple users to access data in a table with each user only being able to access certain portions of the data?
11. Which of the following can be done by a user who is granted the CONTROL privilege on an INDEX?
12. I have 5 SQL Select statements connected by a Union/Union All. How many times should I have to specificy union to eliminate duplicate rows?
13. What is a scenario in which you would be using a single buffer pool?
14. If you have a poorly clustered index with random synchronous I/Ss - what clause would you use to prevent an impending delay?
15. What type of parameter is -œdbheap-?
16. What is one way that a query might be rewritten?
17. In a UNIX-based environment - where would the database manager configuration file be found?
18. Which of the following must be set to restrict clients from being able to discover any DB2 instances on a server?
19. A DBA needs to use the DSN command processor to delete DB2 packages that are no longer needed. Which of the following choices is correct for the DBA to use?
20. Which of the following is not a statistic collected during RUNSTATS
21. Which of the following DSNZPARMs is necessary to influence access path selection for certain queries?
22. Is the autorestart parameter configurable on-line?
23. Which two of the following identify which users have SYSCTRL authority?
24. Is the parameter - -œdatabase_memory- configured automatically?
25. Which two of the following types of storage management methods are supported by DB2 OLAP Server?

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.