Answer Key
Quiz Question Bank Software Engineering Part 1
-
University:
Harvard University -
Course:
CS50 | AP Computer Science Academic year:
2021
-
Views:
480
Pages:
10
Author:
Kyuwon J.
1. Mathematical operators cannot be used to place restrictions on character-based attributes.
False
2. The CHECK constraint is used to define a condition for the values that the attribute
domain cannot have.
False
3. Some RDBMSs, such as Microsoft Access, automatically make the necessary
conversions to eliminate case sensitivity.
True
4. When a user issues the DELETE FROM tablename command without specifying a
WHERE condition
all rows will be deleted
the first row will be deleted
no rows will be deleted
the last row will be deleted
5. Which of the following queries uses the correct SQL syntax to list the table contents for
either V_CODE = 21344 or V_CODE = 24288?
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE
V_CODE = 21344 OR V_CODE > 24288;
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE
V_CODE = 21344 OR V_CODE <= 24288;
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE
V_CODE = 21344 OR V_CODE => 24288;
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE = 24288;
6. The SQL query to output the contents of the EMPLOYEE table sorted by last name, first
name, and initial is _____. Group of answer choices
SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME,
EMP_FNAME, EMP_INITIAL;
SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME,
EMP_FNAME, EMP_INITIAL;
SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL,
EMP_AREACODE EMP_PHONE FROM EMPLOYEE ORDER BY
EMP_LNAME, EMP_FNAME, EMP_INITIAL;
SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME,
EMP_INITIAL;
7. 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.
True
8. Which of the following queries will output the table contents when the value of the
character field P_CODE is alphabetically less than 1558-QW1?
SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE <'1558-QW1';
SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = [1558-QW1];
SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = {1558-QW1};
SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = (1558-QW1);
9. Which of the following is used to select partial table contents?
LIST
FROM
WHERE
