EMT Practice Test

1. Question Content...

---

Question1: Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed?
GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;

Question2: Which of the following describes OLTP workload rather than an analytics workload?

Question3: Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with "CREATE INDEX AAA ON...". Which of the following statements must precede the CREATE statement so that you can create the index?

Question4: Which of the following is a characteristic of a stand-alone utility?

Question5: 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?

Question6: Which package level privileges does the user smith have when the following statement is executed?
GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

Question7: Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?

Question8: Given the following table and index definitions, what type of index will be created?

Question9: You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?

Question10: 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.

Question11: Which of the following elements is affected by a ROLLBACK statement?

Question12: While DSN is running, which of the following commands CANNOT be successfully executed?

Question13: Which of the following actions can you take in order to prevent users from obtaining implicit privileges as a result of object ownership?

Question14: In a unique referential constraint, which type of key does a foreign key reference?

Question15: Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)

Question16: Which SQL statement can be used to provide diagnostic information about the last SQL statement that was executed?

Question17: Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?

Question18: Which of the following is NOT TRUE?

Question19: Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?

Question20: Which BIND option determines when DB2 will do authorization checking?

Question21: Which component of the program preparation produces a DBRM (Database request Module)?

Question22: How can a stored procedure be invoked?

Question23: 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?

Question24: Which of the following statements concerning a bi-temporal table is TRUE?

Question25: Which of the following can activate a trigger?

Question26: What is the result XQuery FLWOR expression when running the following scenario?

Question27: You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?

Question28: Consider the following scenario:
User1 creates table USER1.TABLE1 in DATABASE1
User1 grants ALL PRIVILEGES on TABLE1 to User2
User2 grants ALL PRIVILEGES on TABLE1 to User3
User1 revokes ALL PRIVILEGES on TABLE1 to User2
User3 has DBCTRL authority on DATABASE1
Is User3 able to retrieve rows from TABLE1?

Question29: Which authorizations can change the value of the subsystem parameter SYSADM using the -SET SYSPARM command? (Choose two.)

Question30: The maximum size for each partition of a partition-by-range table space, with fewer than
255 partitions, is determined by which combination of options? (Choose two.)

Question31: Which statement is TRUE regarding ROLLBACK processing?

Question32: COL1 is defined as CHAR(05) and contains CHAR('12345'). Which of the following expressions returns the digits 12345 for further calculation?

Question33: Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?

Question34: In the parent table of a referential constraint, a parent key must be which of the following?
(Choose two.)

Question35: Given the following INDEX definition, which attributes apply to this index? (Choose two.)