EXAMIANS
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
YOUR ANSWER : ?
YOUR ANSWER : ?
A ________ is a stored program that is attached to a table or a view.
YOUR ANSWER : ?
Which of the following is NOT a type of SQL constraint?
YOUR ANSWER : ?
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
YOUR ANSWER : ?
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
YOUR ANSWER : ?
The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
YOUR ANSWER : ?
Three types of triggers are: BEFORE, AFTER and EXCEPTION.
YOUR ANSWER : ?
Common types of SQL CHECK constraints include range checks and limiting columns values.
YOUR ANSWER : ?
Views can be used to show the results of computed columns.
YOUR ANSWER : ?
A ________ is a program that performs some common action on database data and that is stored in the database.
YOUR ANSWER : ?