CH1 Quiz

When data is produced and stored as numeric, textual, or visual information, it varies in _____.

Format

What does a user that interacts with a database use to read and write data?

Query Language

Which role focuses on creating software that interacts with a database?

Programmer

Which database role focuses on database storage, response times, and optimization?

Designer

Which concept relates to software that reads and writes data in a database?

Management System

A database management system reads and writes data in a database, and ________.

ensures consistency and availability

What design consideration would apply to a database that has special performance requirements?

Structuring data properly on storage media

If a database system is processing three queries as part of a transaction and the third query fails, what happens to the transaction?

The successful query results are reverse and the transaction is canceled

How does a database system protect data when concurrent transactions occur?

preventing multiple transactions with the same data at the same time

In terms of database architecture, which component translates the query processor instructions into low-level file-system commands and is responsible for indexing the data?

Storage manager

Which type of database system is optimized for big data?

NoSQL

When a user interacts with a database, they can use a _____ to modify data with commands.

Query Language

The _______ SQL statement does not alter any database data.

SELECT

When using a SQL statement to create a table, which data type is used to store a fractional value?

DECIMAL

A database administrator uses which two SQL statements to view and modify existing customer balance with a late fee?

SELECT, UPDATE

A user creates a table by using a SQL statement. The data type VARCHAR(11) is part of the statement. What does the value of (11) represent?

The number of characters allowed for the data type

The analysis phase of database design includes which process?

Specifying requirements that are not dependent on a specific database system.

A database ______ is the implementation of database requirements in SQL with CREATE TABLE statements.

schema

Which principle defines data independence?

Physical design never affects query results.

What links a host programming language to a database system?

API

In the following ER diagram, what does 'AlbumTitle' represent?

Attribute

A database designer installs MySQL Communicty Edition to create a database. Which account does the designer use to gain full control of MySQL?

Root

When using the MySQL Workbench GUI, which icon will execute an SQL statement?

Lightning Bolt

When using the MySQL Command-Line Client, which character ends a command line?

;

Which option is found on the Schemas tab in the MySQL Workbench?

A list of available datbaases

A database administrator creates a MySQL statement with incorrect syntax. What does MySQL Workbench display when the statement is executed?

Error Code