backup database all
backup compressed database
backup as compressed backupset database
backup as compressed backup database plus archivelog all
backup as compressed backupset database plus compress archivelog all
第1题:
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()
第2题:
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()
第3题:
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
第4题:
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第5题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第6题:
when you change the name of a datafile
when you drop a table from the database
when you take an export of the database
when you back up the database using OS utilities
when you issue an ALTER SYSTEM SWITCH LOGFILE statement
when you issue a BACKUP command from inside the RMAN run block
第7题:
rman TARGET / NOCATALOG
rman TARGET sys/password
rman TARGET sys/password AS SYSDBA
rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
第8题:
the time when the last flashback operation in your database was performed
the time when the first flashback operation in your database was performed
a list of flashback operations performed in your database using SCN and time
the approximate time and the lowest system change number (SCN) to which you can flash back your database
第9题:
Datafiles
Current control file
Server parameter file (spfile)
Password file
第10题:
backup database all
backup compressed database
backup as compressed backupset database
backup as compressed backup database plus archivelog all
backup as compressed backupset database plus compress archivelog all
第11题:
configure the database to run in ARCHIVELOG mode
configure the Flash Recovery Area to enable automatic database backup
schedule the database backup using DBMS_JOB package after creating the database
schedule the database backup using Recovery Manager (RMAN)commands after creating the database
schedule the database backup using Database Configuration Assistant (DBCA)while creating the database
第12题:
You need to perform the restore and recover operations manually, because the backup was made manually.
First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database.
First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database.
You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
第13题:
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
第14题:
You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command: RMAN>BACKUP DATABASE; At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command?()
第15题:
You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()
第16题:
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()
第17题:
Start the database in the MOUNT stage.
Back up the control file to trace.
Set the DBID
Issue the RECOVER DATABASE command.
第18题:
cannot be used in RMAN
by starting up the database again
by using the CATALOG command of RMAN
by using the RECOVER CATALOG command in RMAN
by re-creating the target control file to rebuild the RMAN repository
第19题:
Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above, all these files are backed up.
第20题:
by using the RMAN utility
by using the export/import utility
by using the ALTER DATABASE command
by enabling the change tracking feature
第21题:
SQL*Plus
iSQL*Plus
Management Server
Management Repository
Oracle Enterprise Manager 10g Database Control
第22题:
control file
all datafiles
password file
online redo log file
archive redo log file
server parameter file
only the SYSTEM datafile
第23题:
RECOVER DATABASE;
SWITCH DATAFILE ALL;
RESTORE CONTROL FILE;
RECOVER DATABASE USING BACKUP CONTROL FILE;
第24题:
Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above,all these files are backed up