Online IBM DB2 Fundamentals Test
Topics Covered
- SQL Scalar User-defined Functions
- SQL Statements and Procedures
- OLTP WorkloadQuery Tuner
- DB2 Objects
Useful for hiring
- DB2 DBA
- Database Administrator
- DB2 Mainframe System Engineer
Start hiring job-fit candidates using this assessment
GET A DEMO
"Our recruitment team loves Interview Mocha especially for their skill assessments, simulators, and friendly support. Since using Interview Mocha, we interview only relevant candidates, and this has reduced our time to hire. Recruitment is no longer an hassle for us."
Question
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?
Answer
-
Locked
-
Waiting
-
Pending
-
Unconnected
Question
Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?
Answer
-
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
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.
Answer
-
CALL statements
-
External file access
-
Use of a scratch pad
-
COMMIT statements
-
SQL control statements
Good News! You can customize this test as per your requirement
Choose and add questions from Interview Mocha question libraries
Add your own set of questions
Customize test settings like duration, number of questions, passing score, web proctoring and much more
Mail us at support@interviewmocha.com to create a custom test
Looking for a tailor-made test, to suit your assessment needs?
Get in touchGlobal companies using Mocha assessments
How Mocha assessments are brewed
Speed up your IT recruitment with Interview Mocha
- 500+ IT skill tests
- 20+ coding languages
- 50+ domain knowledge tests
- 100+ digital 2.0 skill tests
- Customer focus aptitude tests
- Enterprise ready features & more...
Related Tests
Why hiring managers and recruiters across the globe love Interview Mocha
1000+ Ready Skills
Largest number of ready pre-employment skill tests
Subject Matter Experts
Relevant test compositions and quality questions designed by Subject Matter Experts
Tailor-made tests
Fastest custom tests creation to suit the job description
Super Easy to Use
World’s most easy to use skill assessment platform
Secure & Robust
High level of platform security implementation
Powerful Reports
Intuitive reports & advanced analytics to make informed hiring decisions
Smart Question Types
Simulators & Innovative logic box to remove guess-work from hiring
Team collaboration
Easy sharing of reports amongst the hiring team & recruiters
Take your first step to hire job fit candidates
