Database - Introduction to SQL
Database - Introduction to SQL
1. You can add a row using SQL in a database with which of the following?
- ADD
- CREATE
- INSERT
- MAKE
2. The command to remove rows from a table 'CUSTOMER' is:
- REMOVE FROM CUSTOMER ...
- DROP FROM CUSTOMER ...
- DELETE FROM CUSTOMER WHERE ...
- UPDATE FROM CUSTOMER ...
3. The SQL WHERE clause:
- limits the column data that are returned.
- limits the row data are returned.
- Both A and B are correct.
- Neither A nor B are correct.
4. Which of the following is the original purpose of SQL?
- To specify the syntax and semantics of SQL data definition language
- To specify the syntax and semantics of SQL manipulation language
- To define the data structures
- All of the above.
5. The wildcard in a WHERE clause is useful when?
- An exact match is necessary in a SELECT statement.
- An exact match is not possible in a SELECT statement.
- An exact match is necessary in a CREATE statement.
- An exact match is not possible in a CREATE statement.
6. A view is which of the following?
- A virtual table that can be accessed via SQL commands
- A virtual table that cannot be accessed via SQL commands
- A base table that can be accessed via SQL commands
- A base table that cannot be accessed via SQL commands
7. The command to eliminate a table from a database is:
- REMOVE TABLE CUSTOMER;
- DROP TABLE CUSTOMER;
- DELETE TABLE CUSTOMER;
- UPDATE TABLE CUSTOMER;
8. ON UPDATE CASCADE ensures which of the following?
- Normalization
- Data Integrity
- Materialized Views
- All of the above.
10. Which of the following is valid SQL for an Index?
- CREATE INDEX ID;
- CHANGE INDEX ID;
- ADD INDEX ID;
- REMOVE INDEX ID;