The sql command that allows a user to permanently save data changes is _____.

Final Exam IT 507

Multiple Choices

17 questions, 3 points each

1. The SQL command that allows a user to insert rows into a table is .

a. INSERT b. SELECT

c. COMMIT d. UPDATE

2. The SQL command that allows a user to permanently save data changes is .

a. INSERT b. SELECT

c. COMMIT d. UPDATE

3. The SQL command that allows a user to list the contents of a table is .

a. INSERT b. SELECT

c. COMMIT d. UPDATE

4. To list all the contents of the PRODUCT table, a user would use .

a. LIST * FROM PRODUCT b. SELECT * FROM PRODUCT

c. DISPLAY * FROM PRODUCT d. SELECT ALL FROM PRODUCT

5. The SQL command that modifies an attribute’s values in one or more table’s rows is _____.

a. INSERT b. SELECT

c. COMMIT d. UPDATE

6. The command is used to restore the database to its previous condition.

a. COMMIT; RESTORE; b. COMMIT; BACKUP;

c. COMMIT; ROLLBACK; d. ROLLBACK;

7. The special operator is used to check whether an attribute value is null.

a. BETWEEN b. IS NULL

c. LIKE d. NOT NULL

8. The SQL aggregate function that gives the arithmetic mean for a specific column is .

a. COUNT b. AVG

c. MAX d. SUM

9. The process of creating an information system is known as .

a. systems development b. database development

c. network development d. enterprise development

10. The traditional Systems Development Life Cycle (SDLC) is divided into phases.

a. two b. three

c. four d. five

11.The initial assessment and the feasibility study are part of the Systems Development Life Cycle’s

(SDLC’s) ………….. phase.

b. Planning b. analysis c. detailed systems design d. implementation

12. During what phase of System Development Life Cycle you will ask the following question?

“ What are the requirements of the current system’s end users?” B

a. planning b. analysis

c. implementation d. maintenance

13. The logical systems design is created during the phase of the Systems Development Life

Cycle (SDLC).

a. planning b. analysis

c. implementation d. maintenance

14. The design of the system’s processes is completed during the phase of the Systems

Development Life Cycle (SDLC).

a. planning b. analysis

c. detailed systems design d. implementation

15. Analyzing the company situation is part of the phase of the Database Life Cycle (DBLC).

a. database initial study

b. database design

c. testing, and evaluation

d. operation

16. The last step in the Database Life Cycle (DBLC) is .

a. maintenance and evolution b. operation

c. testing and evaluation d. implementation and loading

17. Once the data has been loaded into the database, the tests and fine-tunes the database for

performance, integrity, concurrent access, and security constraints.

a. programmer b. manager

c. database administrator d. systems administrator

Short Essay

10 points each (50 points)

1) List and describe the levels of database backup.

2) List and describe Logical design and Physical design steps.

3) List and describe security goals for database.

4) What is a trigger? Explain and provide an application example. What is/are views in a database? Explain and provide an application example.

5) List and describe the DBA’s managerial role.