EXAMIANS
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
YOUR ANSWER : ?
YOUR ANSWER : ?
The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
YOUR ANSWER : ?
SQL statements can be embedded in triggers, stored procedures, and program code.
YOUR ANSWER : ?
A trigger is a stored program that is attached to a database.
YOUR ANSWER : ?
The SQL ALTER statement can be used to:
YOUR ANSWER : ?
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
YOUR ANSWER : ?
A benefit of using a stored procedure is that it can be distributed to client computers.
YOUR ANSWER : ?
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
YOUR ANSWER : ?
A view that contains a computed column can be easily updated.
YOUR ANSWER : ?
SQL views can be used to hide:
YOUR ANSWER : ?