Given that t1 is a reference to a live thread, which is true?（）..

第1题

[] Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（） Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）

A、A.SELECT * FROM T1 MINUS SELECT * FROM T2 B、B.SELECT * FROM T1 EXCEPT SELECT * FROM T2 C、C.SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1 D、D.SELECT * FROM T1 NOT EXISTS SELECT * FROM T2

点击查看答案

第2题

[单选题] Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?（）

A、SELECT * FROM t1 UNION SELECT * FROM t2 B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2 C、SELECT * FROM t1 INTERSECT SELECT * FROM t2 D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)

点击查看答案

第3题

[单选题] Given: What is the result?（）

A、r，t，t， B、r，e，o， C、Compilation fails. D、An exception is thrown at runtime.

点击查看答案

第4题

[单选题] Given that t1 is a reference to a live thread， which is true？（）

A、The Thread.sleep（） method can take t1 as an argument. B、The Object.notify（） method can take t1 as an argument. C、The Thread.yield（） method can take t1 as an argument. D、The Thread.setPriority（） method can take t1 as an argument. E、The Object.notify（） method arbitrarily chooses which thread to notify.

点击查看答案

第5题

[单选题] Given that t1 is a reference to a live thread， which is true？（）

A、The Thread.sleep（） method can take t1 as an argument. B、The Object.notify（） method can take t1 as an argument. C、The Thread.yield（） method can take t1 as an argument. D、The Thread.setPriority（） method can take t1 as an argument. E、The Object.notify（） method arbitrarily chooses which thread to notify.

点击查看答案

第6题

[] Given that the current directory is empty, and that the user has read and write privileges to the current, and the following: Which statement is true?（） Given that the current directory is empty, and that the user has read and write privileges to the current, and the following: Which statement is true?（）

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.

点击查看答案

第7题

[单选题] Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）

A、SELECT * FROM t1 UNION SELECT * FROM t2 B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2 C、SELECT * FROM t1 INTERSECT SELECT * FROM t2 D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)

点击查看答案

第8题

[单选题] A notice of readiness is not valid unless it indicates that the vessel is ready to load or discharge as the case may be，at the time（）it is given.

A、when B、which C、that D、then

点击查看答案

第9题

[单选题] Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1

A、1, 2, 3, 3 B、1, 2, 2, 4 C、1, 2, 3, 3, 6 D、1, 2, 2, 5, 6

点击查看答案

Given that t1 is a reference to a live thread, which is true?（）

请使用微信扫码支付