题目内容

Which of the following statements will not implicitly begin a transaction?

A. INSERT
B. UPDATE
C. DELETE
D. SELECT FOR UPDATE
E. None of the above, they all implicitly begin a transaction.

查看答案

搜索结果不匹配？点我反馈

更多问题

Consider the following query: SELECT dname, ename FROM dept d, emp a WHERE d.deptno=e.deptno ORDER BY dname, ename; What type of join is shown?

A. Self-join
B. Equijoin
C. Outer join
D. Non-equijoin

When using multiple tables to query information, in which clause do you specify the table names?

A. HAVING
B. GROUP BY
C. WHERE
D. FROM

Which two operators are not allowed when using an outer join between two tables? (10分)

A. OR
B. AND
C. IN
D. =

If you are selecting data from table A(with three rows) and table B(with four rows) using "select * from a,b", how many rows will be returned?

A. 7
B. 1
C. 0
D. 12