Discussion
Home ‣ Database ‣ Data and Database Administration Comments
- Question
Which of the following is part of an administrative policy to secure a database?
Options- A. Authentication policies
- B. Limiting particular areas within a building to only authorized people
- C. Ensure appropriate responses rates are in external maintenance agreements
- D. All of the above.
- Correct Answer
- All of the above.
- 1. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
Options- A. Rollback
- B. Rollforward
- C. Switch to duplicate database
- D. Reprocess transactions Discuss
- 2. Which of the following could cause data to be unavailable?
Options- A. Data becoming lost or inaccurate
- B. The database server
- C. Planned database maintenance activities
- D. All of the above. Discuss
- 3. Common Gateway Interface (CGI) is which of the following?
Options- A. An interface that accepts and returns data that may be written in SQL.
- B. An interface that accepts and returns data that may be written in any language that produces an executable file.
- C. A small program that executes within another application and is stored on the server.
- D. A small program that executes within another application and is stored on the client. Discuss
- 4. What is Hypertext Transfer Protocol (HTTP)?
Options- A. The protocol to copy files between computers
- B. The transfer protocol to transfer Web pages to a browser
- C. The database access protocol for SQL statements
- D. The hardware/software protocol that limits access to company data Discuss
- 5. A proxy server is used for which of the following?
Options- A. To provide security against unauthorized users
- B. To process client requests for Web pages
- C. To process client requests for database access
- D. To provide TCP/IP Discuss
- 6. Performance analysis and tuning is which of the following?
Options- A. Undertaken one time at the time of a DBMS installation
- B. Undertaken one time at the time of the implementation of a new application
- C. Undertaken as an ongoing part of the backup of a database
- D. Undertaken as an ongoing part of managing a database Discuss
- 7. Concurrency control is important for which of the following reasons?
Options- A. To ensure data integrity when updates occur to the database in a multiuser environment
- B. To ensure data integrity when updates occur to the database in a single-user environment
- C. To ensure data integrity while reading data occurs to the database in a multiuser environment
- D. To ensure data integrity while reading data occurs to the database in a single-user environment Discuss
- 8. Which of the following is the preferred way to recover a database after a system failure?
Options- A. Rollback
- B. Rollforward
- C. Switch to duplicate database
- D. Reprocess transactions Discuss
- 9. Which of the following is true concerning open-source DBMS?
Options- A. Is free or nearly free database software whose source code is publicly available
- B. Is free or nearly free database software whose source code is not publicly available
- C. Is not competitive against PC-oriented packages and is fully SQL compliant
- D. Is competitive against PC-oriented packages and is not fully SQL compliant Discuss
- 10. A shared lock allows which of the following types of transactions to occur?
Options- A. Delete
- B. Insert
- C. Read
- D. Update Discuss
Data and Database Administration problems
Search Results
Correct Answer: Rollback
Correct Answer: All of the above.
Correct Answer: An interface that accepts and returns data that may be written in any language that produces an executable file.
Correct Answer: The transfer protocol to transfer Web pages to a browser
Correct Answer: To provide security against unauthorized users
Correct Answer: Undertaken as an ongoing part of managing a database
Correct Answer: To ensure data integrity when updates occur to the database in a multiuser environment
Correct Answer: Switch to duplicate database
Correct Answer: Is free or nearly free database software whose source code is publicly available
Correct Answer: Read
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.