Nursing homework help

Nursing homework help. 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 .

 

1. INSERT SELECT
2. COMMIT d. UPDATE

 

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

 

1. INSERT SELECT
2. COMMIT d. UPDATE

 

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

 

1. INSERT SELECT
2. COMMIT d. UPDATE

 

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

 

1. LIST * FROM PRODUCT SELECT * FROM PRODUCT
2. 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 _____.

 

1. INSERT SELECT
2. COMMIT d. UPDATE

 

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

 

1. COMMIT; RESTORE; COMMIT; BACKUP;
2. COMMIT; ROLLBACK; d. ROLLBACK;

 

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

 

1. BETWEEN IS NULL
2. LIKE d. NOT NULL

 

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

 

1. COUNT AVG
2. MAX d. SUM

 

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

 

1. systems development database development
2. network development d. enterprise development

 

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

 

1. two three
2. four d. five

 
11.The initial assessment and the feasibility study are part of the Systems Development Life Cycle’s
(SDLC’s) ………….. phase.
 

1. Planning 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
 

1. planning analysis
2. implementation d. maintenance

 

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

Cycle (SDLC).
 

1. planning analysis
2. implementation d. maintenance

 

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

Development Life Cycle (SDLC).
 

1. planning analysis
2. detailed systems design d. implementation

 

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

 

1. database initial study
   1. database design
   2. testing, and evaluation
   3. operation

 

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

 

1. maintenance and evolution operation
2. 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.
 

1. programmer b. manager
2. database administrator d. systems administrator

 
Short Essay 
10 points each (50 points)
 

• List and describe the levels of database backup.

 

• List and describe Logical design and Physical design steps.

 

• List and describe security goals for database.

 

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

 

• List and describe the DBA’s managerial role.

Nursing homework help