Exam 3: Database Systems,data Warehouses,and Data Marts

Updating a flat file system is efficient and consumes less time.

The _____ dimension of big data refers to the sheer quantity of transactions,measured in petabytes or exabytes.

In the context of data administration component,the acronym CRUD stands for copy,revise,undo,and define.

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Explain the ways in which information in a database is observed through a physical view.

The first step in database design is defining a _____,which defines how data is created,represented,organized,and maintained.

_____ is data so voluminous that conventional computing methods are not able to efficiently process and manage it.

What is the function of the data definition component of a database management system?

_____ refers to new objects being created faster and more easily by entering new data in attributes.

_____ gives users subtotals of various categories,which can be useful.

A(n) _____ is the structure and organization of data,which involves fields,records,and files.

What are the advantages of a database over a flat file system?

In a(n) _____ file structure,records in files are organized and processed in numerical order.

The variety dimension of big data refers to a combination of _____.

What is structured query language (SQL)?

The _____ operator is used when all the conditions in a query by example (QBE) form are required to be met.

In a relational database,every record must be uniquely identified by a(n) _____ key.

Which of the following components of a data model describes methods and calculations that can be performed on data,such as updating and querying data?

_____ is information in its original form.

In comparison to a flat file system,in a database,_____.