dp10_tif_ch02 - CHAPTER TWO INTRODUCTION TO STRUCTURED...

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

dp10_tif_ch02 - CHAPTER TWO INTRODUCTION TO STRUCTURED...

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