Mainframe For Dummies

Exam Name: IBM DB2 UDB V8.1 Database Administration Exam Code: 000-701 Question: 1 Given the following command Create database payroll alias paynew on path/drive Using codeset codesst Territory territory Collate using identity How is character data compared within the database? A. Byte for byte B. Based on the codest C. Based on the codepage D. Based on the territory Answer: A Question: 2 Given the following statement Drop table payroll. Employee" Returns the following message. Solo55in "user" does not have the priviege to perform operation "drop" on object "pavroll. Employee." Sqlstate=42501 Which of the following will correct the situation? A. GRANT DROP AUTHORITY TO user1 B. GRANT DROPIN ON SCHEMA user1 TO user1 C. GRANT DROPIN ON SCHEMA payroll TO user1 D. GRANT DROPIN ON SCHEMA employee TO user1 Answer: C Question: 3 Which of the following is required to support infinite active log space? A. USEREXIT = ON, LOGSECOND = 0 B. USEREXIT = ON, LOGSECON