CIS – 111 Week 11 Final Exam ..QUESTIONS AND ANSWERS..100%

• Question 1 2 out of 2 points Which query will output the table contents when the value of P_PRICE is less than or equal to 10? Selected Answer: Correct Answer: SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE = 10; SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE = 10; • Question 2 2 out of 2 points The SQL command that lets you select attributes from rows in one or more tables is . Selected Answer: Correct Answer: SELECT SELECT • Question 3 2 out of 2 points To list all the contents of the PRODUCT table, you would use . Selected Answer: Correct Answer: SELECT * FROM PRODUCT; SELECT * FROM PRODUCT; • Question 4 2 out of 2 points To delete a row from the PRODUCT table, use the command. Selected Answer: Correct Answer: DELETE DELETE • Question 5 2 out of 2 points The SQL character data format(s) is(are) . Selected Answer: Correct Answer: CHAR and VARCHAR CHAR and VARCHAR • Question 6 2 out of 2 points A table can be deleted from the database by using the command. Selected Answer: Correct Answer: DROP TABLE DROP TABLE • Question 7 0 out of 2 points The special operator used to check whether a subquery returns any rows is . Selected Answer: Correct Answer: LIKE EXISTS • Question 8 2 out of 2 points The special operator is used to check whether an attribute value is null. Selected Answer: Correct Answer: IS NULL IS NULL • Question 9 2 out of 2 points The operator could be used in place of INTERSECT if the RDBMS does not support it. Selected Answer: IN Correct Answer: IN • Question 10 2 out of 2 points The syntax for the UNION query is . Selected Answer: Correct Answer: query UNION query query UNION query • Question 11 2 out of 2 points The ANSI standard defines type(s) of outer join(s) Selected Answer: Correct Answer: three three • Question 12 2 out of 2 points A join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values. Selected Answer: Correct Answer: full outer full outer • Question 13 2 out of 2 points When using a(n) join, only rows that meet the given criteria are returned. Selected Answer: Correct Answer: inner inner • Question 14 2 out of 2 points Analyzing the company situation is part of the phase of the DBLC. Selected Answer: Correct Answer: database initial study database initial study • Question 15 2 out of 2 points Creating the conceptual design and selecting DBMS software are part of the phase of the DBLC. Selected Answer: Correct Answer: database design database design • Question 16 2 out of 2 points Evaluation, maintenance, and enhancement are part of the phase of the SDLC. Selected Answer: Correct Answer: maintenance maintenance • Question 17 2 out of 2 points The primary objective of database design is . Selected Answer: to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models Correct Answer: to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models • Question 18 2 out of 2 points Installation and fine tuning are part of the phase of the SDLC. Selected Answer: implementation Correct Answer: implementation • Question 19 2 out of 2 points The traditional SDLC is divided into phases. Selected Answer: Correct Answer: five five • Question 20 2 out of 2 points Lock indicates the level of lock use. Selected Answer: Correct Answer: granularity granularity • Question 21 2 out of 2 points The information stored in the is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program’s abnormal termination, or a system failure such as a network discrepancy or a disk crash. Selected Answer: Correct Answer: transaction log transaction log • Question 22 2 out of 2 points A lock prevents the use of any tables in the database from one transaction while another transaction is being processed. Selected Answer: Correct Answer: database-level database-level • Question 23 2 out of 2 points The implicit beginning of a transaction is . Selected Answer: Correct Answer: when the first SQL statement is encountered when the first SQL statement is encountered • Question 24 2 out of 2 points A(n) condition occurs when two or more transactions wait for each other to unlock data. Selected Answer: Correct Answer: deadlock deadlock • Question 25 2 out of 2 points A consistent database is . Selected Answer: Correct Answer: one in which all data integrity constraints are satisfied one in which all data integrity constraints are satisfied • Question 26 2 out of 2 points A transaction is a unit of work that must be either entirely completed or aborted. Selected Answer: Correct Answer: logical logical • Question 27 2 out of 2 points A data mart is part of the “ ” section of the business intelligence framework. Selected Answer: