which of the following defines the data types for the columns in the DB2 physical table?
When modeling data to provide for a physical design, which of the following defines the data types
for the columns in the DB2 physical table?
Which statement is correct?
A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?
Which statement about encoding schemes is correct?
Which statement about encoding schemes is correct?
Why does the following DDL command fail?
Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3,
BUSINESS_TIME WITHOUT_OVERLAPS);
which situation does adding a referential constraint place a table space containing data into check-pending st
In which situation does adding a referential constraint place a table space containing data into
check-pending status?
Which steps should be performed at a minimum to make it a partitioned-by-range table space?
Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a
minimum to make it a partitioned-by-range table space?
Which of the following types of table spaces allow multiple tables?
Which of the following types of table spaces allow multiple tables?
Which of the following tasks cannot be done via a single ALTER TABLE statement?
Which of the following tasks cannot be done via a single ALTER TABLE statement?
Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of employees who
Click on the exhibit to view properly coded XML data. Some employees have been assigned
assistants. Which two are the leanest, most efficient XML indexes to get both the names and
phone numbers of employees who are not assistants?
What is the one significant difference between sequence objects and identity columns?
What is the one significant difference between sequence objects and identity columns?