Given the following CREATE TABLE statement:
CREATE TABLE applicant (id INTEGER NOT NULL PRIMARY KEY,
lastname VARCHAR(50));
Which SQL statement will execute successfully?

Which two data types can be in-lined to enhance compression? ( Choose two.)

Given a table that is already compressed, if you create a new index on
that table, when will the index be compressed?

Refer to the Exhibit.

Refer to the exhibit for information on how tables TABA and TABB were created.
What would be the number of extents allocated for each table after the successful creation of both
tables?

Which two tools can create a compression dictionary? (Choose two.)

Which statement is true about using the EXPORT utility with a table that contains XML data?

When using table partitioning, which three operations are valid? (Choose three.)

You are asked to create a new database called PRODDB where no privileges will be automatically
granted to PUBLIC
Which CREATE statement will accomplish this?

Which three commands will apply the specified action to all objects in schema PAY1 in database
PRODDB? (Choose three.)

Which SQL statement will execute successfully?