The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
Select an option to see the answer and solution.
Database · all questionsSQL for Database Construction
SQL for Database Construction
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
39
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
Select an option to see the answer and solution.
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
Select an option to see the answer and solution.
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
Select an option to see the answer and solution.
SQL Server does not support the BEFORE trigger.
Select an option to see the answer and solution.
A updatable view has its own data.
Select an option to see the answer and solution.
The SQL DELETE statement is used to delete both the table structure and table data.
Select an option to see the answer and solution.
Common types of SQL CHECK constraints include range checks and limiting columns values.
Select an option to see the answer and solution.
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
Select an option to see the answer and solution.
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
Select an option to see the answer and solution.
Views can be used to show the results of computed columns.
Select an option to see the answer and solution.
A benefit of using a stored procedure is that it can be distributed to client computers.
Select an option to see the answer and solution.
A trigger is a stored program that is attached to a database.
Select an option to see the answer and solution.
A stored procedure is a program that performs some common action on database data and is stored in the database.
Select an option to see the answer and solution.
A SQL view is a virtual table that is constructed from other tables or views.
Select an option to see the answer and solution.
There are three SQL data modification operations: insert, modify and delete.
Select an option to see the answer and solution.
SQL statements can be embedded in triggers, stored procedures, and program code.
Select an option to see the answer and solution.
A view that contains a computed column can be easily updated.
Select an option to see the answer and solution.
Three types of triggers are: BEFORE, AFTER and EXCEPTION.
Select an option to see the answer and solution.