07

4786 Words Apr 29th, 2015 20 Pages
Database Processing, 13e (Kroenke/Auer)
Chapter 7: SQL for Database Construction and Application Processing

1) The SQL CREATE TABLE statement is used to name a new table and describe the table's columns.
Answer: TRUE
Diff: 1 Page Ref: 281

2) The SQL keyword CONSTRAINT is used to define one of five types of constraints.
Answer: TRUE
Diff: 1 Page Ref: 283

3) The SQL keyword PRIMARY KEY is used to designate the column(s) that are the primary key for the table.
Answer: TRUE
Diff: 1 Page Ref: 283, 289

4) The SQL keyword CONSTRAINT is used to limit column values to specific values.
Answer: TRUE
Diff: 2 Page Ref: 283, 289

5) The SQL keyword CONSTRAINT is used in conjunction with the SQL keywords PRIMARY KEY and
…show more content…
Answer: TRUE
Diff: 2 Page Ref: 318-319 Fig 7-19

30) The values in an SQL view are always changeable through the view itself.
Answer: FALSE
Diff: 2 Page Ref: 318-319Fig 7-19

31) SQL views are updatable 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
Diff: 3 Page Ref: 318-319 Fig 7-19

32) Because SQL statements are table-oriented, whereas programs are variable-oriented, the results of SQL statements used in programs are treated as pseudofiles.
Answer: TRUE
Diff: 2 Page Ref: 319

33) A set of SQL statements stored in an application written in a standard programming language is called embedded SQL.
Answer: TRUE
Diff: 1 Page Ref: 319
34) Because SQL statements are table-oriented, whereas programs are variable-oriented, the results of SQL statements used in programs are accessed using an SQL cursor.
Answer: TRUE
Diff: 2 Page Ref: 319-320

35) A stored program that is attached to a table or view is called a stored procedure.
Answer: FALSE
Diff: 2 Page Ref: 323

36) SQL triggers use the ANSI SQL keywords BEFORE, INSTEAD OF, and AFTER.
Answer: TRUE
Diff: 2 Page Ref: 323-325 Fig 7-23

37) SQL triggers can be used with SQL operations INSERT, UPDATE, and DELETE.
Answer: TRUE
Diff: 2 Page Ref: 323-325 Fig 7-23

38) SQL triggers can be used when the DBMS receives an INSERT request.
Answer: TRUE
Diff: 1 Page Ref: 323-325 Fig 7-23

39)
Open Document