07

Topics: SQL, Microsoft SQL Server, Stored procedure Pages: 20 (4772 words) Published: April 15, 2015
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 FOREIGN KEY. Answer: TRUE
Diff: 1 Page Ref: 289-290

6) One advantage of using the CONSTRAINT command to define a primary key is that the database designer controls the name of the constraint. Answer: TRUE
Diff: 3 Page Ref: 289-290

7) The SQL keyword UNIQUE is used to define alternative keys. Answer: TRUE
Diff: 2 Page Ref: 290

8) If the table PRODUCT has a column PRICE, and PRICE has the data type Numeric (8,2), the value 98765 stored in that field will be displayed by the DBMS as 98765.00. Answer: FALSE
Diff: 3 Page Ref: 289 Fig 7-4

9) If the table ITEM has a column WEIGHT, and WEIGHT has the data type Numeric (7,2), the value 4321 with be displayed by the DBMS as 43.21. Answer: TRUE
Diff: 2 Page Ref: 289 Fig 7-4

10) The SQL keyword CHECK is used to limit column values to specific values. Answer: TRUE
Diff: 2 Page Ref: 289, 292
11) The SQL keyword MODIFY is used to change the structure, properties or constraints of a table. Answer: FALSE
Diff: 1 Page Ref: 298

12) Data values to be added to a table are specified by using the SQL VALUES clause. Answer: TRUE
Diff: 2 Page Ref: 300-301

13) The SQL keyword DELETE is used to delete a table's structure. Answer: FALSE
Diff: 1 Page Ref: 298-299

14) When the correct SQL command is used to delete a table's structure, the command can only be used with a table that has already had its data removed. Answer: FALSE
Diff: 2 Page Ref: 298-299

15) One or more rows can be added to a table by using the SQL INSERT statement. Answer: TRUE
Diff: 2 Page Ref: 300-301

16) Unless it is being used to copy data from one table to another, the SQL INSERT statement can be used to insert only a single row into a table. Answer: TRUE
Diff: 3 Page Ref: 300-301

17) Rows in a table can be changed by using the SQL UPDATE statement. Answer: TRUE
Diff: 2 Page Ref: 307-308

18) The SQL SET keyword is used to specify a new value when changing a column value. Answer: TRUE
Diff: 3 Page Ref: 307-308

19) The SQL keyword MODIFY is used to change a column value. Answer: FALSE
Diff: 3 Page Ref: 307-308

20) Rows can be removed from a table by using the SQL DELETE statement. Answer: TRUE
Diff: 2 Page Ref: 309

21) An SQL virtual table is called a view.
Answer: TRUE
Diff: 1 Page Ref: 309

22) The SQL command CREATE USER VIEW is used to create a virtual table. Answer: FALSE
Diff: 2 Page Ref: 309
23) SQL views are constructed from SELECT statements.
Answer: TRUE
Diff: 2 Page Ref: 309-311

24) According to the SQL-92, statements used to construct views cannot contain the WHERE clause. Answer: FALSE
Diff: 2 Page Ref: 309

25) The SQL command SELECT is used to retrieve view instances. Answer: TRUE
Diff: 1 Page Ref: 309

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

27) SQL views can be used to hide columns.
Answer: TRUE
Diff: 1 Page Ref: 311-313 Fig 7-17

28) SQL views can be used to provide a level of insulation between data processed by applications and the data actually stored in the...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • 07 The Monarchy Essay
  • Essay about TMA 07
  • BSBCUS501C ASSESSMENT 4 07 07 14 Research Paper
  • case 12-07 Essay
  • Chapter 07 Quiz Essay
  • Case 07-2 Essay
  • Ilm Questionnaire M3 07 Essay
  • Geo 07 0236 Essay

Become a StudyMode Member

Sign Up - It's Free