单选题Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A user-managed backups.B partial database backups.C consistent database backups.D inconsistent database

第1题：

Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）

• A、user-managed backups.
• B、partial database backups.
• C、consistent database backups.
• D、inconsistent database backups.

第2题：

You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）

• A、The database must be opened in restricted mode.
• B、The database must be configured to run in ARCHIVELOG mode.
• C、The tablespaces are required to be in backup mode before taking the backup.
• D、The tablespaces are required to be in read-only mode before taking the backup

第3题：

第4题：

Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）

• A、The backup will consist of used data blocks only.
• B、The database must be shut down to accomplish the backup.
• C、The backup can be accomplished without shutting down the database.
• D、The backup will contain all database files that have never been backed up.

第5题：

You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

• A、The database crashes.
• B、The DBA needs to re-create the file.
• C、The file gets re-created automatically.
• D、The file gets restored automatically from the last backup.
• E、The DBA needs to perform a complete database recovery.
• F、The DBA needs to perform an incomplete database recovery.

第6题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

• A、Hot backup
• B、Online backup
• C、consistent backup
• D、incremental backup
• E、inconsistent backup

第7题：

Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）

• A、You can perform online whole database backups.
• B、You can performofflinewhole database backups.
• C、You cannot perform schema-level export/import operations.
• D、You can perform the backup of only the SYSTEM tablespace when the database is open.

第8题：

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

• A、You must have change tracking enabled in your database
• B、Your database must be running in NOARCHIVELOG mode
• C、To back up a tablespace, it must be in backup mode
• D、To back up a tablespace, it must first be taken offline

第9题：

You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

• A、You can perform consistent backups only.
• B、You can perform a complete database backup without shutting down the database instance.
• C、You can back up data files only when all data files have the same SCN recorded in the control file.
• D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

第10题：

You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

• A、The database must be opened in restricted mode.
• B、The database must be configured to run in ARCHIVELOG mode.
• C、The tablespaces are required to be in backup mode before taking the backup.
• D、The tablespaces are required to be in read-only mode before taking the backup