Database Final3

The maintenance and evolution phase of the DBLC involves ____.

The first step in the ER model verification process is to ____.

A(n) ______ join will select only the rows with common values in the common attribute(s)

The initial assessment and the feasibility study are part of the SDLC's ____ phase.

____ requires that all operations of a transaction be completed.

A consistent database is ____.

The first step in developing the conceptual model using ER diagrams is to ____.

Analyzing the company situation is part of the ____ phase of the DBLC.

A transaction is a ____ unit of work that must be either entirely completed or aborted.

The conceptual design step that identifies ER modules and validates insert, update, and delete rules is ____.

In Oracle, ______ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping

A ____ lock locks the entire table preventing access to any row by a transaction while another transaction

________ is a relational set operator

The database is loaded during the ____ phase of the SDLC.

A _______ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values

The ____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.

A(n) _______ join returns not only the rows matching the join condition (this is, rows with matching values in the common columns) but also the rows with unmatched values

A ____ lock prevents the use of any tables in the database from one transaction while another transaction is being processed.

____ are required to prevent another transaction from reading inconsistent data.

The ANSI has defined standards that govern SQL database transactions. Transaction support is provided by two SQL statements: ____ and ROLLBACK.

Installation and fine tuning are part of the ____ phase of the SDLC.

One of the three most common data integrity and consistency problems is ____.

The ____ design is the process of selecting the data storage and data access characteristics of the database.

As long as two transactions, T1 and T2, access ____ data, there is no conflict, and the order of execution is irrelevant to the final outcome.

The syntax for the UNION query is _________

There are ____ classical approaches to database design.

A ____ lock allows concurrent transactions to access different rows of the same table.

Assume you are using the UNION operator to combine the results from two tables with identical structure CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator?

The process of creating an information system is known as ____ development.

____ allow(s) physical access to areas by authorized personnel only.

In a sbuquery, the _______ query is executed first

The _______ function returns the current system date in MS Access

The PL/SQL block starts with the ________ clause

The database initial study phase of the DBLC involves ____.

During decentralized design, after the ____ process has been completed, all modules are integrated into one conceptual model.

A ____ lock locks the entire diskpage.

A(n) ____ lock exists when concurrent transactions are granted read access on the basis of a common lock.

When using Oracle TO_NUMBER function to convert a character string into a number, ______ represents a digit

The __________ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second

The implementation and loading phase of the DBLC involves ____.

The ____ manager is responsible for assigning and policing the locks used by the transactions.

The following SQL statement uses (an) ________.
SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME
FROM PRODUCT, VENDOR
WHERE PRODUCT V_CODE = VENDOR.V_CODE

A(n) _________ is a block of code(containing standard SQL statements and procedural extensions) that is stored and executed at the DBMS server

The information stored in the ____ is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program’s abnormal termination, or a system failure such as a network discrepancy or a disk crash.

When using a(n) _______ join, only rows that meet the given criteria are returned