When an SQL SELECT statement is used to retrieve data from a view instance, the maximum number of columns that can be specified in the SELECT is the same as the number of columns:

A) in the table underlying the view.
B) in the VIEW specification.
C) in the ORDER BY clause.
D) in the HAVING clause.
E) that have aliases.


B

Business

You might also like to view...

Return on sales ratio

a. Market price per share b. Net sales c. Gross profit d. Average total assets e. Interest expense, net of tax f. Net income g. Total liabilities h. Total assets

Business

Oliver works in a place that has a formal chain of command and is internally focused. His manager, Amelia, uses her position to manage her employees and to emphasize the importance of efficiency, productivity, and organization in the day-to-day running of operations. Oliver and Amelia work for a company that fits which type of culture?

A. hierarchy B. adhocracy C. market D. clan

Business

Production managers at LennoCorp are required to exercise independent judgment in completing their jobs. They would be classified as exempt employees, which means that they are not covered by the overtime provisions under the Fair Labor Standards Act.

Answer the following statement true (T) or false (F)

Business

Decentralized companies rarely struggle to achieve goal congruence

Indicate whether the statement is true or false

Business