Multiple Choice
The syntax for a left outer join is .
A) SELECT column-list FROM table1 OUTER JOIN table2 LEFT
WHERE join-condition
B) SELECT column-list FROM table1 LEFT [OUTER] JOIN table2
ON join-condition
C) SELECT column-list WHERE LEFT table1 = table 2
D) SELECT column-list FROM table1 LEFT table2 [JOIN]
WHERE join-condition
Correct Answer:

Verified
Correct Answer:
Verified
Q1: The syntax of the DECODE function starts
Q2: The statement SELECT * FROM T1,T2 produces
Q3: A(n) _ view is a view that
Q4: Subqueries cannot be used in combinations with
Q29: BEFORE means before the changes are made
Q32: The Oracle _ function compares an attribute
Q32: Automating business procedures and automatically maintaining data
Q37: When using the Oracle TO_DATE function, the
Q54: One of the major advantages of stored
Q59: In MS Access, a designer can use