Module 16 Quiz
How is a data administrator (DA) different than a database administrator (DBA)? a. They are virtually the same role within an organization. b. The DA's role covers more operations than the DBA's because the DA controls data outside the scope of the DBMS in addition to computerized data. c. The DA always reports to the DBA. d. The DBA usually is given a higher degree of responsibility and authority than the DBA.
b
Which of the following is not a benefit of CASE tools? a. A reduction in development time and costs b. Automation of the SDLC c. Standardization of applications implementation d. Easier maintenance of application systems developed with CASE tools e. All of the above f. None of the above
c
Which of the following is not a database administration tool? a. Database monitoring b. Database performance tuning c. Database bottleneck automatic resolution d. Database data extraction, transformation, and loading
c
Which of the following is not a security safeguard? a. Changing default system passwords b. Applying the latest patches c. Making sure that all required services are running d. Securing installation folders with proper access rights.
c
Which of the following is not an DBA activity for managing cloud-base data services? a. DBMS installation and updates b. Server/network management c. Data storage administration d. Backup and recovery operations
c
Which of the following is not a procedure of user access management? a. Defining each user to the database b. Assigning passwords to each user c. Defining user groups d. Assigning access privileges e. Assigning user profile f. All of the above. g. None of the above.
e
Which of the following statements about database administrators is false? a. The DBA is the person responsible for planning, organizing, controlling, and monitoring the centralized and shared corporate database. b. The DBA is the general manager of the database administration department. c. The DBA is probably the most dynamic function in an organization, and there is no standard for how the DBA function fits into an organization structure. d. All of the above e. None of the above
e
An active data dictionary is best defined as _____. a. a data dictionary that is automatically updated by the database management system every time the database is accessed b. a data dictionary that usually requires running a batch process c. a data dictionary that requires a command initiated by an end user to update its data access statistics d. a data dictionary that uses an application to update data access statistics
A
What are the three goals of data security? a. Confidentiality, Integrity, and Availability b. Compliance, Integrity, and Availability c. Confidentiality, Intrusion, and Accessibility d. Compliance, Intrusion, and Accessibility
a
