Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency、

试卷相关题目

• 1Which 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

  开始考试点击查看答案
• 2Which 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.

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

  A.ALTER

  B.USAGE

  C.UPDATE

  D.COMMENT

  开始考试点击查看答案
• 4Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS that calls a package named CORPDAT

  A.PKGA、A. GRANT EXECUTE ON APPLICATION benefits TO user1

  B.GRANT EXECUTE ON PACKAGE corpdata.pkga TO user1

  C.GRANT EXECUTE ON APPLICATION PACKAGE corpdata.pkga TO user1

  D.GRANT EXECUTE ON APPLICATION benefits USING PACKAGE corpdata.pkga TO user1

  开始考试点击查看答案
• 5After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create apackage that is stored in the database so it will take advantage of the new indexes. Whichauthority/privilege must user USER1 be granted in order to re-create the package、

  A.BIND

  B.REBIND

  C.BINDADD

  D.BIND_REBIND

  开始考试点击查看答案
• 6Which object can be enabled for compression、

  A.View

  B.Buffer pool

  C.Storage group

  D.Temporary table

  开始考试点击查看答案
• 7What is the minimum product required for DB2 connectivity across all platforms、

  A.DB2 Personal Edition

  B.DB2 Development Edition

  C.DB2 Connect Personal Edition

  D.DB2 Development Unlimited Edition

  开始考试点击查看答案
• 8Given 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

  开始考试点击查看答案
• 9Which 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

  开始考试点击查看答案
• 10A 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

  开始考试点击查看答案