Database Administration (DBA) MCQs
1. What does ACID stand for in database transactions?
A) Atomicity, Consistency, Isolation, Durability
B) Accuracy, Consistency, Isolation, Durability
C) Atomicity, Consistency, Integrity, Durability
D) Atomicity, Consistency, Isolation, Data Integrity
2. Which SQL command is used to remove a table from a database?
A) DELETE
B) DROP
C) REMOVE
D) TRUNCATE
3. What is the purpose of normalization in a database?
A) To increase data redundancy
B) To reduce data redundancy and improve data integrity
C) To create more tables
D) To speed up queries
4. Which of the following is a type of SQL join?
A) INNER JOIN
B) OUTER JOIN
C) LEFT JOIN
D) RIGHT JOIN
5. What is a primary key?
A) A key used to sort records
B) A key that uniquely identifies each record in a table
C) A key from another table
D) A key that links two tables
6. What is a foreign key?
A) A primary key in a table
B) A non-unique field
C) A field that references the primary key of another table
D) A column with no constraints
7. Which ACID property ensures that a transaction is treated as a single,
indivisible unit of work?
A) Atomicity
B) Consistency
C) Isolation
D) Durability
8. What is the purpose of an index in a database?
A) To delete data
B) To encrypt records
C) To improve query performance D) To backup data
9. Which SQL statement is used to remove all records from a table without
logging individual row deletions?
A) DELETE
B) REMOVE
C) DROP
D) TRUNCATE
10. What is a stored procedure?
A) A type of index
B) A precompiled collection of one or more SQL statements stored in the database
C) A command to delete records
D) A tool for database backup
11. What is the purpose of a transaction log in a database?
A) To store user data
B) To record all changes made to the database
C) To manage table definitions
D) To perform backups
12. What is the purpose of checkpointing in a database?
A) To periodically write modified data blocks to disk, reducing the work needed for recovery
B) To encrypt sensitive data
C) To monitor user access
D) To delete obsolete records
13. What is the role of a Database Administrator (DBA)?
A) Developing applications
B) Writing SQL queries
C) Managing hardware resources
D) Ensuring database availability and performance
14. Which tool is commonly used for Oracle database administration tasks, such
as backup and recovery?
A) Oracle Enterprise Manager (OEM)
B) SQL*Plus
C) SQL Developer
D) Toad
15. In Oracle, what is the purpose of the Control File?
A) Manage database structures and transactions
B) Store user data
C) Manage table definitions
D) Perform backups
16. Which Oracle background process is responsible for writing committed data
to the database’s data files?
A) SMON (System Monitor)
B) DBWR (Database Writer)
C) LGWR (Log Writer)
D) PMON (Process Monitor)
17. What is the purpose of the redo log files in Oracle?
A) Store backup data
B) Store user data
C) Record changes made to the database
D) Manage user access
18. What is the primary responsibility of the DBA role in Oracle?
A) Hardware maintenance
B) Developing applications
C) Writing SQL queries
D) Managing database objects and users
19. In Oracle, what is the role of the redo log buffer?
A) Manage database security
B) Store committed changes temporarily before writing to redo log files
C) Store SQL statements
D) Store user data
20. What is the purpose of the Oracle Automatic Storage Management (ASM)?
A) Manage database backups
B) Simplify storage management for Oracle databases
C) Manage hardware resources
D) Manage user accounts
🌐 Web Administration MCQs
21. What is the role of a DNS server?
A) Store website content
B) Secure HTTP connections
C) Translate domain names into IP addresses
D) Host email services
22. Which protocol is used to transfer web pages?
A) FTP
B) SMTP
C) HTTP
D) DHCP
23. Which of the following ensures secure communication over the web?
A) HTTP
B) TCP
C) SSL/TLS
D) FTP
24. Which server software is most commonly used for hosting websites?
A) Oracle
B) Nginx
C) Apache
D) MongoDB
25. What does a firewall do?
A) Encrypt data
B) Monitor website traffic
C) Block unauthorized access
D) Serve static files
26. What is the function of a CDN (Content Delivery Network)?
A) Hosting databases
B) Increasing traffic
C) Delivering content faster by using distributed servers
D) Managing domains
27. What is version control used for in web development?
A) Deploying to servers
B) Tracking changes in source code
C) Encrypting code
D) Monitoring bandwidth
28. What is the purpose of SSL/TLS in web administration?
A) To encrypt data transmitted over the internet
B) To store user data
C) To manage server hardware
D) To monitor website traffic
29. Which of the following is a common web server software?
A) Apache HTTP Server
B) MySQL
C) MongoDB
D) Redis
30. What does HTTP stand for?
A) HyperText Transfer Protocol
B) Hyper Transfer Text Protocol
C) Hyper Transfer Transmission Protocol
D) None of the above
31. What is a virtual host in web server configuration?
A) A physical server
B) A method to host multiple domains on a single server
C) A type of DNS record
D) A security protocol
32. What is the purpose of a .htaccess file in Apache?
A) To configure server hardware
B) To manage user accounts
C) To configure directory-level settings and URL rewriting
D) To store website content