Exam 10: Databases

The acronym ____________ refers to software that manages data stored in a database.

In a(n) _________ database, a table is a sequence of records, similar to a flat file.

A process called ____________ helps database designers create a database structure that minimizes storage space and increases processing efficiency.

In its broadest definition, a(n) ____________ is a collection of information.

A key element of __________ databases is their ability to support OLAP queries that make it possible to combine data, drill down to specifics, or slice and dice the data to view it from different perspectives.

In a database, the template for a record is referred to as a record ______.

Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.

__________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status.

In a(n) __________ database, data for a query is fetched from one or more shards of a distributed database, and then it is processed by the DBMS to produce the query result.

____________ scaling (or autoscaling) ensures acceptable database throughput by scaling out as necessary to handle peak loads.​

A ________________ is a software tool for specifying the content and format for a database report.

SQL keywords must be entered in all uppercase letters because they are case-sensitive.​

1024 Zettabytes = 1 _______.​

Which of the following is not considered to be type of database client?

A(n) _________ sort uses one field to arrange records.A(n) _________ sort arranges information by more than one field.

A report ____________ contains the outline or general specifications for a report.​

A _______________ is a field that contains data unique to a record.

The term database ___________ refers to the arrangement of fields, tables, and relationships in a database.

Relational databases are organized according to a(n) _________, which is simply the blueprint for its structure.​