FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Databases

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 1

True/False

Review LaterAdd Note

Review Later

A table's physical sort order is the order in which records are arranged on storage devices.​

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

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.​

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.​

__________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.​

Modern database tools support ________________, which entails separating data from the programs that manipulate data.​

One of the ways that databases are classified is by their structure.​

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.​

Modifications to the contents of a database field are made by using the SQL _________ command.​

A primary key is a ____________ that contains data unique to a record.​

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

​The goal of normalization is to minimize data redundancy.

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

A(n) __________ file consists of a single, two-dimensional table of data elements.​

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

The entire Internet contains about a zettabyte of data.​

A record that contains data is referred to as a record ________.​

Which of the following is not a SQL keyword?​

A(n) ________________ is a software tool for specifying the content and format for a database report. ​

A(n) _______________ is a field that contains data unique to a record.​

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