MIS 380 FINAL EXAM QUESTIONS ANSWERED CORRECTLY LATEST UPDATE 2026

MIS 380 FINAL EXAM QUESTIONS ANSWERED CORRECTLY LATEST UPDATE 2026 What are aggregate functions? - Answers Count, Avg, Max, Min, Sum Which of the following lists gives the order of execution of an SQL Statement by the DBMS? a. FROM, WHERE, SELECT b. FROM, SELECT, WHERE c. WHERE FROM SELECT d. SELECT FROM WHERE - Answers a. FROM, WHERE, SELECT Which of the following aggregate functions only work on numeric columns? SUM, COUNT, MAX, MIN, AVG - Answers SUM & AVG In a conditional statement in the WHERE clause, which of the following statements is the correct way to test for 'boots' and heels' ? - Answers category = 'boots' OR category = 'heels' What are the three most common SQL clauses - Answers SELECT, FROM, WHERE The keyword 'distinct' is used to do what? - Answers Eliminate duplicate rows The two clauses that can be used to describe JOIN conditions are the ___clause & the ____clause - Answers FROM clause & WHERE clause Which of the following aggregate functions CANNOT work on computed fields? Sum, Count, Avg, min, max - Answers COUNT Aggregate functions operate on what? a. Values on a single row b. Values across mult rows & columns c. Values across mult rows d. Values across mult columns - Answers c. Values across multiple rows Aggregate functions can appear in which clauses of an SQL query? - Answers SELECT, HAVING What is the comparison operator for the Between operator? - Answers =and= Which of the following lists includes items that can be included in the FROM clause? (check all that apply) a. Conditional statements, subqueries b. Table Names, literal constants c. Subqueries, Table names d. Table names, View names - Answers c & d By adding the GROUP by clause to the query what happens to the rows? - Answers The query is changed from rows to groups What is meant when a text field contains a null value? - Answers The field has an undetermined data value Which of the following lists are change queries -- that change in the database? a. insert, update, delete b. add, change, delete c. insert, change, delete d. add, update, remove - Answers a. insert, update, delete A JOIN statement will always contain? - Answers Two tables and a join on condition What does SQL stand for? - Answers Structured Query Language What does the _symbol mean when using the LIKE operator and comparing a pattern or substring? - Answers Exactly one character is skipped When must an alias name be included within quote marks? - Answers when it contains a space which of the following lists gives the correct order of clauses in a well-formed SQL statement? a. Select, from, having, group by, where, order by b. Select, from, having, where, group by, order by c. select, from, where, order by, group by, having d. select, from, where, group by, having , order by - Answers d. select, from, where, group by, having , order by In a magnetic disk device, a cylinder consists of ___ - Answers one track from each recording surface, one above the other Rotational delay refers to the time it takes ____ - Answers for the data to arrive under the read/write head after the read/write head is switched on Of the following factors, the one least likely to affect database performance is ____ - Answers the speed of transferring data from the CPU to primary memory An index built over a single field of a file ___ - Answers provides direct access to the file The most common data indexing in use today is the - Answers B+ tree index If an index involves a non-unique field of a file - Answers it may return multiple records when it is used to access the file In the division remainder hashing algorithm _____. - Answers the remainder points to the record location in the file The reason for performing physical database design is because the tables resulting from the logical database design _____. - Answers may not perform well enough All of the following are inputs into the physical database design process, except _____. - Answers unnormalized data Hashed files _____. - Answers require synonym pointer chains when collisions occur The measure of the number of queries from simultaneous users that must be satisfied in a given period of time by the application set and the database that supports it is called _____. - Answers throughput The main purpose of the "substituting foreign keys" physical design technique is to _____. - Answers avoid joins Which of the following is true regarding adding indexes to a relational database? - Answers Adding too many indexes can slow overall performance if the data is highly volatile Of the following, the one that is the least likely candidate to have an index built over it is a(n) _____. - Answers non-search attribute