________ is a database recovery strategy in which human users are asked to repeat all of the database-related tasks that they performed between the time of the last database backup and the time when the database failed.
Select one:
a. Rollforward
b. Partioning
c. Rollback
d. Reprocessing
________ is a database recovery strategy in which human users are asked to repeat all of...
Which process returns the database to a state that is known to be correct? a. recovery b. encryption c. concurrent update d. batch processing What strategy can programs employ to minimize the occurrence of deadlocks? a. Only unlock records at the end of the day. b. Unlock records in the reverse order in which they were locked. c. Use a random order record-locking strategy. d. Lock records in the same order. Which of the following is true about distributed databases?...
subject. Database system
i need the answer for 8 & 9 please.
8. Improve the performance and backup plan for the CUNY database. This database student records enrolled in 24 Colleges. Propose four recommendations to correct or ems identified. You have no budget to purchase additional hardware. You need to make recommendations using hardware already available (15 points) includes 400,000 You will be evaluated based on your improvements in a) performance, b) security, c) backup and d) hardware utilization. You...
Which is the best attribute of a continuity or recovery strategy? a. Uses engineering controls to reduce the effects of a hazard b. One that has been successfully tested c. Does not force major changes in routines or reporting structures d. All of the above
When using BitLocker (without MBAM): Where can Recovery Keys be accessed? a Recovery Key database in AD b Recovery Key tab in the Computer Object's Properties Without a TPM chip, you will need one of these to use BitLocked systems: a USB Flash Drive b 48-Character Password ID Which of these actions does NOT trigger a BitLocker Recovery: a Moving drive to another PC b Changing docking station c Changing boot device d Changing password
Which of the following statements about COMMIT and ROLLBACK commands is incorrect? A. All DML commands (INSERT, UPDATE, DELETE) are explicitly committed and cannot be rolled back. B. All DDL commands (CREATE, TRUNCATE, ALTER TABLE) are explicitly committed and cannot be rolled back. C. A ROLLBACK command will reverse all DDL operations performed since the last COMMIT was performed. D. all of the above
Which method of recovery required concurrent activities? Select one: a. Fast Tracking b. All of these c. Crashing d. Analogous
Lab 3: Securing the Database Environment You have been hired as the DBA for Haphazard, Inc. You are asked to fulfill the following needs of the Database environment. You can choose any database, such as Oracle, MySql, Sqlserver, etc. 1. Users, roles, and privileges need to be added to the database. Identify the statements that would be used for creating the following users, roles, and privileges that match the following requirements: a. Create a user account NLitzinger identified by the...
_ 5. A technician has decided to upgrade all users’ iPhones to the latest model. Which is the FIRST thing the technician should advise the users to do with the old phones before turning them in? A. Back up the mobile data with a cloud backup service. B. Enable remote wipe to clear all personal and corporate data. C. Go into the device settings to remove personal customizations. D. Factory reset the old phones to ensure the data is no...
1. For a one-factor ANOVA comparing the effect of four different treatments on a recovery time from a physical injury, what is stated by the alternative hypothesis (H1)? A. One treatment is significantly more effective in shortening the recovery time. B. There are some significant differences in recovery time after the four treatments. C. All treatments are equally effective in shortening the recovery time. D. There is no significant difference in recovery time after the four treatments. 2.For a one-factor...
1. When using Full and Incremental backups, restoration is performed: a. In the same order starting from the last full backup b. In the reverse order starting from the last incremental backup c. Using mirroring d. None of the above 2. One of the challenges with storing backups for many years is a. Restoring from out dated media b. Protecting the media from theft c. Maintaining the encryption key d. All of the above 3. Database security must be applied...