Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used
to generate a compression dictionary for a table? (Choose two.)

A partitioned table named SALES was created as follows: Which statement about the
PARTS_IDX index is true?

An existing non-automatic storage database named MYDB has been successfully converted
to an automatic storage database. What must be done to convert any existing DMS table
spaces to automatic storage table spaces?

Which statement about BEFORE triggers is FALSE?

What are two purposes of the SET INTEGRITY statement? (Choose two.)

You want to modify an existing view so that any rows that are inserted or updated with the
view will not violate the SELECT statement that was used to create the view. What should
you do?

What is an informational constraint?

Given the following statement: How many constraints are present in the DEPARTMENT
table?

Which two server authentication methods are supported by transparent Lightweight
Directory Access Protocol (LDAP)? (Choose two.)

Which command is used to export connectivity configuration information from a file known
as a configuration profile?