Chapter07Review - Database Processing, Ninth Edition...

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

View Full Document Right Arrow Icon
Database Processing, Ninth Edition CHAPTER 7 Using SQL in Applications True-False Questions 1. When a surrogate key is used in the child table in an ID-dependent relationship the relationship changes to a non-identifying relationship. Answer: True Level: moderate Page: 229 2. The SQL keyword CONSTRAINT is used to limit column values to specific values. Answer: False Level: easy Page: 233 3. An SQL virtual table is called a view. Answer: True Level: easy Page: 235 4. The SQL command CREATE USER VIEW is used to create a virtual table. Answer: False Level: moderate Page: 235 5. SQL views are constructed from SELECT statements. Answer: True Level: moderate Page: 235 6. According to the SQL-92, statements used to construct views cannot contain the WHERE clause. Answer: False Level: moderate Page: 235 7. The SQL command SELECT is used to retrieve view instances. Answer: True Level: easy Page: 235 8. SQL views can be used to hide columns. Answer: True Level: easy Page: 238 9. SQL views can be use used to provide a level of indirection between data processed by applications and the data actually stored in the database tables. Answer: True Level: moderate Page: 238 7 - 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
10. If the values in an SQL view are changeable through the view itself, the SQL command UPDATE is used to change the values. Answer: True Level: moderate Page: 243 11. The values in an SQL view are always changeable through the view itself. Answer: False Level: moderate Page: 243 12. SQL views are updateable when the view is based on a single table with no computed columns, and all non-null columns are present in the view. Answer: True Level: hard Page: 243-244 [See Figure 7-13] 13. SQL views are identical to ANSI/SPARC external schemas /user views. Answer: False Level: moderate Page: 244 14. A set of SQL statements stored in an application written in a standard programming language is called embedded SQL. Answer: True Level: easy Page: 245 15. Because SQL statements are set-oriented, whereas programs are element-oriented, the results of SQL statements used in programs are treated as files. Answer: False Level: moderate Page: 245 16. Because SQL statements are set-oriented, whereas programs are element-oriented, the results of SQL statements used in programs are accessed using an SQL cursor. Answer: True Level: moderate Page: 245 17. A stored program that is attached to a table or view is called a stored procedure. Answer: False Level: moderate Page: 246 18. SQL triggers are used for validity checking, providing default values, and updating views. Answer: True Level: easy Page: 246 19. BEFORE UPDATE is an ANSI SQL trigger. Answer: True Level: moderate Page: 246 20. The Oracle DBMS supports the SQL trigger BEFORE. 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 03/31/2010 for the course MIS 542 taught by Professor Drwang during the Spring '10 term at University of Illinois, Urbana Champaign.

Page1 / 16

Chapter07Review - Database Processing, Ninth Edition...

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