What is the minimum product required for DB2 connectivity across all platforms、

试卷相关题目

• 1Which object can be enabled for compression、

  A.View

  B.Buffer pool

  C.Storage group

  D.Temporary table

  开始考试点击查看答案
• 2Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency、

  A.CREATE DISTINCT ALIAS canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  B.CREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  C.CREATE DISTINCT PROCEDURE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  D.CREATE DISTINCT FUNCTION canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  开始考试点击查看答案
• 3Which type of table should you use if you want to define specific time periods when data is valid、

  A.Materialized query table

  B.System-period temporal table

  C.Declared global temporary table

  D.Application-period temporal table

  开始考试点击查看答案
• 4Which statement is valid about the Row and Column Access Control (RCAC) feature、

  A.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.

  B.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.

  C.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.

  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.

  开始考试点击查看答案
• 5Which of the following privileges allow a user to update the comment on a sequence、

  A.ALTER

  B.USAGE

  C.UPDATE

  D.COMMENT

  开始考试点击查看答案
• 6Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid、

  A.SALES can be the name of a schema.

  B.SALES can be the name of a package.

  C.SALES can be the name of an existing alias.

  D.SALES can be the name of a declared global temporary tabl

  开始考试点击查看答案
• 7Which DB2 object limits the user's ability to retrieve data from a table by defining a SQL statement in the object、

  A.View

  B.Index

  C.Trigger

  D.Check constraint

  开始考试点击查看答案
• 8A table named EMPLOYEES was created as follows:  CREATE TABLE employees(   emp_no       VARCHAR(4)  NOT NULL,   emp_name     VARCHAR(50) NOT NULL,   emp_email    VARCHAR(30) NOT NULL) Then,the following INSERT statements were executed:   INSERT INTO employees VALUES ('1A2B','Joe Smith','joe.smith@abc.com');   INSERT INTO employees VALUES ('1122','Lisa Carter','');   INSERT INTO employees VALUES ('1A2B','John Doe','john.doe@abc.com'); If the following query is executed:   SELECT count(*) FROM employees; What will be the results、

  A.0

  B.1

  C.2

  D.3

  开始考试点击查看答案
• 9Which two DB2 objects can a view be derived from、 (Choose two.)

  A.View

  B.Index

  C.Table

  D.Trigger

  E.Procedure

  开始考试点击查看答案
• 10Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction、

  A.Type-1 connect

  B.Type-2 connect

  C.Type-3 connect

  D.Type-4 connect

  开始考试点击查看答案