When is it appropriate to use a sequence、

试卷相关题目

• 1Which DB2 object can be used to improve the execution performance of qualified SELECT statements、

  A.Trigger

  B.SQL Procedure

  C.Sequence Object

  D.Materialized Query Table

  开始考试点击查看答案
• 2Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes toincrease the size of the ITEM column, which SQL statement needs to be used、

  A.ALTER TABLE sales ADD COLUMN item CHAR(40);

  B.ALTER TABLE sales ALTER COLUMN item CHAR(40);

  C.ALTER TABLE sales MODIFY COLUMN item CHAR(40);

  D.ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);

  开始考试点击查看答案
• 3If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database、

  A.4

  B.8

  C.16

  D.32

  开始考试点击查看答案
• 4Which clause should be included in a ALTER TABLE statement to update a table definition with a new column、

  A.ADD COLUMN

  B.ALTER COLUMN

  C.APPEND COLUMN

  D.RENAME COLUMN

  开始考试点击查看答案
• 5Which object is a stored procedure defined into、

  A.Table

  B.Schema

  C.Package

  D.Database

  开始考试点击查看答案
• 6Which action needs to be performed in order to complete the definition of an application-period temporal table、

  A.A transaction-start-id column must be defined for the table.

  B.A history table must be defined and associated with the base table.

  C.A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.

  D.A unique index must be created that prevents overlapping of the BUSINESS_TIME period of the tabl

  开始考试点击查看答案
• 7What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view、

  A.Oracle connect

  B.Trusted context

  C.Oracle federation

  D.Distributed request

  开始考试点击查看答案
• 8You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal、

  A.CLI

  B.XML

  C.JDBC

  D.RUBY

  开始考试点击查看答案