Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Home
»
Database
»
SQL for Database Construction
SQL statements can be embedded in triggers, stored procedures, and program code.
True
Correct Answer:
True
← Previous Question
Next Question→
More Questions from
SQL for Database Construction
There are three SQL data modification operations: insert, modify and delete.
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
A trigger is a stored program that is attached to a database.
SQL Server does not support the BEFORE trigger.
A stored procedure is a program that performs some common action on database data and is stored in the database.
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
Three types of triggers are: BEFORE, AFTER and EXCEPTION.
A updatable view has its own data.
The SQL statement used to create a view is CREATE VIEW.
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
Discussion & Comments
No comments yet. Be the first to comment!
Name:
Comment:
Post Comment
Join Discussion
Discussion & Comments