Question

In an SQL query, which SQL keyword is used to specify the table(s) to be used?

a) EXISTS
b) FROM
c) SELECT
d) SET
e) WHERE

Answer 1

The SQL keyword used to specify the table(s) in a query is 'FROM'. This keyword is essential in SQL for indicating from which table the data should be retrieved or deleted.

Step-by-step explanation:

In an SQL query, the SQL keyword used to specify the table(s) to be used is b) FROM. The FROM clause is fundamental in SQL statements and appears in the SELECT statement.

It tells the database engine from which table to select or delete data. For example, in the query SELECT * FROM Students;, FROM indicates that data will be selected from the Students table.