Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Home
»
Database
»
SQL for Database Construction
The SQL statement used to create a view is CREATE VIEW.
True
Correct Answer:
True
← Previous Question
Next Question→
More Questions from
SQL for Database Construction
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!
Name:
Comment:
Post Comment
Join Discussion
Discussion & Comments