Query can be use to select data from A. Single Table B. Multiple Tables C. Both A & B D. None of above

Single Table
Multiple Tables
Both A & B
None of above

The correct answer is C. Both A & B.

A query is a statement that is used to retrieve data from a database. Queries can be used to select data from a single table or from multiple tables. When a query is executed, the database engine will return the results of the query to the user.

To select data from a single table, the query must specify the table name and the columns that you want to retrieve. For example, the following query will select all of the rows from the Customers table:

SELECT * FROM Customers;

To select data from multiple tables, the query must specify the tables that you want to join and the columns that you want to join on. For example, the following query will select all of the rows from the Customers table and the Orders table where the CustomerID column in the Customers table is equal to the CustomerID column in the Orders table:

SELECT * FROM Customers
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

I hope this helps!

Exit mobile version