Online IBM DB2 Administrator Test to Assess Database Administrator

Topics Covered

SQL Scalar User-defined Functions

iMocha’s IBM DB2 test helps to evaluate candidate’s understanding about user-defines scalar functions which returns a single value of data of the type defined in the RETURNS clause

SQL Statements and Procedures

This assessment helps recruiters and hiring managers to evaluate candidate’s ability to use SQL statements to insert, update, drop, delete the database and procedures thar are reused under requirement

OLTP

Our IBM DB2 fundamentals test helps to evaluate candidate’s knowledge about Online Transaction Processing (OLTP) which is a type of data processing that executes number of transactions occurring concurrently

WorkloadQuery Tuner

This assessment helps to evaluate candidate’s knowledge about WorkloadQuery tuner which helps to optimize the performance of SQL statements

DB2 Objects

Our IBM DB2 test helps to evaluate candidate’s understanding about DB2 objects such as databases, tables, tablespaces, indexes, indexspaces, views, and storage groups that can be created or manipulated with SQL information

Sample Questions

Choose from our 100,000+ question library or add your own questions to make powerful custom tests

Question types:

Multiple Option

Topic:

-

Difficulty:

Easy

Q 1. In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?

Locked

Waiting

Pending

Unconnected

Question types:

Multiple Option

Topic:

-

Difficulty:

Easy

Q 2. Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?

SELECTjob, MIN(salary), MAX(salary)
FROM employee
GROUP BY job;

SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job;

SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job, MIN(salary), MAX(salary);

SELECT JOB, MIN(salary),MAX(salary)
FROM employee
ORDER BY job, MIN(salary), MAX(salary);

Question types:

Multiple Answer

Topic:

-

Difficulty:

Easy

Q 3. Which two operations are allowed in the body of an SQL scalar user-defined function?

Note: There can be multiple correct answers to this question.

CALL statements

External file access

Use of a scratch pad

COMMIT statements

SQL control statements

You can customize this test by

Setting difficulty level of test

Choose easy, medium or hard questions from our skill libraries to assess candidates of different experience levels.

Combining multiple skills into one test

Add multiple skills in a single test to create an effective assessment. Assess multiple skills together.

Adding your own questions to the test

Add, edit or bulk upload your own coding questions, MCQ, whiteboarding questions & more.

Requesting a tailor-made test

Get a tailored assessment created with the help of our subject matter experts to ensure effective screening.

Trusted By

“Siemens needed an employee review metric that was based on pure data, making it simpler for the hiring managers to evaluate their team. At the same time, we wanted the employees to be able to show case their domain knowledge and skills without the fear of any biases affecting their review process.”

Online IBM DB2 Fundamentals Test

27162+

128+

About Online IBM DB2 Fundamentals Test

Test Summary

Useful for hiring

Topics Covered

SQL Scalar User-defined Functions

SQL Statements and Procedures

OLTP

WorkloadQuery Tuner

DB2 Objects

Sample Questions

Sample Report

Hire job-fit candidates using this test now

You can customize this test by

Setting difficulty level of test

Combining multiple skills into one test

Adding your own questions to the test

Requesting a tailor-made test

Related Skills

Trusted By

Ajay Garg, Associate Manager, Siemens

Start hiring job-fit candidates using this assessment