Quiz 5

file server

A device that manages file operations and is shared by each client PC on a LAN is called a:

TableOne

In a correlated subquery of a database that has tables TableOne and TabeTwo, and if table Table TableOne is used in the upper SELECT statement, then which table is externally referred to in the lower SELECT statement?

A, B, & C (EXISTS, correlated subqueries, NOT EXISTS)

In developing advanced SQL statements, additional features could be used to support the data validation for retrieval. Which of the following is (are) characteristics of these advanced SQL statements?

alias

In the SQL statement: SELECT C1.CustName, C1.SalesRepNo FROM CUSTOMER C1;

reverse engineering

The process of reading an actual database schema and producing a data model from that schema is called _______.

create new table, move the data and drop the old table

To change a table name in a relational database, we _______.

alternates running the lower SELECT statement with running the upper SELECT statement based on each result of the lower SELECT statement

When running a correlated subquery, the DBMS __________.

nested processing

When running a correlated subquery, the DBMS always uses

all rows in the subquery fail to meet the condition.

When running an SQL query that uses NOT EXISTS, the NOT EXISTS keyword will be true if ________

business rules

Which of the following is a component of processing logic?

application partitioning

________ is the process of assigning pieces of application code to clients or servers.