Killtest 分享HP0-A25 题库.pdfVIP

KillTest The safer , easier way to help you pass any IT exams. Exam : HP0-A25 Title : NonStop SQL/MX Version : Demo 1 / 4 The safer , easier way to help you pass any IT exams. 1.Who is allowed to add columns to a table? (Select two.) A. the SUPER.SUPER B. the owner of the table C. the owner ¯s gr op super D. the owner of the schema E. users that have been granted access Answer: A, D 2.Using the following DDL command: CREATE TABLE new_table LIKE old_table What can be specified for new_table? (Select two.) A. Format 1 or Format 2 B. indexes from old_table C. headings from old_table D. organization and primary key E. extent sizes and maximum extents Answer: C, E 3.A column definition includes DOB DATE HEADING ®Bi rt h Dat ¡¯. What is t he headi ng out put f SELECT MAX(DOB)? A. MAX(dob) B. Birth Date C. EXPR(dob) D. EXPR Answer: D 4.Which statements are true about AUDITCOMPRESS? (Select two.) A. The audit contains only altered columns. B. It has no effect on transaction throughput. C. It is part of the system ¯s T MF confi gur ati on D. It contributes to higher transaction throughput. E. Compression is performed by the audit disk process. Answer: A, D 5.When a table has the primary key defined as DROPPABLE, which statements are true? (Select two.) A. A SYSKEY is generated for the table. B. The STORE BY clause must be used. C. A DROPPABLE key can only be ascending. D. The primary key is used as the clustering key. E. A sepera