Who is allowed to add columns to a table? (Select two.)

Using the following DDL command:
CREATE TABLE new_table LIKE old_table
What can be specified for new_table? (Select two.)

A column definition includes DOB DATE HEADING ‘Birth Date’. What is the heading output for
SELECT MAX(DOB)?

Which statements are true about AUDITCOMPRESS? (Select two.)

When a table has the primary key defined as DROPPABLE, which statements are true? (Select two.)

Which command reports the average free space in data blocks?

In SQL/MX syntax, for which database element is an explicit assigned character set supported?

How do you access the current data on the SQL/MP view $data.mycat.myview from mxci? (Select
two.)

Which statements are true about the location of the system catalog tables of the system \MYSYS?
(Select two.)

What is the correct definition of a column?