单选题You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Wh

题目
单选题
You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）
A

ALTER TABLE commercials MODIFY (description CHAR2(2000));

B

ALTER TABLE commercials CHANGE (description CHAR2(2000));

C

ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));

D

ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));

E

You cannot increase the size of a column if the table has rows.

相似考题

1.You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.

2.A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）A.SequenceB.Table FunctionC.Identity ColumnD.INSTEAD OF Trigger

3. You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）A、MERGEB、INSERTC、UPDATED、ADDE、ENTERF、You cannot enter the phone numbers for the existing employee records.

4.You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）A. MERGEB. INSERTC. UPDATED. ADDE. ENTERF. You cannot enter the phone numbers for the existing employee records.

更多“单选题You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Wh”相关问题

  • 第1题：

    You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?（）

    • A、ALTER TABLE commercials MODIFY (description CHAR2(1000));
    • B、ALTER TABLE commercials CHANGE (description CHAR2(1000));
    • C、ALTER TABLE commercials CHANGE (description VARCHAR2(1000));
    • D、ALTER TABLE commercials MODIFY (description VARCHAR2(1000));
    • E、You cannot increase the size of a column if the table has rows.

    正确答案:D

  • 第2题：

    You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）

    • A、Drop the table.
    • B、Partition the table
    • C、Truncate the table.
    • D、Add a column to the table.
    • E、Rename a column in the table.

    正确答案:D

  • 第3题：

    As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）

    • A、A leaf will be marked as invalid.
    • B、An update in a leaf row takes place.
    • C、The index will be updated automatically at commit.
    • D、A leaf row in the index will be deleted and inserted.
    • E、The index becomes invalid when you make any updates.

    正确答案:D

  • 第4题：

    You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）

    • A、After the query. 
    • B、Enter the report and change the column's position in the field tab. 
    • C、Alter the column's position in the object navigator. 
    • D、Enter the report wizard and change the column's position in the data tab. 
    • E、Alter the column's position within its group and change the layout. 

    正确答案:B

  • 第5题：

    You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows.Which statement is valid?（）

    • A、ALTER TABLE commercials MODIFY (description CHAR2(2000));
    • B、ALTER TABLE commercials CHANGE (description CHAR2(2000));
    • C、ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));
    • D、ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));
    • E、You cannot increase the size of a column if the table has rows.

    正确答案:D

  • 第6题：

    单选题
    A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）
    A

    Sequence

    B

    Table Function

    C

    Identity Column

    D

    INSTEAD OF Trigger


    正确答案： A
    解析： 暂无解析

  • 第7题：

    单选题
    You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）
    A

    Drop the table.

    B

    Partition the table

    C

    Truncate the table.

    D

    Add a column to the table.

    E

    Rename a column in the table.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）
    A

     Create an INSERT trigger to assign the default value to each item in the table. 

    B

     Create a CHECK constraint to validate the data and to assign the default value to each item in the table. 

    C

     Create an UPDATE trigger to update the default value for each new item in the table. 

    D

     Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）
    A

    Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.

    B

    Define the new column as NOT NULL with a default value of ’Undefined.’

    C

    Define the new column as NULL. Use application logic to enforce the data constraint.

    D

    Define the new column as NULL with a default value of ’Undefined.’


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）
    A

    ALTER TABLE commercials MODIFY (description CHAR2(2000));

    B

    ALTER TABLE commercials CHANGE (description CHAR2(2000));

    C

    ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));

    D

    ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));

    E

    You cannot increase the size of a column if the table has rows.


    正确答案： E
    解析： 暂无解析

  • 第11题：

    单选题
    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）
    A

    MERGE

    B

    INSERT

    C

    UPDATE

    D

    ADD

    E

    ENTER

    F

    You cannot enter the phone numbers for the existing employee records.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）
    A

    MERGE

    B

    INSERT

    C

    UPDATE

    D

    ADD

    E

    ENTER

    F

    You cannot enter the phone numbers for the existing employee records.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）

    • A、Sequence
    • B、Table Function
    • C、Identity Column
    • D、INSTEAD OF Trigger

    正确答案:A

  • 第14题：

    You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

    • A、 Drop the table.
    • B、 Partition the table.
    • C、 Truncate the table.
    • D、 Add a column to the table.
    • E、 Rename a column in the table.

    正确答案:D

  • 第15题：

    You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）

    • A、ALTER TABLE commercials MODIFY (description CHAR2(2000));
    • B、ALTER TABLE commercials CHANGE (description CHAR2(2000));
    • C、ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));
    • D、ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));
    • E、You cannot increase the size of a column if the table has rows.

    正确答案:D

  • 第16题：

    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

    • A、MERGE
    • B、INSERT
    • C、UPDATE
    • D、ADD
    • E、ENTER
    • F、You cannot enter the phone numbers for the existing employee records.

    正确答案:C

  • 第17题：

    You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）

    • A、Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
    • B、Define the new column as NOT NULL with a default value of ’Undefined.’
    • C、Define the new column as NULL. Use application logic to enforce the data constraint.
    • D、Define the new column as NULL with a default value of ’Undefined.’

    正确答案:B

  • 第18题：

    单选题
    You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）
    A

    After the query. 

    B

    Enter the report and change the column's position in the field tab. 

    C

    Alter the column's position in the object navigator. 

    D

    Enter the report wizard and change the column's position in the data tab. 

    E

    Alter the column's position within its group and change the layout. 


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）
    A

     Drop the table.

    B

     Partition the table.

    C

     Truncate the table.

    D

     Add a column to the table.

    E

     Rename a column in the table.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）
    A

    Rows 

    B

    Totals 

    C

    Columns 

    D

    Cells 

    E

    Data


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）
    A

    A leaf will be marked as invalid.

    B

    An update in a leaf row takes place.

    C

    The index will be updated automatically at commit.

    D

    A leaf row in the index will be deleted and inserted.

    E

    The index becomes invalid when you make any updates.


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?（）
    A

    ALTER TABLE commercials MODIFY (description CHAR2(1000));

    B

    ALTER TABLE commercials CHANGE (description CHAR2(1000));

    C

    ALTER TABLE commercials CHANGE (description VARCHAR2(1000));

    D

    ALTER TABLE commercials MODIFY (description VARCHAR2(1000));

    E

    You cannot increase the size of a column if the table has rows.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）
    A

    CLOB

    B

    BLOB

    C

    BFILE

    D

    LONG RAW


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）
    A

    ALTER TABLE commercials   MODIFY (description CHAR2(2000));

    B

    ALTER TABLE commercials   CHANGE (description CHAR2(2000));

    C

    ALTER TABLE commercials   CHANGE (description VARCHAR2(2000));

    D

    ALTER TABLE commercials   MODIFY (description VARCHAR2(2000));

    E

    You cannot increase the size of a column if the table has rows.


    正确答案： E
    解析： 暂无解析

相关内容