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

View Full Document Right Arrow Icon
CHAPTER TWO INTRODUCTION TO STRUCTURED QUERY LANGUAGE (SQL) True-False Questions 1. SQL stands for Standard Query Language . Answer: False Page: 27 2. SQL is only a data manipulation language (DML). Answer: False Page: 27 3. SQL was developed by IBM in the late 1970s. Answer: True Page: 28 4. In addition to being a data sublanguage, SQL is also a programming language, like COBOL. Answer: False Page: 28 5. SQL commands can be embedded in application programs. Answer: True Page: 28 6. SQL, although very popular, has never become a national standard. Answer: False Page: 28 7. The SQL keyword FROM is used to specify the table to be used. Answer: True Page: 31 8. SQL can only query a single table. Answer: False Page: 31-32 9. SQL statements are ended with a colon. Answer: False Page: 32 ¶10. The columns to be obtained by an SQL command are listed after the FROM keyword. Answer: False Page: 31-32 11. The result of an SQL SELECT operation can contain duplicate rows. Answer: True Page: 32 12. To have SQL automatically eliminate duplicate rows from a result, use the keyword DISTINCT with the FROM keyword. Answer: False Page: 32 13. An asterisk (*) following the SELECT verb means that all columns are to be obtained. Page 2-1
Background image of page 1

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

View Full DocumentRight Arrow Icon
Introduction to Structured Query Language (SQL) Answer: True Page: 33 14. The WHERE clause contains the condition that specifies which columns are to be selected. Answer: False Page: 33 15. The rows of the result table can be sorted by the values in one or more columns. Answer: True Page: 41 16. Sorting is specified by the use of the SORT BY phrase. Answer: False Page: 41 17. A WHERE clause can contain only one condition. Answer: False Page: 41 18 The condition in WHERE clauses can refer to a set of values by using the IN keyword. Answer: True Page: 42 19. ANSI standard SQL uses the symbol "%" to represent a series of one or more unspecified characters. Answer: True Page: 44 20. The built-in function SUM can be used with any column. Answer: False Page: 45-47 21. The clause SELECT COUNT (*) results in a table with a single row and a single column. Answer: True Page: 47 ¶22. Arithmetic in SQL statements is limited to the operations provided by the built-in functions. Answer: False Page: 48 23. The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. Answer: True Page: 50 24. A WHERE clause can contain another SELECT statement enclosed in parenthesis. Answer: True Page: 56 25. A SELECT statement used in WHERE clause is called a subquery. Answer: True Page: 55-58 26. Only two tables can be queried by using a subquery. Answer: False Page: 57 27. An alternative to combining tables by a subquery is to use a join. Answer:
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/21/2008 for the course IE 224 taught by Professor Plebani during the Spring '08 term at Lehigh University .

Page1 / 16


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