1.What command should be used to save permanently all changes made to a database.

1. SAVE
2. WRITE ALL
3. COMMIT
4. SAVE ALL

2.When building your clauses which of the following is recommended to address first:

1. FROM
2. SELECT
3. WHERE
4. ORDER BY

3.After requesting a service, a client must pay 30 days after the service is required. In the SERVICE table, there exists the attribute DATE that holds the day a service was required, but there is no attribute for the due date. Which of the following queries shows the date a service was required and when the payment is due as DUE_DATE.

1. SELECT SID, DATE, DUE+30 AS DUE DATE FROM SERVICE
2. SELECT SID, DATE, DATE+30 FROM SERVICE
3. SELECT SID, DATE, 30+DUE_DATE FROM SERVICE
4. SELECT SID, DATE, DUE_DATE FROM SERVICE

4.Which of the following differentiates the HAVING clause from the WHERE clause?

1. WHERE is executed prior to SELECT and HAVING after.
2. HAVING is executed prior to GROUP BY and WHERE after.
3. WHERE is executed prior to GROUP BY and HAVING after.
4. WHERE is used in older SQL versions.

5.When using a cross join between a table with 8 rows and another with 5 rows how many rows are in the result?

1. 40
2. 10
3. 20
4. 13

6.The database designer is working on creating the Entity Relationship model, but before doing so, the designer must ___ and enforce appropriate standards to be used in the documentation of the design.

1. Communicate
2. Gather
3. Construct
4. Analyze

7.The term "database development" is used to describe the process of database design and implementation.

1. True
2. False

8.As a database designer, which of the options below would you not include in the implementation phase of a database design?

1. Designing the database
2. Providing for data management
3. Creating the database storage structure
4. Loading data into the database