Free IBM 000-N18 Practice Test & Real Exam Questions

Exam Code/Number: 000-N18
Exam Name/Title: IBM Information Management DB2 10 Technical Mastery Test v3
Certification Provider: IBM
Corresponding Certification: IBM Mastery

Exam Questions: 35
Updated On: Jun 11, 2026

Question #1

Which of the following is TRUE about PL/SQL support in DB2?

A. You can only execute PL/SQL statements using the CLPPIus interface.

B. DB2 requires third party software to execute PL/SQL statements.

C. PL/SQL support is only enabled when using federation to access other vendor databases.

D. The DB2 compiler can process PL/SQL statements and create the required objects in the database. The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.

Discussion 0

Correct Answer: D Vote an answer

Question #2

Which of the following options is TRUE about the Row and Column Access Control (RCAC) feature?

A. Row and column level access control allows the creation of column masks that can control what column values a user is permitted to see.

B. Table data is protected against direct access to the table. Access using views is unrestricted.

C. Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.

D. In order to take advantage of this feature, applications must be changed to work with the RCAC feature.

Discussion 0

Correct Answer: A Vote an answer

Question #3

What is the DB2 Load utility?

A. The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.

B. The DB2 Load utility is a tool that stores all scripts that are required to create the database. It does not load data, but just loads the database metadata that was exported for a site backup.

C. The DB2 Load utility can be used to load and create external functions in a DB2
database.

D. The DB2 Load utility is a tool that allows you to directly transfer data and objects from another database into the one you are currently working with.

Discussion 0

Correct Answer: A Vote an answer

Question #4

What are some of the benefits of DB2 Express?

A. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.

B. DB2 Express is fastest and most powerful DB2 edition.

C. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.

D. DB2 Express is designed for development and testing. It is not used as a production database.

Discussion 0

Correct Answer: C Vote an answer

Download Free IBM 000-N18 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM 000-N18 exam.