Database - Introduction to SQL
Database - Introduction to SQL
21. Which of the following do you need to consider when you make a table in SQL?
- Data types
- Primary keys
- Default values
- All of the above.
23. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
- LIKE only.
- IN only.
- NOT IN only.
- Both IN and NOT IN.
24. The Microsoft Access wildcards are ____ and ____ .
- asterisk (*); percent sign (%)
- percent sign (%); underscore (_)
- underscore(_); question mark (?)
- question mark (?); asterisk (*)
25. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
- SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
- SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
- SELECT NAME IN CUSTOMER WHERE STATE = 'V';
- SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
27. To sort the results of a query use:
- SORT BY.
- GROUP BY.
- ORDER BY.
- None of the above is correct.
28. To define what columns should be displayed in an SQL SELECT statement:
- use FROM to name the source table(s) and list the columns to be shown after SELECT.
- use USING to name the source table(s) and list the columns to be shown after SELECT.
- use SELECT to name the source table(s) and list the columns to be shown after USING.
- use USING to name the source table(s) and list the columns to be shown after WHERE.
29. SQL can be used to:
- create database structures only.
- query database data only.
- modify database data only.
- All of the above can be done by SQL.
30. The SQL statement that queries or reads data from a table is ________ .
- SELECT
- READ
- QUERY
- None of the above is correct.