Answers a b c d response feedback view view

Answers: A.
B.
C.
D.
Response Feedback:
view
view
subdatabase
table
tree
Complexity: easy
Section: 1.4
Question 6
Answers:
Which of the following is the proper way to create an alias, E, for relational table Employee
and retrieve all employee data?
0 out of 0.5 points
Complexity: Easy
Section: 5.4
Question 7
Amazon ElastiCache
Amazon Machine Learning
Amazon SQS
Amazon ElastiCache
Amazon EC2 Instance Store
Which service is best for storing common database query results, which helps to alleviate
database access load?
0.5 out of 0.5 points
Response C - Amazon ElastiCache for Redis is a great choice for implementing a highly
available, distributed, and secure in-memory cache to decrease access latency,
increase throughput, and ease the load o³ your relational or NoSQL databases
and applications. ElastiCache can serve frequently requested items at sub-
millisecond response times and enables you to easily scale for higher loads
without growing the costlier backend databases. Database query results
caching, persistent session caching, and full-page caching are all popular
examples of caching with ElastiCache for Redis.
Reference: -
elasticache-for-redis/
Question 8
0.5 out of 0.5 points

10/14/2020 Review Test Submission: Quiz02 – 202003_Database ...
Answers:
… 7/25
Response
Feedback:
C - The PRODUCT_ID value of A-7849 would be displayed last. Using the
BETWEEN operator in the given SQL statement displays all the identi±cation
numbers for products that have a quantity of 5, 30, or any quantity
between 5 and 30. The product identi±cation numbers are displayed by
ORDER_ID in ascending order, and within ORDER_ID by LINE_ITEM_ID in
ascending order. The default sort order when using an ORDER BY clause is
ascending (lowest to highest for numeric data, earliest to latest for date
data, and alphabetically for character data). Because this is the default sort
order, no sort order keyword, ASC or DESC, is required.
The value Z-79 would be the ±rst PRODUCT_ID returned if the ORDER BY was
on QUANTITY.
Response Feedback: Complexity: easy
Section: 1.5
Question 9
SELECT product_id, quantity
FROM line_item
WHERE quantity BETWEEN 5 AND 30
ORDER BY order_id, line_item_id;
Which PRODUCT_ID value would be displayed last?
Click the Exhibit(s) button to examine the data in the LINE_ITEM table. Evaluate this SQL
statement: