The following statements: 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 T

题目

The following statements: 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, 'a'), (1, 'b'), (2,'c'); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300); 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
相似考题

1.All of the following statements define the role of a meeting chairperson except:A Initiates and concludes discussionB Controls irrelevant discussionC Resolves strong disagreementsD Produces meeting agendaE Consolidates agreements.

2.19 Which of the following statements about intangible assets in company financial statements are correct accordingto international accounting standards?1 Internally generated goodwill should not be capitalised.2 Purchased goodwill should normally be amortised through the income statement.3 Development expenditure must be capitalised if certain conditions are met.A 1 and 3 onlyB 1 and 2 onlyC 2 and 3 onlyD All three statements are correct

3.12 Which of the following statements are correct?(1) Contingent assets are included as assets in financial statements if it is probable that they will arise.(2) Contingent liabilities must be provided for in financial statements if it is probable that they will arise.(3) Details of all adjusting events after the balance sheet date must be given in notes to the financial statements.(4) Material non-adjusting events are disclosed by note in the financial statements.A 1 and 2B 2 and 4C 3 and 4D 1 and 3

4.Which of the following statements about Leopold and Rudolph Blaschka is TRUE?A. They were brothers.B. They were artists.C. They were florists.D. They were farmers.

更多“The following statements: CREAT”相关问题

  • 第1题：

    SQL命令中建立表的命令是______。

    A．CREAT VIEW

    B．CREAT LABEL

    C．CREAT DABATE

    D．CREAT TABLE


    正确答案：D

  • 第2题：

    Which of the following statements is NOT a way of consolidating vocabulary

    A.Defining.
    B.Matching.
    C.Gapfilling.
    D.Labeling.

    答案：A
    解析：
    考查词汇教学。

    下定义是呈现新词汇的方法，而不是巩固已学词汇的方法。故此题的正确选项为A。

    B、C、D均属于巩固词汇的方法。

    故此题的正确选项为A。

  • 第3题：

    Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）  

    • A、 The VERSIONS BETWEEN clause may be used in DML statements.
    • B、 The VERSIONS BETWEEN clause may be used in DDL statements.
    • C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
    • D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

    正确答案:C

  • 第4题：

    Several @functions can execute multiple statements. Which one of the following initializes a variable and can increment in during the operation?（）

    • A、 @do 
    • B、 @for 
    • C、 @while 
    • D、 @dowhile 

    正确答案:B

  • 第5题：

    建立表结构的SQL命令是（）

    • A、CREAT CURSOR
    • B、CREAT TABLE
    • C、CREAT INDEX
    • D、CREAT VIEW

    正确答案:B

  • 第6题：

    打开表单设计器窗口的命令是（）。

    • A、CREAT FORM
    • B、CREAT OBJECT
    • C、OPEN FORM
    • D、OPEN OBJECT

    正确答案:A

  • 第7题：

    多选题
    Concerning the figure below, if a =b, which of the following statements must be true? (Indicate all such statements.)
    A

    c=d

    B

    l and k are parallel

    C

    m and l are perpendicular


    正确答案： C,B
    解析：
    根据题目中的已知信息无法推断出各直线的关系，因此B、C均不正确；而由图示可知，c和d分别是a和b的补角，由于a=b，所以c=d，A项正确。

  • 第8题：

    单选题
    Several @functions can execute multiple statements. Which one of the following initializes a variable and can increment in during the operation?（）
    A

     @do 

    B

     @for 

    C

     @while 

    D

     @dowhile 


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

  • 第9题：

    单选题
    Which of the following statements is NOT a way of consolidating vocabulary?
    A

    Defining.

    B

    Matching.

    C

    Gap-filling.

    D

    Labeling.


    正确答案： D
    解析：

  • 第10题：

    单选题
    Most marine biological sewage treatment plants consist of all the following statements except （）.
    A

    aeration tanks

    B

    settling tanks

    C

    disinfection agent

    D

    anaerobic bacteria


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

  • 第11题：

    单选题
    Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）
    A

    12; only top-level statements and stored procedure events are logged

    B

    111; top-level statements and all lower-level statements are logged

    C

    3; only the top-level statements are logged

    D

    102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event


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

  • 第12题：

    单选题
    Which of the following statements describes the functions of a reservoir used in a hydraulic system?（）
    A

    Dissipate heat

    B

    Trap foreign matter

    C

    Separate air from the oil

    D

    All of the above


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

  • 第13题：

    Which of the following objects contains control structures that are considered the bound form of SQL statements?()

    A.UDT

    B.Trigger

    C.Package

    D.Access plan


    参考答案：C

  • 第14题：

    在Cisco路由器中增加用户的命令，错误的是（）。

    • A、creat user
    • B、adduser
    • C、useradd
    • D、user…password
    • E、user creat

    正确答案:A,B,C,E

  • 第15题：

    Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）

    • A、12; only top-level statements and stored procedure events are logged
    • B、111; top-level statements and all lower-level statements are logged
    • C、3; only the top-level statements are logged
    • D、102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event

    正确答案:C

  • 第16题：

    在SQL中，创建基本表用（）

    • A、CREAT SCHEMA命令
    • B、CREAT TABLE命令
    • C、CREAT INDEX命令
    • D、CREAT VIEW命令

    正确答案:B

  • 第17题：

    在SQL Server中，建表使用的命令是（）。

    • A、CREAT TABLE
    • B、CREAT SCHEMA
    • C、CREAT INDEX
    • D、CREAT VIEW

    正确答案:A

  • 第18题：

    多选题
    If p and q are primes greater than 2, which of the following statements must be true? (Indicate all such statements.)
    A

    p + q is even

    B

    pq is odd

    C

    p2-q2 is even


    正确答案： A,B
    解析：
    由于所有大于2的质数都是奇数，因此p和q均是奇数，两奇数相加为偶数，所以A项正确；两奇数的乘积还是奇数，所以B项正确；两奇数的平方还各自是奇数，而两奇数的平方之差是偶数，因此C项也正确；所以选择A、B、C三项。

  • 第19题：

    多选题
    Which of the following statements are true? (Indicate all such statements.)
    A

    τ(5) =τ(7)

    B

    τ(5) τ(7) =τ(35)

    C

    τ(5) + τ(7) =τ(12)


    正确答案： A,B
    解析：
    5和7均只有两个正除数，因此根据题干信息，A项正确；35有四个正除数，所以B项也是正确的；12有6个正除数，因此C项错误；选择A、B两项。

  • 第20题：

    单选题
    Which of the following statements is NOT a way of presenting new vocabulary? _____.
    A

    defining

    B

    using real objects

    C

    writing a passage by using new words

    D

    giving explanations


    正确答案： B
    解析：
    呈现新词汇的方法可以是下定义、实物展示、解释等。

  • 第21题：

    单选题
    For the following statements， which one is the strongest symmetrical encryption algorithm？（）
    A

    AES

    B

    3DES

    C

    DES

    D

    Diffie-Hellman


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

  • 第22题：

    单选题
    You execute the following command to enable a session in resumable mode：  SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60；  What is the impact of a timeout on the statements being suspended？（）
    A

     The statements remain suspended for at least 60 seconds.

    B

     The statements are suspended for 60 seconds and then they are executed.

    C

     The suspended statements error out if the problem is not rectified within 60 seconds.

    D

     The statements are automatically suspended 60 seconds after an error is received， and then attempt to execute normally again.


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

  • 第23题：

    单选题
    Which of the following statements is least likely to cause the ignition of fuel vapors?（）
    A

    Static electricity

    B

    An open running electric motor

    C

    Loose wiring

    D

    Explosion proof lights


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

  • 第24题：

    单选题
    Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
    A

     The VERSIONS BETWEEN clause may be used in DML statements.

    B

     The VERSIONS BETWEEN clause may be used in DDL statements.

    C

     The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

    D

     The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.


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

相关内容