SQL for Database Construction - Database MCQ Questions and answers- Technical Aptitude Page-3 section-1

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

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

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

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

25.
SQL Server does not support the BEFORE trigger.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

26.
A updatable view has its own data.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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

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

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

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

SQL for Database Construction - Database MCQ Questions and answers- Technical Aptitude

21. The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

Answer & Solution

22. SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.

Answer & Solution

23. Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

Answer & Solution

24. The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.

Answer & Solution

25. SQL Server does not support the BEFORE trigger.

Answer & Solution

26. A updatable view has its own data.

Answer & Solution

27. The SQL DELETE statement is used to delete both the table structure and table data.

Answer & Solution

28. Common types of SQL CHECK constraints include range checks and limiting columns values.

Answer & Solution

29. If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

Answer & Solution

30. When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

Answer & Solution

21.
The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

22.
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.

23.
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

24.
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.

25.
SQL Server does not support the BEFORE trigger.

26.
A updatable view has its own data.

27.
The SQL DELETE statement is used to delete both the table structure and table data.

28.
Common types of SQL CHECK constraints include range checks and limiting columns values.

29.
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

30.
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.