DAD 220 - 1-3 Quiz

What is a database management system (DBMS)? Select one.

A software application used to support data organization in a database

What four properties must be achieved for transactions to change data in a relational database? Select all that apply.

Atomicity Consistency Isolation Durability

In two-tier architecture, what database components are present? Select all that apply.

Client Server

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.

DATA.GOV NYC Open Data National Cancer Institute

True or false: SQL contains four statements for a database command.

False

Which of the following are components of a database system? Select all that apply

Query Processor Storage manager Transaction manager

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

Root account

True or false: Structured Query Language (SQL) is a popular query language used to communicate with a database system.

True

True or false: The MySQL command-line client is a command-line application included in the MySQL installation that allows developers to connect to a MySQL server, perform administrative functions, and execute SQL statements.

True

Which of the following options listed in the readings are identified as factors that may impact database performance? Select all that apply.

Workload Throughput Resources