What SQL feature can you use if you want to create a view that combines data from more than one table?
A) a join
B) a trigger
C) an index
D) a catalog

Question

Quizplus · Accepted Answer

SQL join is used to combine data from two or more tables, based on a related column between them. This is the best choice for creating a view that combines data from more than one table.

B) a trigger is not relevant in this scenario because triggers are used to automatically execute a set of statements based on certain events or conditions in a database.

C) an index is used to improve the performance of database searches, but it does not combine data from multiple tables.

D) a catalog is a collection of metadata that describes the objects in a database, but it does not directly combine data from multiple tables.

What SQL Feature Can You Use If You Want to Create