搜题
用户您好, 请在下方输入框内搜索其它题目:
搜题
题目内容 (请给出正确答案)
提问人:网友 发布时间:
【单选题】

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?()”相关的问题
第2题

A、A. This command is applied to the core router facing interface.  B、B. This command is applied to the customer facing interface.  C、C. The 4 is locally significant and identifies the layer 2 circuit.  D、D. The 4 must match exactly on the peer router configuration on the remote end.  

点击查看答案
第5题

A、A.Compilation fails.  B、B.Nothing is added to the file system.  C、C.Only a new file is created on the file system.  D、D.Only a new directory is created on the file system.  E、E.Both a new file and a new directory are created on the file system.  

点击查看答案
第6题

A、Increase the size of rootvg.  B、Delete unnecessary files in the / (root) file system.  C、Edit /etc/inittab and correct any erroneous entries.  D、Run fsck on the rootvg and recreate the log device with the following command: /usr/sbin/logform /dev/hd8.  

点击查看答案
第7题

A、The route does not match this policy.  B、The route is accepted.  C、The route is rejected.  D、The route is accepted with a metric of 6.  

点击查看答案
第10题

A、config  B、clientqos.cnf  C、startup-config  D、running-configuration  

点击查看答案
客服
TOP

请使用微信扫码支付

订单号:
遇到问题请联系在线客服