Which of the following can be defined on the basis of a query?
Assuming column hire date is a DATE data type, which SQL statement will retrieve the maximum salary (salary) and minimum salary(salary) for each job(job) fromEMPLOYEE table for those hired(hiredate) before 1965?A.B.C.D.
In order to run a DB2 program, the user issues the following commands:TSO prompt: READY -USER enters: DSN SYS(SSTR)USER enters: RUN PROGRAM(MYPROG)USER enters: END -What is the result?
Which of the following describes OLTP workload rather than an analytics workload?
Given the tables:Which SQL statement would join the tables on product number (prod#) and provide a table of what products (product), if any, the parts (part) are used? Limit the result to only parts where suppliers (supplier) do not start with the letter A.A.B.C.D.
Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)
