COB 204 Databases Questions and Answers | Quiz 1| 2024
5 views 0 purchase
Course
COB
Institution
COB
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 histo...
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller smartchoices. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.49. You're not tied to anything after your purchase.
