COB 204 Databases Questions and Answers | Quiz 1| 2024

COB 204 Databases Questions and Answers | Quiz
1| 2024


Which statement is true regarding the DB Browser tool?

A. The tool must connect to a database server
B. This tool must be purchased
C. This tool works consistently across all major platforms
D. This tool does not offer a log of historical commands **** C. This tool works
consistently across all major platforms

What does a record represent in a database?

A. a kind of information
B. a set of information
C. a type of field
D. a table of values **** B. a set of information

How many clauses are defined in this statement?
*SELECT Height, Weight FROM Shapes
WHERE Material='Wood'
ORDER BY Height;*

A. one
B. four
C. three
D. five **** B. four

Bryan is 13 years old, Lisa is 15, and Mike is 21. Their ages would most likely be stored
in a:

A. column
B. row
C. schema
D. table **** A. column

What is the correct order of clauses in a SQL query that includes WHERE?

A. SELECT, FROM, WHERE
B. WHERE, SELECT, FROM

, C. SELECT, WHERE, FROM
D. FROM, WHERE, SELECT **** A. SELECT, FROM, WHERE

Choose the correct statement that returns the students from all states except New York

A.) SELECT FirstName, LastName FROM Student WHERE State>= 'NY';
B.) SELECT FirstName, LastName FROM Student WHERE State IS 'CA' AND NOT
'NY';
C.) SELECT FirstName, LastName FROM Student WHERE State != 'NY';
D.) SELECT FirstName, LastName FROM Student WHERE State = 'CA', 'GA', 'NH';
**** C. SELECT FirstName, LastName FROM Student WHERE State != 'NY';

Select the WHERE clause that returns all records with the text "priority" in the Comment
column

A. WHERE Comment LIKE '%priority%'
B. WHERE Comment LIKE 'priority%'
C. WHERE Comment LIKE 'priority'
D. WHERE Comment LIKE '%priority' **** A. WHERE Comment LIKE '%priority%'

The "Items" table has one "Name" column with 12 items on it. What will this query
return?
*SELECT 'Name' FROM Items;*

A. the text "Name" showing 12 times
B. the values of all 12 items
C. the text "Name" showing once
D. the text "Items" showing once **** A. the text "Name" showing 12 times

To sort a list of students in descending order by last name, you can use this statement:

A.) SELECT FirstName, LastName FROM Student ORDER BY LastName DESC;
B.) SELECT FirstName, ORDER BY LastName DESC;
C.) SELECT FirstName, LastName FROM Student ORDER BY LastName;
D.) SELECT FirstName, LastName FROM Student WHERE ORDER BY LastName
DESC; **** A.) SELECT FirstName, LastName FROM Student ORDER BY LastName
DESC;

Which data row will be left out with this condition in your statement?
*WHERE Color != 'B' OR (Size='L' AND Price>20)*

A. Color is 'B', Size is 'L' and Price is 30
B. Color is 'W', Size is 'S' and Price is 20
C. Color is 'G', Size is 'L' and Price is 25
D. Color is 'B', Size is 'XL' and Price is 10 **** D. Color is 'B', Size is 'XL' and Price is
10