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

The following statements:<br /> CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, &#39;a&#39;), (1, &#39;b&#39;), (2,&#39;c&#39;); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);<br /> How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1= 1;()

A、4

B、3

C、1

D、0

更多“ The following statements:<br /> CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, &#39;a&#39;), (1, &#39;b&#39;), (2,&#39;c&#39;); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);<br /> How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1= 1;()”相关的问题
第1题

A、Removing a fileset update leaving the base fileset  B、Removing a base fileset in the BROKEN state  C、Removing a base fileset in the COMMITTED state and all fileset updates in the APPLIED stat  D、Removing a base fileset in the COMMITTED state and all fileset updates in the COMMITTED state  

点击查看答案
第3题

A、Run the following command: ntbackup.exe backup /F {"FileName"}  B、Run the following command: ntbackup.exe backup systemstate /F {"FileName"}  C、In Control Panel, open System, and configure the Startup and Recovery settings on the Advanced tab.  D、Use NTBackup interactively.  

点击查看答案
第4题

A、Run the following command: ntbackup.exe backup /F {"FileName"}  B、Run the following command: ntbackup.exe backup systemstate /F {"FileName"}  C、In Control Panel, open System, and configure the Startup and Recovery settings on the Advanced tab.  D、Use NTBackup interactively.  

点击查看答案
第5题

A、Load all updates in the commit state  B、Load all updates in the applied state until tested  C、Perform all software updates in maintenance mode  D、Use the Force Overwrite option for filesets that are already committed.  

点击查看答案
第6题

A、to make the United States gain time to arm itself  B、to actually help the aggressors by making clear that the United States would not intervene  C、to get the United States involved in the war  D、to prevent the United States form being dragged into the war  

点击查看答案
第7题

A、 an edge port that transitions to the forwarding state  B、 a non-edge port that transitions to the blocking state  C、 a non-edge port that transitions to the forwarding state  D、 an edge port that transitions to the blocking state  E、 any port that transitions to the blocking state  F、 any port that transitions to the forwarding state  

点击查看答案
客服
TOP

请使用微信扫码支付

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