DBMS - SQL MCQ

Database

Title
A ________ is a stored program that is attached to a table or a view
The DROP TABLE statement:
SQL views can be used to hide:
The SQL statement to create a view is:
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Which of the following is NOT a type of SQL constraint?
A ________ is a program that performs some common action on database data and that is stored in the database
For what purposes are views used?
What is an SQL virtual table that is constructed from other tables?
When using the SQL INSERT statement:
What is not an advantage of stored procedures?
A reason for using an SQL view to hide columns is:
Which of the following is an SQL trigger supported by Oracle?
The SQL ALTER statement can be used to:
What SQL structure is used to limit column values of a table?
Which is NOT one of the most common types of SQL CHECK constraints?
What is an advantage of placing computations in SQL views?
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
‘AS’ clause is used in SQL for
The language which has recently become the defacto standard for interfacing application programs with relational database system is

Questions

Views

Best Answers

Points