Question

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.customers
c. FROM orders o, customers c
d. FROM orders.o, customers.c

Answer 1

The correct example of assigning 'o' as a table alias for the ORDERS table in the FROM clause is option c. FROM orders o, customers c.

Step-by-step explanation:

The correct example of assigning "o" as a table alias for the ORDERS table in the FROM clause is option c. FROM orders o, customers c.

When using a table alias, the table name is given a shorter name to make the SQL code more concise and easier to read. In this case, "o" is used as the alias for the ORDERS table.

For example, you can write a SQL query like:

SELECT o.order_id, c.customer_name
FROM orders o, customers c
WHERE o.customer_id = c.customer_id;