Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ou want to select author's last name from a table, but you only remember the author s last name starts with the letter B ,

ou want to select author's last name from a table, but you only remember the authors last name starts with the letter B, which string pattern can you use?
1 point
SELECT lastname from author where lastname like B#
SELECT lastname from author where lastname like B%
SELECT lastname from author where lastname like B$
None of the above
2.
Question 2
In a SELECT statement, which SQL clause controls how the result set is displayed?
1 point
ORDER BY clause
ORDER IN clause
ORDER WITH clause
3.
Question 3
Which of the following can be used in a SELECT statement to restrict a result set?
1 point
HAVING
WHERE
DISTINCT
All of the above
4.
Question 4
When querying a table called Author that contains a list of authors and their country of residence, which of the following queries will return the number of authors from each country?
1 point
SELECT Country, count(Country) FROM Author GROUP BY Country
SELECT Distinct(Country) FROM Author
SELECT Country, count(Country) FROM Author
SELECT Country, distinct(Country) FROM Author GROUP BY Country
5.
Question 5
You want to retrieve a list of books that have between 450 and 600 pages. Which clause would you add to the following SQL statement:
SELECT Title, Pages FROM Book ________________________________
1 point
WHERE Pages =450
WHERE Pages 450600
WHERE Pages >=450 and pages <=600
IF Pages >=450 and Pages <=600

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Next Generation Databases NoSQLand Big Data

Authors: Guy Harrison

1st Edition

1484213300, 978-1484213308

More Books

Students also viewed these Databases questions

Question

please dont use chat gpt 9 0 4 .

Answered: 1 week ago

Question

=+1. Is it OK for a firm to profit from poverty?

Answered: 1 week ago