DAD 220 QUESTIONS WITH CORRECT ANSWERS

When installing MySQL, which account must the user enter a password for? Select
one.


Give this one a try later!


root




SELECT

,Give this one a try later!


MySQL query that shows you how to use simple SELECT statement to query
the data from a single table.




Data Dictionary


Give this one a try later!


stores information about the database structure and the types of data in
the database.




Many interesting science-, technology-, engineering-, and math-oriented websites
provide open-source data to the public. Which of the following sites provide that
information? Select all that apply.


Give this one a try later!


DATA.GOV, NYC Open Data, and National Cancer Institute all provide
open-source data.




Data Sharing


Give this one a try later!

, Advantages of a database over text file. Databases allow end users to
update and share data at the same time. A text file being edited by one
user may be unavailable to others.




BETWEEN


Give this one a try later!


MySQL Filtering data operator to query data based on a range using
BETWEEN operator




Query Processor


Give this one a try later!


interprets queries, creates a plan to modify the database or retrieve data
from the database, and returns query results back to the requesting
application.




Examples of everyday databases we access


Give this one a try later!


a playlist in an app on a smartphone. photos in an album on social media.
online shopping cart.