What is an advantage of placing computations in SQL views?%! – McqOptions

MCQOPTIONS

1.	What is an advantage of placing computations in SQL views?%!
A.	To save users from having to write an expression.
B.	To ensure that the results are consistent.
C.	To accomplish both of the above.
D.	None of the above is correct - computations cannot be placed in a view.
Answer» D. None of the above is correct - computations cannot be placed in a view.

Discussion

No Comment Found

Related MCQs

Three types of triggers are: BEFORE, AFTER and EXCEPTION.~!
A view that contains a computed column can be easily updated.~!
SQL statements can be embedded in triggers, stored procedures, and program code.~!
There are three SQL data modification operations: insert, modify and delete.~!
SQL Server does not support the BEFORE trigger.~!
A SQL view is a virtual table that is constructed from other tables or views.~!
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.~!
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.%!
A stored procedure is a program that performs some common action on database data and is stored in the database.%!
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.%!