EMT Practice Test

1. Question Content...

---

Question1: In which address space would a native SQL stored procedure run?

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

Question3: Which statement is TRUE regarding ROLLBACK processing?

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

Question5: You want to limit the access of a table to allow users to only see certain columns and/or rows.
Which of the following options CANNOT be used to accomplish this?

Question6: Which types of user-defined data types are supported? (Choose two.)

Question7: Consider the following question: "What is the average salary by sex within education level?" An occasional uncommitted record can be tolerated in the average. Which of the following is the most appropriate isolation level for this?

Question8: Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

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

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

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

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

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

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

Question15: How can a stored procedure be invoked?

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

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

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

Question19: Which of the following is TRUE for using LOAD on a partition-by-growth table space?

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

Question21: Which of the following are contained in the PLAN_TABLE? (Choose two.)

Question22: A clone table can only be created in which of the following?

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

Question24: Which of the following can activate a trigger?

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

Question26: Which catalog tables are populated by RTS? (Choose two.)

Question27: The following definition for COL1 is given by this statement:
CREATE TABLE... (COL1 BINARY (05))
Which of the following statements will successfully insert data into the table?

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

Question29: 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;

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

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

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

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

Question34: Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?

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

Question36: You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?

Question37: Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?