Which of the following is an example of assigning "o" as a table alias for the ORDERS table in the FROM clause?
A) FROM o orders, c customers
B) FROM o.orders,
C) FROM orders o, customers c
D)customers
E) FROM orders.o, customers.c

Question

Quizplus · Accepted Answer

The correct way to assign an alias in the FROM clause is to list the alias followed by the actual table name. In this case, "o" is assigned as an alias for the ORDERS table in the FROM clause, and "c" is assigned as an alias for the CUSTOMERS table. Option A is incorrect because the table name "orders" is not preceded by the alias. Option B is incorrect because it uses dot notation, which is not valid in this context. Option D simply lists the table name without an alias. Option E uses dot notation and does not list an alias for the CUSTOMERS table.

Which of the Following Is an Example of Assigning "O