The SQL command to create a table is:
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
1/2
Page
Pick an option on a question to see the right answer and solution.
A ________ is a stored program that is attached to a table or a view.
Select an option to see the answer and solution.
The DROP TABLE statement:
Select an option to see the answer and solution.
SQL views can be used to hide:
Select an option to see the answer and solution.
The SQL statement to create a view is:
Select an option to see the answer and solution.
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Select an option to see the answer and solution.
Which of the following is NOT a type of SQL constraint?
Select an option to see the answer and solution.
A ________ is a program that performs some common action on database data and that is stored in the database.
Select an option to see the answer and solution.
For what purposes are views used?
Select an option to see the answer and solution.
What is an SQL virtual table that is constructed from other tables?
Select an option to see the answer and solution.
When using the SQL INSERT statement:
Select an option to see the answer and solution.
What is not an advantage of stored procedures?
Select an option to see the answer and solution.
A reason for using an SQL view to hide columns is:
Select an option to see the answer and solution.
Which of the following is an SQL trigger supported by Oracle?
Select an option to see the answer and solution.
The SQL ALTER statement can be used to:
Select an option to see the answer and solution.
What SQL structure is used to limit column values of a table?
Select an option to see the answer and solution.
Which is NOT one of the most common types of SQL CHECK constraints?
Select an option to see the answer and solution.
What is an advantage of placing computations in SQL views?
Select an option to see the answer and solution.
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
Select an option to see the answer and solution.
The SQL statement used to create a view is CREATE VIEW.
Select an option to see the answer and solution.