Given the following requirements:Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity column unique. Which of the following CREATE statements will successfully create this table?（）A、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))B、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTNO))C、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))D、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
Given the following requirements:Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity column unique. Which of the following CREATE statements will successfully create this table?（）
- A、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
- B、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTNO))
- C、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
- D、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
相关考题：
Your best customer calls in with a last-minute need for the BTU/HR or the heat output per server， per hour for a rack of x3650 servers. What IBM tool will you use to get your answer quickly？（）A、System x Sales Configuration Aid （xSCA）B、BladeCenter System x Power ConfiguratorC、Configuration Options Guide - （COG）D、IBM Sizing Guides
An administrator is investigating why a non-prompted NIM rte install is failing after the successful netboot of the spot. A matching spot and lpp_source are correctly allocated to the NIM client in addition to a bosinst_data. What is the most likely cause of the install failure?（）A、The bosinst_data has an incorrect console defined.B、The bosinst_data is incompatible with the level of spot.C、The bosinst_data has an incorrect disk location defined.D、The bosinst_data has an incorrect language option defined.
Which of the following can deploy system plans generated by the IBM System Planning Tool （SPT）？（）A、 The Hardware Management Console （HMC） and Integrated Virtualization Manager （IVM）.B、 The Hardware Management Console （HMC） and Advanced System Manager Interface （ASMI）.C、 Integrated Virtualization Manager （IVM） and Advanced System Manager Interface （ASMI）.D、 Integrated Virtualization Manager （IVM） and BladeCenter Advanced Management Module （AMM）.
Following a system boot， the display indicates that previously detected hardware is missing. Which of the following commands would identify the missing hardware（）A、diagB、IscfgC、cfgmgrD、Isslot
An architect is configuring a PowerHA cluster in the following way：The cluster will consist of two nodes. Each node will have two boot interfaces configured as a single PowerHA network. The cluster is to have asingle resource group with a single service address.Heartbeating over aliased is not to be used. What is the minimum number of subnets required to implement this cluster？（）A、1B、2C、3D、4
Which command should an administrator use to view files and volume group backup information from a mksysb called server1.mksysb that is found in /backups?（）A、lsmksysb -l /backups/server1.mksysbB、showmksysb -f /backups/server1.mksysbC、listvgbackup -f /backups/server1.mksysbD、showvgbackup -l /backups/server1.mksysb