网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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、4B、3C、1D、0” 相关考题
考题
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.
考题
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.
考题
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
考题
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
考题
Which of the following objects contains control structures that are considered the bound form of SQL statements?()
A.UDTB.TriggerC.PackageD.Access plan
考题
Which of the following statements is NOT a way of consolidating vocabulary A.Defining.
B.Matching.
C.Gapfilling.
D.Labeling.
考题
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.
考题
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 loggedB、111; top-level statements and all lower-level statements are loggedC、3; only the top-level statements are loggedD、102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
考题
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
考题
多选题If p and q are primes greater than 2, which of the following statements must be true? (Indicate all such statements.)Ap + q is evenBpq is oddCp2-q2 is even
考题
多选题Concerning the figure below, if a =b, which of the following statements must be true? (Indicate all such statements.)Ac=dBl and k are parallelCm and l are perpendicular
考题
多选题Which of the following statements are true? (Indicate all such statements.)Aτ(5) =τ(7)Bτ(5) τ(7) =τ(35)Cτ(5) + τ(7) =τ(12)
考题
单选题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
考题
单选题Which of the following statements is NOT a way of presenting new vocabulary? _____.A
definingB
using real objectsC
writing a passage by using new wordsD
giving explanations
考题
单选题Which of the following statements is NOT a way of consolidating vocabulary?A
Defining.B
Matching.C
Gap-filling.D
Labeling.
考题
单选题For the following statements， which one is the strongest symmetrical encryption algorithm？（）A
AESB
3DESC
DESD
Diffie-Hellman
考题
单选题Most marine biological sewage treatment plants consist of all the following statements except （）.A
aeration tanksB
settling tanksC
disinfection agentD
anaerobic bacteria
考题
单选题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.
考题
单选题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 loggedB
111; top-level statements and all lower-level statements are loggedC
3; only the top-level statements are loggedD
102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
考题
单选题Which of the following statements is least likely to cause the ignition of fuel vapors?（）A
Static electricityB
An open running electric motorC
Loose wiringD
Explosion proof lights
考题
单选题Which of the following statements describes the functions of a reservoir used in a hydraulic system?（）A
Dissipate heatB
Trap foreign matterC
Separate air from the oilD
All of the above
考题
单选题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.
热门标签
最新试卷