Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
SQL for Database Construction Questions
What is not an advantage of stored procedures?
The SQL statement to create a view is:
The DROP TABLE statement:
A ________ is a program that performs some common action on database data and that is stored in the database.
Which of the following is NOT a type of SQL constraint?
What is an SQL virtual table that is constructed from other tables?
For what purposes are views used?
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Which of the following is an SQL trigger supported by Oracle?
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
SQL views can be used to hide:
A ________ is a stored program that is attached to a table or a view.
When using the SQL INSERT statement:
The SQL ALTER statement can be used to:
Which is NOT one of the most common types of SQL CHECK constraints?
What is an advantage of placing computations in SQL views?
The SQL command to create a table is:
A reason for using an SQL view to hide columns is:
What SQL structure is used to limit column values of a table?
A view that contains a computed column can be easily updated.
1
2