Ch3-DB - CH3-DB True/False Indicate whether the statement...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
CH3-DB True/False Indicate whether the statement is true or false. ____ 1. SQL uses commands to create tables, update tables, and retrieve data from tables. ____ 2. You can use the SQL CREATE TABLE command to insert rows into a table. ____ 3. ____ 4. CHAR data types are numbers without a decimal part. ____ 5. In a SELECT statement, the WHERE clause is mandatory. ____ 6. ____ 7. A simple condition includes the field name, a comparison operator, and either another field name or a value. ____ 8. When you connect simple conditions using the AND operator, all the simple conditions must be false for the compound condition to be true. ____ 9. Preceding a condition by the NOT operator reverses the truth or falsity of the original condition. ____ 10. The BETWEEN operator is an essential feature of SQL. ____ 11. You can combine values in character fields. ____ 12. The IN operator provides a concise way of phrasing certain conditions. ____ 13. The HAVING clause is to groups what the WHERE clause is to rows. ____ 14. A WHERE and a HAVING clause cannot be included in the same query. ____ 15. For each pair of tables to be joined, a condition must be included indicating how the tables are related. Multiple Choice Identify the choice that best completes the statement or answers the question. ____ 16. When you use a name containing a space in Access SQL, you must ____. a. enclose it in quotation marks c. precede it by an asterisk b. enclose it in square brackets d. precede it by a question mark ____ 17. Many versions of SQL require you to end a command with a ____. a. comma (,) c. colon (:) b. period (.) d. semicolon (;) ____ 18. The basic form of an SQL retrieval command is ____. a. SELECT-WHERE-FROM c. SELECT-WHERE b. CREATE-SELECT-FROM d. SELECT-FROM-WHERE ____ 19. When used after the word SELECT, the ____ symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table. a. * c. # b. d. $ ____ 20. In MySQL, the ____ is used as a wildcard to represent any collection of characters. a. asterisks (*) c. underscore (_) b. percent sign (%) d. question mark (?)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
____ 21. The ____ function calculates the number of entries in a table. a.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/20/2008 for the course IST 331 taught by Professor Sikder during the Spring '08 term at Cleveland State.

Page1 / 6

Ch3-DB - CH3-DB True/False Indicate whether the statement...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online