DataBase Administrator 18 Jul,2023 boomtecho2@gmail.comLeave a comment Please enter your email: 1. Which statement true about Database Administrator? is responsible for understanding and managing the overall database environment is responsible for maintaining, securing, and operating databases is a vital component of the IT environment for any organization that relies on one or more database management systems A & B are true All of the above 2. Which is type of Database Administrator? Architect Data Modeler Database Analyst Data Warehouse DBA All of the Above 3. Which one correct role of DBA in DBMS? Database design Managing table maintenace All of the above 4. Which skill are involve in a BEST DATABASE ADMINISTRATOR. Knowledge on different operating servers. Ready to face challenges and solve the problems quickly Knowledge of Structured Query Language (SQL) all of the above 5. poor database Administrator can lead to which of the following single definition of same data type familiarity existing data missing data elements All of the above 6. A traditional data Administrator perform which of the following roles? tune database performance establish backup and recovery procedure resolve data ownership issues protect data security of the database 7. if both data and Database Administration exist in an organization , the database Administrator is responsible for which of the following ? Data Modeling Database design Metadata All of the Above 8. Which of the following responsibility of DBA? support to the users storage structure and access strategy. both A and B none of the above 9. select the role of DBA Implementation Trainning Design A ,B and C all None of the Above 10. Failure to control confidentiality may lead to loss competitiveness true false 11. Databases overall structure is maintained in a file called Redolog file data file control file All of the above 12. Which of the following application runs the database application that accesses database information and interacts with a user? client server system All of the above 13. The database administrator who authorizes all the new users, modifies database and takes grants privilege is Super user Administrator Operator of operating system All of the mentioned Loading …
