SampleFinal410

SampleFinal410 - IDS 410 - Business Database Design Sample...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
IDS 410 - Business Database Design Sample Final Exam Name:_____________________________ SSN: __________________________ 1. Which clause is going to be processed first by the SQL processor? a. SELECT b. FROM c. WHERE d. GROUP BY e. ORDER BY 2. A(n) _____ is a named set of SQL statements that are executed when a data modification occurs. a. Alter b. stored procedure c. trigger d. program e. none of the above. 3. In a SQL statement which of the following clauses states the conditions for group selection? a. Select b. Where c. Group By d. From e. Having 4. To eliminate duplicate rows in a query, the _____ qualifier is used in the SQL Select command. a. Alter b. Check c. Drop d. Distinct 5. Compose a query to update the unit price of product_ID 2 from $200.00 to $225.00 in the product_t table. ______________________________________________ ______________________________________________ ______________________________________________ 6. _______ is a facility by which the DBMS periodically refuses to accept any new transactions. The system is in quiet state, and the database and transaction logs are synchronized. a.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/07/2011 for the course IDS 410 taught by Professor Staff during the Fall '08 term at Ill. Chicago.

Page1 / 6

SampleFinal410 - IDS 410 - Business Database Design Sample...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online