{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter07Review - Database Processing Ninth Edition CHAPTER...

Info icon This preview shows pages 1–4. 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
Image of page 1

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

View Full Document Right Arrow Icon
Chapter 7 - Database Processing, Ninth Edition 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: True Level: moderate Page: 246 7 - 2
Image of page 2
Chapter 7 - Database Processing, Ninth Edition 21. The SQL Server DBMS supports the SQL trigger BEFORE.
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern