单项选择题

Which of the following is a feature of a unit of work?（）

A.It applies to a single data server.
B.It is a recoverable sequence of operations.
C.Its value can be queried from the system catalog tables.
D.It begins when the application connects to the data server.

点击查看答案

上一题目录下一题

相关考题

单项选择题

Given the following table definitions:
EMPLOYEE
ID NAME DEPTID
01Smith 10
02Bossy 20
03 20
Peterson
04Goss 30
05Pape 40
06Avery 50
07O'Neal 60
08Carter 50
DEPARTMENT ID DEPTNAME
05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4
Which of the following queries will produce the same result set as the query above?（）

A.SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4
B.SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4
C.SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4
D.SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4

单项选择题

Which of the following will DELETE all of the rows from table T03?（）

A.DELETE * FROM TABLE T03
B.DELETE ALL FROM T03
C.DELETE * FROM T03
D.DELETE FROM T03

单项选择题

Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）

A.SORT BY age ASC, last_name
B.SORT BY age DESC, last_name
C.ORDER BY age DESC, last_name
D.ORDER BY age ASC, last_name