WDDBA Exam: Database Backup and Recovery

Instruction: Select the correct answer from the given choice. Each question carries 2 points.

1. What is the main focus of database architecture?

A. Writing code for websites. B. Creating user manuals for software. C. Designing and constructing database systems for large enterprises. D. Marketing a company's products online.

2. How is the architecture of a DBMS classified?

A. By its cost and size. B. As either single-tier or multi-tier. C. By the number of users it supports. D. As either manual or automatic.

3. In a single-tier architecture, where do the client, server, and database reside?

A. All on the same machine. B. On three separate machines. C. The client is on a local machine, and the server and database are remote. D. The server and database are on the local machine, and the client is remote.

4. What is a single-tier architecture primarily used for?

A. Large-scale production environments. B. E-commerce websites. C. Enterprise resource planning systems. D. Development of local applications for quick responses.

5. What is a key characteristic of two-tier architecture?

A. It has an intermediate layer between the client and server. B. It is based on a direct client-server communication model. C. The database is exposed directly to the end-user. D. All application elements are in one place.

6. In a two-tier architecture, what is used for interaction between the client-side application and the server-side database?

A. APIs like ODBC and JDBC. B. Web browsers. C. Email protocols. D. Local file systems.

7. What is the responsibility of the server side in a two-tier architecture?

A. Running user interfaces and application programs. B. Managing local data storage. C. Providing a handy tool for end-users. D. Providing functionalities like query processing and transaction management.

8. What is a security benefit of a two-tier architecture?

A. The DBMS is not exposed to the end-user directly. B. All data is stored on the client machine. C. The database is directly available to the user. D. It is the simplest and most direct way to access data.

9. Besides database architecture, what other topics are mentioned in the document as part of Unit One?

A. Advanced SQL queries. B. Website design and development. C. Risks, failure scenarios, and OHS. D. Marketing and sales strategies.

10. In addition to design and construction, what else does database architecture include?

A. Hiring the database administrator. B. Creating a company's financial reports. C. Determining the cost of the database system. D. Setting standards for security and programming aspects.

11. What is the process of protecting a database from unauthorized access or destruction?

A. Database recovery. B. Database backup. C. Database security. D. Database maintenance.

12. What is a lack of data integrity a potential risk for?

A. The database architecture. B. Data accuracy and consistency. C. The speed of the server. D. The user's application.

13. Which process restores a database to a consistent state after a failure?

A. Database recovery. B. Data backup. C. Data migration. D. Database optimization.

14. What is a key component of a disaster recovery plan for a database?

A. The database's design blueprint. B. The number of clients supported. C. The programming language used. D. A plan for backing up and restoring data.

15. What is the process of creating duplicate copies of data to protect against loss?

A. Data synchronization. B. Data backup. C. Data encryption. D. Data validation.

Exam Results

Your Score: /

Correct Answers:

Incorrect Answers:

Review your answers below: