SQL for Database Construction and Application Processing (7)
1. The SQL CREATE TABLE statement is used to name a new table and de- scribe the table's columns.:
True
2. The SQL keyword CONSTRAINT is used to define one of several types of constraints.: True
3. The SQL keyword PRIMARY KEY is used to designate the column(s) that are the primary key for the table.:
True
4. The SQL keyword CONSTRAINT is used to limit the column values to specific values.: True
5. The SQL keyword CONSTRAINT can be used in conjunction with the SQL keywords PRIMARY KEY and
FOREIGN KEY.: True
6. One advantage of using the CONSTRAINT command to define a primary key is that the database designer
controls the name of the constraint.: True
7. The SQL keyword UNIQUE is used to define alternate keys.: True
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: False
9. If the table ITEM has a column WEIGHT, and WEIGHT has the data type Numeric (4,2), the value 4321
will be displayed by the DBMS as 43.21: True
10.The SQL keyword CHECK is used to limit the column values to specific values.: True
11.The SQL keyword MODIFY is used to change the structure, properties, and constraints of a table.: False
12.Data values to be added to a table are specified by using the SQL VALUES clause.: True
13.The SQL keyword DELETE is used to delete a table's structure.: False
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.: False
15.One or more rows can be added to a table by using the SQL INSERT statement.: True
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.: True
17.Rows in a table can be changed by using the SQL UPDATE statement.: True
18.The SQL SET keyword is used to specify a new value when changing a column value.: True
19.The SQL keyword MODIFY is used to change a column value.: False
20.Rows can be removed from a table by using the SQL DELETE statement.-
: True
21.An SQL virtual table is called a view.: True
, SQL for Database Construction and Application Processing (7)
22.The SQL command CREATE USER VIEW is used to create a virtual table.-
: False
23.SQL views are constructed from SELECT statements.: True
24.According to the SQL-92 standard, statements used to construct views cannot contain the WHERE
clause.: False
25.The SQL command SELECT is used to retrieve view instances.: True
26.The values in an SQL view are not always changeable through the view itself.: True
27.SQL view can be used to hide columns.: True
28.SQL views can be used to provide a level of insulation between data processed by applications and the
data actually stored in the database ta- bles.: True
29.If the values in an SQL view are changeable through the view itself, the SQL command UPDATE is used to
change the values.: True
30.The values in an SQL view are always changeable through the view itself.-
: False
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.: True
32.Because SQL statements are table-oriented, whereas programs are vari- able-oriented, the results of SQL
statements used in programs are treated as pseudofiles.: True
33.A set of SQL statements stored in an application written in a standard programming language is called
embedded SQL: True
34.Because SQL statements are table-oriented, whereas programs are vari- able-oriented, the results of SQL
statements used in programs are accessed using an SQL cursor.: True
35.A stored program that is attached to a table or view is called a stored procedure.: False
36.SQL triggers use the ANSI SQL keywords BEFORE, INSTEAD OF, and AFTER.: True
37.SQL triggers can be used with SQL operations INSERT, UPDATE, and DELETE.: True
38.SQL triggers can be used when the DBMS receives an INSERT request.: -
True
39.SQL triggers are used for providing default values, validity checking, up- dating views, and performing
referential integrity actions.: True
40.The Oracle DBMS supports the SQL BEFORE trigger.: True
41.The SQL Server DBMS supports the SQL BEFORE trigger.: False
1. The SQL CREATE TABLE statement is used to name a new table and de- scribe the table's columns.:
True
2. The SQL keyword CONSTRAINT is used to define one of several types of constraints.: True
3. The SQL keyword PRIMARY KEY is used to designate the column(s) that are the primary key for the table.:
True
4. The SQL keyword CONSTRAINT is used to limit the column values to specific values.: True
5. The SQL keyword CONSTRAINT can be used in conjunction with the SQL keywords PRIMARY KEY and
FOREIGN KEY.: True
6. One advantage of using the CONSTRAINT command to define a primary key is that the database designer
controls the name of the constraint.: True
7. The SQL keyword UNIQUE is used to define alternate keys.: True
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: False
9. If the table ITEM has a column WEIGHT, and WEIGHT has the data type Numeric (4,2), the value 4321
will be displayed by the DBMS as 43.21: True
10.The SQL keyword CHECK is used to limit the column values to specific values.: True
11.The SQL keyword MODIFY is used to change the structure, properties, and constraints of a table.: False
12.Data values to be added to a table are specified by using the SQL VALUES clause.: True
13.The SQL keyword DELETE is used to delete a table's structure.: False
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.: False
15.One or more rows can be added to a table by using the SQL INSERT statement.: True
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.: True
17.Rows in a table can be changed by using the SQL UPDATE statement.: True
18.The SQL SET keyword is used to specify a new value when changing a column value.: True
19.The SQL keyword MODIFY is used to change a column value.: False
20.Rows can be removed from a table by using the SQL DELETE statement.-
: True
21.An SQL virtual table is called a view.: True
, SQL for Database Construction and Application Processing (7)
22.The SQL command CREATE USER VIEW is used to create a virtual table.-
: False
23.SQL views are constructed from SELECT statements.: True
24.According to the SQL-92 standard, statements used to construct views cannot contain the WHERE
clause.: False
25.The SQL command SELECT is used to retrieve view instances.: True
26.The values in an SQL view are not always changeable through the view itself.: True
27.SQL view can be used to hide columns.: True
28.SQL views can be used to provide a level of insulation between data processed by applications and the
data actually stored in the database ta- bles.: True
29.If the values in an SQL view are changeable through the view itself, the SQL command UPDATE is used to
change the values.: True
30.The values in an SQL view are always changeable through the view itself.-
: False
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.: True
32.Because SQL statements are table-oriented, whereas programs are vari- able-oriented, the results of SQL
statements used in programs are treated as pseudofiles.: True
33.A set of SQL statements stored in an application written in a standard programming language is called
embedded SQL: True
34.Because SQL statements are table-oriented, whereas programs are vari- able-oriented, the results of SQL
statements used in programs are accessed using an SQL cursor.: True
35.A stored program that is attached to a table or view is called a stored procedure.: False
36.SQL triggers use the ANSI SQL keywords BEFORE, INSTEAD OF, and AFTER.: True
37.SQL triggers can be used with SQL operations INSERT, UPDATE, and DELETE.: True
38.SQL triggers can be used when the DBMS receives an INSERT request.: -
True
39.SQL triggers are used for providing default values, validity checking, up- dating views, and performing
referential integrity actions.: True
40.The Oracle DBMS supports the SQL BEFORE trigger.: True
41.The SQL Server DBMS supports the SQL BEFORE trigger.: False
