Sql For Database Construction - Study Mode
[#1] The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
Correct Answer
(B) False
[#2] SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
Correct Answer
(A) True
[#3] Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
Correct Answer
(B) False
Explanation
Solution: Standard SQL-92 views are constructed using SQL SELECT statements , and they can include the GROUP BY clause . The SQL-92 standard allows views to be created with complex SELECT statements , including those that use GROUP BY, JOINs, subqueries, and aggregate functions . Therefore, the claim that views cannot contain the GROUP BY clause is incorrect according to the SQL-92 standard.
[#4] The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
Correct Answer
(B) False
[#5] SQL Server does not support the BEFORE trigger.
Correct Answer
(A) True