DAD 220 - 1-3 Quiz

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

APUSH Chapters 1-13 Possible Test Questions

View Set

The 4th Amendment: Search and Seizures Part I

View Set

HRMG 460 Compensation Ch. 14 ~ Compensation of Special Groups: Executives and Others

View Set

Chapter 1 - The Operations Function

View Set

EAQ CH 41 Structure, Function, and Disorders of the Integument

View Set