|
1). | The SQL command to create a table is:
| | View AnswerNo answer description available for this question
|
|
2). | A ________ is a stored program that is attached to a table or a view.
| | View AnswerNo answer description available for this question
|
|
3). | The DROP TABLE statement:
| | View AnswerANS: | B - | deletes the table structure along with the table data.
|
No answer description available for this question
|
|
4). | SQL views can be used to hide:
| | View AnswerANS: | C - | both of the above can be hidden by an SQL view.
|
No answer description available for this question
|
|
5). | The SQL statement to create a view is:
| | View AnswerNo answer description available for this question
|
|
6). | To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
| | View AnswerANS: | A - | a particular column in a particular underlying table.
|
No answer description available for this question
|
|
7). | Which of the following is NOT a type of SQL constraint?
| | View AnswerNo answer description available for this questiona
|
|
8). | A ________ is a program that performs some common action on database data and that is stored in the database.
| | View AnswerANS: | B - | stored procedure
|
No answer description available for this question
|
|
9). | For what purposes are views used?
| | View AnswerANS: | D - | All of the above are uses for SQL views.
|
No answer description available for this question
|
|
10). | What is an SQL virtual table that is constructed from other tables?
| | View AnswerNo answer description available for this question
|
|