quiz6-10

TQM stands for

total quality management

A discrete unit of work that must be processed completely or not at all within a computer system is called a:

transaction

All of the following are characteristics of cloud technologies EXCEPT:

unlimmited bandwidth

What will be returned when the following SQL query is executed? SELECT driver_no, COUNT(*) as num_deliveries FROM deliveries GROUP BY driver_no HAVING COUNT( *) > 2;

A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries

Which of the following is a technique for optimizing the internal performance of the relational data model?

Clustering data

The main concept of relational databases was published in 1970 by

E.F COD

both output compatible data types for each column and return the same number of rows

In order for two queries to be UNION-compatible, they must:

A data-interchange format easily for humans to read and machines to parse and process is called:

JSON

Which of the following is NOT true of poor data and/or database administration?

Maintaining a secure server

A single value returned from an SQL query that includes an aggregate function is called a(n):

Scalar aggregate

The ________ is the structure that contains descriptions of objects such as tables and views created by users.

Schema

A common encryption method to secure data traveling between a client and a server is called:

Secure socket layer

Which of the following is a purpose of the SQL standard?

To specify syntax and semantics of SQL data definition and manipulation languages

The ________ operator is used to combine the output from multiple queries into a single result table

Union

In an SQL statement, which of the following parts states the conditions for row selection?

WHERE

An open source DBMS is

a free source code RBMS that provides the functionality of an SQL-compliant DBMS

The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T LEFT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;

all rows of the Customer_T Table regardless of matches with the Order_T Table.

The SQL command ________ adds one or more new columns to a table.

alter table

An appropriate datatype for adding a sound clip would be:

blob

A join in which the joining condition is based on equality between values in the common columns is called a(n):

both equijoin and natra join

A join operation:

causes two tables with a common domain to be combined into a single table or view.

The UNION clause is used to:

combine the output from multiple queries into a single result table.

A materialized view is/are:

copies or replica of data based on queries.

Conformance means that:

data are stored, exchanged or presented in a format that is specified by its metadata.

A form of denormalization where the same data are purposely stored in multiple places in the database is called:

data replication

The role responsible for administering database security is:

database administration

A computer that provides database storage and access in a client/server environment is called a(n):

database server

Which of the following is not a basic step to accessing a database from an application:

define physical storage

A contiguous section of disk storage space is called a(n):

extent

A disadvantage of partitioning is

extra space and update time.

A client PC that is responsible for processing presentation logic, extensive application and business rules logic, as well as many DBMS functions is called a:

fat client

file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a:

hash index table

Data governance can be defined as:

high-level organizational groups and processes that oversee data stewardship.

Which of the following is an objective of selecting a data type

improves data integrity

One major advantage of the outer join is that

information is not lost.

data quality is important for all of the following reasons EXCEPT:

it provides a stream of profit

The LAMP stack consists of all of the following EXCEPT:

lls

The methods to ensure the quality of data across various subject areas are called:

master data management

The architecture that most applications use that separates the business logic, presentation logic, and database logic is called:

model view controller

The most commonly used form of join operation is the:

natural join

The last part of an SQL query to be read is the ________ statement.

order by

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

outer join

A(n) ________ is a field of data used to locate a related field or record.

pointer

An application server

provides the building blocks for creating dynamic web sites and web-based applications

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs

recovery manager

One simple task of a data quality audit is to

statistically profile all files

A PC configured to handle user interfaces with limited local storage is called a(n)

thin client

INSERT INTO is an example of ________ code.

DML