21. The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
22. SQL has a JOIN ON syntax that can be used to create inner joins and outer joins. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
23. Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
24. The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
25. SQL Server does not support the BEFORE trigger. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
26. A updatable view has its own data. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
27. The SQL DELETE statement is used to delete both the table structure and table data. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
28. Common types of SQL CHECK constraints include range checks and limiting columns values. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
29. If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
30. When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables. A. True B. False Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board