What is a subquery?a.A subquery is a condition that excludes all the invalid tuples from the databaseb.A subquery is a relation that is externally specified which can be used to handle data in queriesc.A subquery is a select-from-where expression that is nested within another queryd.A subquery is any query that is nested within another query

When you have a query inside of another query, the term “subquery” refers to which query?1 pointInnerOuter

Which one is not a type of subquery ?

What is a correlated sub-query?Select one:a.A sub-query that substitutes the names of the outer queryb.A sub-query that uses the correlation name of an outer queryc.A sub-query that does not depend on its outer query’s correlation namesd.An independent query that uses the correlation name of another independent query.

What are the benefits of using subqueries in SQL? Select all that apply.1 pointSubqueries can simplify complex queries.Subqueries can improve code readability.Subqueries can replace complex joins in some cases.Subqueries can be used to filter data based on results from another table.

What is true about co-related sub-queries?The tables used in the main query are also used in a co-related sub-queryThe sub-queries which reference a column used in the main query are called co-related sub-queriesThe sub-queries which are written without parenthesis are called co-related sub-queriesThe sub-queries which mandatorily use different tables than those used in the main query are called co-related sub-queries