LIS 3784 Quizzes E2

The following SQL statement uses a(n) ____.SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

"old-style" join

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?

15

Assume you are using the UNION ALL 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 ALL operator?

17

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 12?

96

____ requires that all operations within a transaction be completed together as one unit.

Atomicity

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

COMMIT

The ____ command would be used to delete the table row where the P_CODE is 'BRT-345'.

DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';

The ____ operator could be used in place of INTERSECT if the RDBMS does not support it.

IN

The ____ statement in SQL combines rows from two queries and returns only the rows that appear in both sets.

INTERSECT

____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

Isolation

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.

MINUS

The ____ operator could be used in place of MINUS if the RDBMS does not support it.

NOT IN

UPDATE tablename*****[WHERE conditionlist];The ____ command replaces the ***** in the syntax of the UPDATE command, shown above.

SET columnname = expression

The primary objective of database design is ____.

To create normalized, nonredundant, and fully integrated conceptual, logical, and physical database models

An example of a command you would use when making changes to a PRODUCT table is ____.

UPDATE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';

When you issue the DELETE FROM tablename command without specifying a WHERE condition, ____.

all rows will be deleted

User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.

analysis

All transactions must display ____.

atomicity, durability, consistency, isolation, and serializability

The statement SELECT * FROM T1, T2 produces a(n) ____ join.

cross

The detailed systems design of the system's processes is completed during the ____ phase of the SDLC.

design

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

full outer

Coding, testing, and debugging are part of the ____ phase of the SDLC.

implementation

When using a(n) ____ join, only rows that match the given criteria are returned.

inner

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

logical

Evaluation, maintenance, and enhancement are part of the ____ phase of the SDLC.

maintenance

"Union-compatible" means that the ____.

number of attributes must be the same, and their data types must be compatible

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

planning

A(n) ____ is a query that is embedded (or nested) inside another query.

subquery