- All Exams Instant Download
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) from EMPLOYEE table for those hired(hiredate) before 1965?
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) from EMPLOYEE table for those hired(hiredate) before 1965?A . B . C . D . View AnswerAnswer: D
If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?
Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?A . PAGEB . TABLEC . PARTITIOND . TABLESPACEView AnswerAnswer: C
In which address space would a native SQL stored procedure run?
In which address space would a native SQL stored procedure run?A . WLMB . DISTC . DBM1D . The address space of the calling programView AnswerAnswer: C Explanation: Reference: http://www.ibmbigdatahub.com/blog/db2-native-sql-procedures-future-computing
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) from EMPLOYEE table for those hired(hiredate) before 1965?
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) from EMPLOYEE table for those hired(hiredate) before 1965?A . B . C . D . View AnswerAnswer: D
Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?
The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?A . SELECT * FROM MYUSEB . EMP;C . CONNECT TO MYREMOTE; SELECT * FROM MYUSED . EMP;E...
Which single SQL statement will do this?
We want to increase the salary for each employee (EMP) in the department (WORKDEPT) D11 and we want to see the new salaries (SALARY) for each of them. Which single SQL statement will do this?A . B . C . D . View AnswerAnswer: D
Which of the following commands should be executed when starting a login shell in order to change the language of messages for an internationalized program to Portuguese (pt)?
Which of the following commands should be executed when starting a login shell in order to change the language of messages for an internationalized program to Portuguese (pt)?A . export LANGUAGE=“pt”B . export LC_MESSAGES=“pt”C . export UI_MESSAGES=“pt”D . export MESSAGE=“pt”E . export ALL_MESSAGES=“pt”View AnswerAnswer: B
Which catalog table provides information about the validity of a bound package?
Which catalog table provides information about the validity of a bound package?A . SYSIBB . SYSPACKLISTC . SYSIBD . SYSPACKAGEE . SYSIBF . SYSPACKDEPG . SYSIBH . SYSPACKAUTHView AnswerAnswer: A Explanation: Reference: https://books.google.com.pk/books?id=QH3JAgAAQBAJ&pg=PA256&lpg=PA256&dq=db2+11 +catalog+table+provides+information+about+the+validity+of+a+bound +package&source=bl&ots=4G_RwWpnUF&sig=Lm-LaNpt_SRiZcdhGxiX7ehVIfY&hl=en&sa=X&ved=0ahUKEwjLmPz66drZAhUO6aQKHW_2C9UQ6AEITjAF# v=onepage&q=db2%2011%20catalog%20table%20provides%20information%20about%20the%20validity %20of%20a%20bound%20package&f=false
Which of the following is TRUE for using LOAD on a partition-by-growth table space?
Which of the following is TRUE for using LOAD on a partition-by-growth table space?A . Data can only be loaded at the partition levelB . Data can only be loaded at the table space levelC . Data can only be loaded using a clustering indexD . Data can be loaded...
Which of the following statements about a system-period temporal table is TRUE?
Which of the following statements about a system-period temporal table is TRUE?A . Rows can be archived into a history table which is always read onlyB . Every row has a pair of timestamps which is set and managed by the applicationC . AN SQL query for auditing can be...
