If you use ALTER DISKGROUP … ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?
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.
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
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
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.
As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query? (Choose two.)
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.
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?
A. Put the database in hot backup mode and perform an online backup, including backing up the archived
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
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
You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use?
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.
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.
What are the different logging modes available in Oracle Database 11g? (Choose two.)
A. NOLOG mode
B. NOARCHIVELOG mode
C. LOGGING mode
D. HOTDATABASE mode
E. ARCHIVELOG mode
sys@TEST0910> select log_mode from v$database;
Which is the correct command to put the database in ARCHIVELOG mode?
A. alter database archivelog
B. alter system enable archivelog mode
C. alter database enable archive
D. alter database archivelog enable
E. None of the above
Changing the Database Archiving Mode
To change the archiving mode of the database, use the ALTER DATABASE statement with the ARCHIVELOG or NOARCHIVELOG clause. To change the archiving mode, you must be connected to the database with administrator privileges (AS SYSDBA).
The following steps switch the database archiving mode from NOARCHIVELOG to ARCHIVELOG:
Shut down the database instance.
An open database must first be closed and any associated instances shut down before you can switch the database archiving mode. You cannot change the mode from ARCHIVELOG to NOARCHIVELOG if any data files need media recovery.
Back up the database.
Before making any major change to a database, always back up the database to protect against any problems. This will be your final backup of the database in NOARCHIVELOG mode and can be used if something goes wrong during the change to ARCHIVELOG mode.
Edit the initialization parameter file to include the initialization parameters that specify the destinations for the archived redo log files .
Start a new instance and mount, but do not open, the database.
To enable or disable archiving, the database must be mounted but not open.
Change the database archiving mode. Then open the database for normal operations.
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
Shut down the database.
Back up the database.
Changing the database archiving mode updates the control file. After changing the database archiving mode, you must back up all of your database files and control file. Any previous backup is no longer usable because it was taken in NOARCHIVELOG mode.
What is the correct order of steps to perform an online database backup?
a. alter database begin backup;
b. alter database end backup;
c. Back up the database datafiles.
d. Back up the archive log files.
e. alter system switch logfile;
A. a, b, c, d, e
B. e, d, a, b, c
C. a, c, b, d, e
D. d, b, c, a, e
E. a, c, b, e, d
If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.
|One Time Purchase||✔||✖||✖||✖||✖|
|100% Pass Guarantee||✔||✖||✖||✖||✖|
|100% Money Back||✔||✖||✖||✖||✖|