题目内容

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

You need to load information about new customers from the NEW_CUST table into the tables CUST and CUST_SPECIAL. If a new customer has a credit limit greater than 10,000, then the details have to be inserted into CUST_SPECIAL. All new customer details have to be inserted into the CUST table. Which technique should be used to load the data most efficiently?

A. external table
B. the MERGE command
C. the multitable INSERT command
D. INSERT using WITH CHECK OPTION