000-610 무료 덤프문제 온라인 액세스

What is a function of a table check constraint?

• A.To provide a method of avoiding duplicate entries for a column.
• B.To provide a method of ensuring a column's values are within a specific range.
• C.To ensure that XML columns are properly populated in an associated XML table space.
• D.To enforce relationships between tables by checking the existence of rows in one table against another.

Which statement is valid about the Row and Column Access Control (RCAC) feature?

• A.A row permission's access control rule is defined by an SQL CASE expression; a column mask's access control rule is defined by an SQLsearch condition.
• B.A row mask's access control rule is defined by an SQL search condition; a column permission's access control rule is defined by an SQL CASEexpression.
• C.A row mask's access control rule is defined by an SQL CASE expression; a column permission's access control rule is defined by an SQLsearch condition.
• D.A row permission's access control rule is defined by an SQL search condition; a column mask's access control rule is defined by an SQL CASEexpression.

User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be done so in binary, regardless of the database collating sequence used. Which statement should user USER1 execute to create the desired table?

• A.CREATE TABLE parts
  (part_no INTEGER,
  desc VARCHAR(200) FOR BIT DATA)
• B.CREATE TABLE parts
  (part_no INTEGER,
  desc VARCHAR(200))
• C.CREATE TABLE parts
  (part_no INTEGER,
  desc CLOB FOR BIT DATA))
• D.CREATE TABLE parts
  (part_no INTEGER,
  desc CLOB))

Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?

• A.ALTER TABLE sales MODIFY COLUMN item CHAR(40);
• B.ALTER TABLE sales ADD COLUMN item CHAR(40);
• C.ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);
• D.ALTER TABLE sales ALTER COLUMN item CHAR(40);

Which type of constraint can be used to tell the DB2 Optimizer that a parent-child relationship exists between two tables, but that the relationship is not enforced?

• A.Informational
• B.Check
• C.Referential
• D.Unique