Question

____ is used to retrieve records that do not meet the join condition select one:

Answer 1

SQL view is used to retrieve records that do not meet the join condition.

• View command is used for security purposes  as it displays only selected commands.
• Here the data is stored in the form of virtual table which is not permanently stored.
• It enhances the security mechanism of a database.
• The main use of view command is to provide encapsulation to the table names.