Database - SQL for Database Construction
Database - SQL for Database Construction
1. The SQL command to create a table is:
- MAKE TABLE.
- ALTER TABLE.
- DEFINE TABLE.
- CREATE TABLE.
2. A ________ is a stored program that is attached to a table or a view.
- pseudofile
- embedded SELECT statement
- trigger
- None of the above is correct.
3. The DROP TABLE statement:
- deletes the table structure only.
- deletes the table structure along with the table data.
- works whether or not referential integrity constraints would be violated.
- is not an SQL statement.
4. SQL views can be used to hide:
- columns and rows only.
- complicated SQL syntax only.
- both of the above can be hidden by an SQL view.
- None of the above is correct.
5. The SQL statement to create a view is:
- CREATE VIEW.
- MAKE VIEW.
- SELECT VIEW.
- INSERT VIEW.
6. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
- a particular column in a particular underlying table.
- a particular column in a particular row.
- a particular row in a particular underlying table.
- None of the above is correct.
7. Which of the following is NOT a type of SQL constraint?
- PRIMARY KEY
- FOREIGN KEY
- ALTERNATE KEY
- UNIQUE
8. A ________ is a program that performs some common action on database data and that is stored in the database.
- trigger
- stored procedure
- pseudofile
- None of the above is correct.
9. For what purposes are views used?
- To hide columns only
- To hide rows only
- To hide complicated SQL statements only
- All of the above are uses for SQL views.
10. What is an SQL virtual table that is constructed from other tables?
- Just another table
- A view
- A relation
- Query results