To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository. The typical roles of a database administrator and redesigning existing applicationsġ6. The typical roles of a data administrator and redesigning existing applicationsĭ. The time to make a decision and the typical roles of a database administratorĬ. The time to make a decision but not the typical roles of a database administratorī. A data warehouse administrator is concerned with which of the following? | Database Administration McqsĪ. Which of the following is the preferred way to recover a database after a system failure? | Database Administration Mcqsġ5. To ensure data integrity while reading data occurs to the database in a single-user environmentġ4. To ensure data integrity while reading data occurs to the database in a multiuser environmentĭ.
To ensure data integrity when updates occur to the database in a single-user environmentĬ. To ensure data integrity when updates occur to the database in a multiuser environmentī. Concurrency control is important for which of the following reasons? | Database Administration McqsĪ. Is competitive against PC-oriented packages and is not fully SQL compliantġ3. Is not competitive against PC-oriented packages and is fully SQL compliantĭ.
#DATABASE ADMINISTRATOR SOFTWARE#
Is free or nearly free database software whose source code is not publicly availableĬ. Is free or nearly free database software whose source code is publicly availableī.
Which of the following is true concerning open-source DBMS? | Database Administration McqsĪ. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? | Database Administration Mcqsġ2. Undertaken as an ongoing part of managing a databaseġ1. Undertaken as an ongoing part of the backup of a databaseĭ. Undertaken one time at the time of the implementation of a new applicationĬ. Undertaken one time at the time of a DBMS installationī. Performance analysis and tuning is which of the following? | Database Administration McqsĪ. Locking may cause which of the following problems? | Database Administration Mcqsġ0. A shared lock allows which of the following types of transactions to occur? | Database Administration Mcqsĩ. Planned database maintenance activitiesĨ. Which of the following could cause data to be unavailable? | Database Administration McqsĬ. The transaction log includes which of the following? | Database Administration McqsĬ. Switching to an existing copy of the databaseĦ. Where the after-images and before-images are applied to the databaseĭ. Where the after-images are applied to the databaseĬ. Where the before-images are applied to the databaseī. Backward recovery is which of the following? | Database Administration McqsĪ.
Ensure appropriate responses rates are in external maintenance agreementsĥ. Limiting particular areas within a building to only authorized peopleĬ. Which of the following is part of an administrative policy to secure a database? | Database Administration Mcqsī. If both data and database administration exist in an organization, the database administrator is responsible for which of the following? | Database Administration McqsĤ. Establish backup and recovery proceduresģ. A traditional data administrator performs which of the following roles? | Database Administration Mcqsī. A single definition of the same data entityĢ. Poor data administration can lead to which of the following? | Database Administration McqsĪ. Quiz Database Administration Test Questionsġ.
#DATABASE ADMINISTRATOR PDF#
Database Administration Objective Questions and Answersĭatabase Administration Objective Questions and Answers Pdf Download for Exam Database Administration Multiple choice Questions.
0 kommentar(er)
