Curioustab

Home » Database » SQL for Database Construction

A stored procedure is a program that performs some common action on database data and is stored in the database.

True
False

Correct Answer: True

← Previous Question Next Question→

More Questions from SQL for Database Construction

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.
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 MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
A SQL view is a virtual table that is constructed from other tables or views.
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
A benefit of using a stored procedure is that it can be distributed to client computers.

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion