Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable?

• A.Implicit casting
• B.Double-dot notation
• C.Use of bitmap indexes
• D.Selecting from the DUAL table

Comment: *

Name: *

Email: *

Verification: *

What type of function is created using the following command?
CREATE FUNCTION TAN (X DOUBLE)
RETURNS DOUBLE
LANGUAGE SQL
CONTAINS SQL
NO EXTERNAL ACTION
DETERMINISTIC
RETURN SIN(X)/COS(X)

• A.Table
• B.External
• C.Row
• D.Scalar

Comment: *

Name: *

Email: *

Verification: *

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

• A.NOT NULL
• B.Foreign key
• C.Primary key
• D.Informational constraint

Comment: *

Name: *

Email: *

Verification: *