A. NOLOG mode
B. NOARCHIVELOG mode
C. LOGGING mode
D. HOTDATABASE mode
E. ARCHIVELOG mode
您可能感兴趣的试卷
你可能感兴趣的试题
You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon.
Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup？（）
A. Create a manual incremental online database backup.
B. Back up all the archived redo logs generated since the 8 a.m. backup.
C. Create a brand-new backup after all the changes have been applied.
D. There is no way to make the changes recoverable based on the 8 a.m. backup.
E. Perform an online backup of the tablespace（s） that contained changed data.
A. alter tablespace MY_DATA begin backup
B. alter tablespace MY_DATA start backup
C. alter tablespace MY_DATA backup begin
D. alter MY_DATA begin backup
E. You cannot back up individual tablespaces
When performing an online backup，what is the proper order of the following steps？（）
a. Issue the alter database end backup command.
b. Back up the archived redo logs.
c. Issue the alter database begin backup command.
d. Back up the database files.
e. Determine the beginning log sequence number.
f. Determine the ending log sequence number.
g. Force a log switch with the alter system switch logfile command.
A.a， b， c， d， e， f， g
B.c， d， a， b， e， g， f
C.f， d， b， g， a， c， e
D.e， c， d， a， g， f， b
E.a， f， b， g， e， c， d
A. Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.
B. Just back up the database datafiles without shutting down the database.
C. You will have to wait until you can shut down the database to perform the backup.
D. Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
E. Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（）
SQL> select group_number， name， state from v$ASM_DISKGROUP；
GROUP_NUMBER NAME STATE
0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED
A. The DGROUP1 disk group was unmounted by another DBA.
B. A datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
C. One of the redundant disks （DGROUP1） has been lost in a disk group.
D. This query has no meaning in an ASM instance.
E. A disk associated with a disk group was discovered after the ASM instance initially opened.
You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch.
What do you do？（）
A. Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.
B. Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to its original value.
C. You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.
D. If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.
E. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
A. The command fails unless you specify the FORCE option.
B. The command fails unless you specify the REUSE option.
C. The command must be reissued with a more specific discovery string.
D. The other disks， already part of the disk group，are ignored.
A. ADD DIRECTORY
B. DROP DISK
C. RESIZE DISK
D. REBALANCE
E. ADD FAILGROUP
A. Issue the ALTER DISKGROUP ... ADD DISK command.
B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.
C. Issue the ALTER DISKGROU
D. Retrieve the disk from the Recycle Bin after the operation completes.
A. All types of files are spread across all disks in the disk group.
B. Datafiles
C. Redo log files
D. Archived redo log files
E. Control files
最新试题
Which three statements are true about persistent configuration？（）
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）
In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this： 1） Mount the database 2） Take the data file offline 3） Bring the data file online 4） Use the RMAN SWITCH TO command to switch the image copy 5） Apply the archived redo logs 6） Open the database 7） Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow？（）
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（）
Which three functions are performed by the SQL Tuning Advisor？（）
Examine the following ALTER command： SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS； What is the purpose of the command？（）
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）
In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data？（）
Which three tasks can be performed using a duplicate database？（）
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch？（）