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.