Which statement about bitemporal tables is valid、

试卷相关题目

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

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

  A.View

  B.Index

  C.Table

  D.Trigger

  E.Procedure

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

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

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

  开始考试点击查看答案
• 6Which object can a buffer pool be assigned to、

  A.Schema

  B.Table space

  C.Storage group

  D.Stored procedure

  开始考试点击查看答案
• 7Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions、

  A.View

  B.Table

  C.Sequence

  D.Identity Column

  开始考试点击查看答案
• 8What needs to be defined in order to track changes made to a system-period temporal table overtime、

  A.Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.

  B.A history table must be created with identical columns to the base table and a unique index must be defined on the transaction-start-id column.

  C.A history table must be created as a clone table of the base table after the row-begin, row-end, and transaction-start-id columns have beendefine

  D.B. A history table must be created with identical columns to the base table and a unique index must be defined on the transaction-start-id column.C. A history table must be created as a clone table of the base table after the row-begin, row-end, and transaction-start-id columns have beendefined.D. A history table must be created with identical columns to the base table and then the base table altered with the ADD VERSIONING clause torelate it to the history tabl

  开始考试点击查看答案
• 9Which object is used to cache table and index data as it is read from disk、

  A.Database

  B.Buffer pool

  C.Table space

  D.Package cache

  开始考试点击查看答案
• 10Which statement about large object (LOB) locators is true、

  A.A LOB locator is a data type that is used to store LOB data in binary files.

  B.A LOB locator is a data type that is used to store LOB data in a database.

  C.A LOB locator represents a value for a LOB resource that is stored in a database.

  D.A LOB locator represents a value for a LOB resource that is stored in a binary fil

  开始考试点击查看答案