TestPassPort 1z0-052 試験Q&A (81)

82. You are managing an Oracle Database 11g database with the following backup strategy: 1) On Sunday, an incremental level 0 tape backup is performed. 2) Monday through Saturday, a cumulative incremental level 1 tape backup is performed. Which two statements are true regarding the backups performed? (Choose two.) A.The backup performed in Continue reading

TestPassPort 1z0-052 試験Q&A (80)

81. You are managing an Oracle Database 11g database with this backup strategy: – Every Sunday night, level 0 backup is performed. – On Monday night and subsequent days, level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday’s backup is true? A.The backup contains all the used blocks. […]

TestPassPort 1z0-052 試験Q&A (79)

80. You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape. Which two statements are true about differential incremental backups? (Choose two.) A.The backup performed on Sundays contains all the blocks that have ever been used in the database. B.The backup performed on […]

TestPassPort 1z0-052 試験Q&A (78)

79. You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups? (Choose two.) A.You can perform consistent backups only. B.You can perform a complete database backup without shutting down the […]

TestPassPort 1z0-052 試験Q&A (77)

78. You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.) A.The backups would be consistent. B.The backups would be inconsistent. C.The backups would be possible only if the database is running in ARCHIVELOG […]

TestPassPort 1z0-052 試験Q&A (76)

77. You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error? A.The MTTR Advisor is disabled. B.The database is […]

TestPassPort 1z0-052 試験Q&A (75)

76. 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 […]

TestPassPort 1z0-052 試験Q&A (74)

75. Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file? A.Take the USERS tablespace […]

TestPassPort 1z0-052 試験Q&A (73)

74. The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server: LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ‘/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files? A.It will be created on the local file […]

TestPassPort 1z0-052 試験Q&A (72)

73. You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.) A.You must shut down the database instance to perform the backups. B.You must configure the Flash Recovery Area (FRA) for the database. C.You can perform complete database […]