You can code views that ? (a) join tables (b) summarize data (c)use subqueries a

Question

You can code views that ?

(a) join tables

(b) summarize data

(c)use subqueries and functions

(d) all of the above

The SELECT statement for a view:

(a) can’t use an ORDER BY clause

(b) can include the INTO keyword

(c)can use the ORDER BY clause if it also uses the TOP clause

(d)cannot use the ORDER BY clause with the OFFSET and FETCH clauses

By default,
(A)columns from different tables with the same name do not have to be renamed
(B)columns in a view are given the same names as the columns in the base tables
(C)calculated columns do not need to be named in the SELECT statement
(D) all of the above

Explanation / Answer

If you post more than 1 question, as per chegg guidelines I have to solve only first question.

Ques 1. Answer : (d) all of the above

A view is simply a virtual table which stores the date of the table referenced by the SELECT query. Now, we can make a table by all the queries given in the question. So, we can make view by all of them.

When we join the tables, we actually create a new table. So, we can create a view.

Also, a subquery or a function in mysql can also be converted into a view.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.