MIS 3140 FINAL EXAM WITH COMPLETE SOLUTIONS
100% VERIFIED
The special operator used to check for similar character strings is ____. - ANSWER
LIKE
The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from
the PRODUCT table in ascending order by P_PRICE is ____.
a.SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
SEQUENCE BY P_PRICE
b.SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
ORDER BY P_PRICE;
c.SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
LIST BY P_PRICE;
d.SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
ASCENDING BY P_PRICE; - ANSWER b.
SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
, ORDER BY P_PRICE;
A database language enables the user to create database and table structures to
perform basic data management chores. ( T or F) - ANSWER TRUE
Although SQL commands can be grouped together on a single line, complex command
sequences are best shown on separate lines, with space between the SQL command
and the command's components. ( T or F) - ANSWER TRUE
Any changes made to the contents of a table are not physically saved on disk until you
use the SAVE <table name> command. ( T or F) - ANSWER FALSE
Data type selection is usually dictated by the nature of the data and by the intended use.
( T or F) - ANSWER TRUE
Entity integrity is enforced automatically when the primary key is specified in the
CREATE TABLE command sequence. ( T or F) - ANSWER TRUE
SQL requires the use of the ADD command to enter data into a table. ( T or F) -
ANSWER FALSE
- correct answer is INSERT INTO
The CHECK constraint is used to define a condition for the values that the attribute
domain cannot have.( T or F) - ANSWER FALSE
The conditional LIKE must be used in conjunction with wildcard characters.
( T or F) - ANSWER TRUE
The COUNT function is designed to tally the number of non-null "values" of an attribute,
and is often used in conjunction with the DISTINCT clause.
( T or F) - ANSWER TRUE
100% VERIFIED
The special operator used to check for similar character strings is ____. - ANSWER
LIKE
The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from
the PRODUCT table in ascending order by P_PRICE is ____.
a.SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
SEQUENCE BY P_PRICE
b.SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
ORDER BY P_PRICE;
c.SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
LIST BY P_PRICE;
d.SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
ASCENDING BY P_PRICE; - ANSWER b.
SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
, ORDER BY P_PRICE;
A database language enables the user to create database and table structures to
perform basic data management chores. ( T or F) - ANSWER TRUE
Although SQL commands can be grouped together on a single line, complex command
sequences are best shown on separate lines, with space between the SQL command
and the command's components. ( T or F) - ANSWER TRUE
Any changes made to the contents of a table are not physically saved on disk until you
use the SAVE <table name> command. ( T or F) - ANSWER FALSE
Data type selection is usually dictated by the nature of the data and by the intended use.
( T or F) - ANSWER TRUE
Entity integrity is enforced automatically when the primary key is specified in the
CREATE TABLE command sequence. ( T or F) - ANSWER TRUE
SQL requires the use of the ADD command to enter data into a table. ( T or F) -
ANSWER FALSE
- correct answer is INSERT INTO
The CHECK constraint is used to define a condition for the values that the attribute
domain cannot have.( T or F) - ANSWER FALSE
The conditional LIKE must be used in conjunction with wildcard characters.
( T or F) - ANSWER TRUE
The COUNT function is designed to tally the number of non-null "values" of an attribute,
and is often used in conjunction with the DISTINCT clause.
( T or F) - ANSWER TRUE
