7494961
Descripción
Test por Jamonero Blanco, actualizado hace más de 1 año
|
Creado por Jamonero Blanco
hace alrededor de 7 años
|
|
Pregunta 1
Pregunta
1. Among the failure events, which is the most serious and may cause data loss?
Respuesta
-
A. The loss of an entire redo log-file group but no loss in any other group
-
B. The loss of one member of each redo log-file group
-
C. The failure of the ARCn background process
-
D. The failure of the LGWR background process
Pregunta 2
Pregunta
2. When the database is in ARCHIVELOG mode, database recovery is possible up to which
event or time?
Respuesta
-
A. The last redo log file switch
-
B. The last checkpoint position
-
C. The last commit
-
D. The last incremental backup using RMAN
Pregunta 3
Pregunta
3. Which is a true statement regarding image copies and backup sets.
Respuesta
-
A. An image copy stores one data file per image copy, and a backup set can store many data files in a single file.
-
B. An image copy stores one data file per image copy, and a backup set consists of one file per data file backed up.
-
C. Both image copies and backup sets use a single file to store all objects to be backed up.
-
D. A backup set stores each data file in its own backup file, but an image copy places all data files into a single output file.
Pregunta 4
Pregunta
4. Which of the following is not a step in configuring your database to archive redo
log files?
Respuesta
-
A. Place the database in ARCHIVELOG mode.
-
B. Multiplex the online redo log files.
-
C. Specify a destination for archived redo log files.
-
D. Specify a naming convention for your archived redo log files.
Pregunta 5
Pregunta
5. Why are online backups known as inconsistent backups?
Respuesta
-
A. Because not all control files are synchronized to the same SCN until the database is shut down
-
B. Because both committed and uncommitted transactions are included in a backup when the database is online
-
C. Because a database failure while an online backup is in progress can leave the database in an inconsistent state
-
D. Because online backups make copies of data files while they are not consistent with the control file
Pregunta 6
Pregunta
6. Which of the following initialization parameters specifies the location where the
control file trace backup is sent?
Respuesta
-
A. DIAGNOSTIC_DEST
-
B. BACKGROUND_DUMP_DEST
-
C. LOG_ARCHIVE_DEST
-
D. CORE_DUMP_DEST
Pregunta 7
Pregunta
7. Which of the following pieces of information is not available in the control file?
Respuesta
-
A. Instance name
-
B. Database name
-
C. Tablespace names
-
D. Log sequence number
Pregunta 8
Pregunta
8. Which statement adds a member /logs/redo22.log to redo log-file group 2?
Respuesta
-
A. ALTER DATABASE ADD LOGFILE '/logs/redo22.log' TO GROUP 2;
-
B. ALTER DATABASE ADD LOGFILE MEMBER '/logs/redo22.log' TO GROUP 2;
-
C. ALTER DATABASE ADD MEMBER '/logs/redo22.log' TO GROUP 2;
-
D. ALTER DATABASE ADD LOGFILE '/logs/redo22.log';
Pregunta 9
Pregunta
9. To place the database into ARCHIVELOG mode, in which state must you start the
database?
Respuesta
-
A. MOUNT
-
B. NOMOUNT
-
C. OPEN
-
D. SHUTDOWN
-
E. Any of the above
Pregunta 10
Pregunta
10. Which of the following substitution-variable formats are always required for specifying
the names of the archived redo log files? Choose all that apply.
Respuesta
-
A. %d
-
B. %s
-
C. %r
-
D. %t
Pregunta 11
Pregunta
11. Which of the following initialization parameters controls the mean time to recover the
database, in seconds, after an instance failure?
Respuesta
-
A. FAST_START_IO_TARGET
-
B. LOG_CHECKPOINT_TIMEOUT
-
C. FAST_START_MTTR_TARGET
-
D. MTTR_TARGET_ADVICE
-
E. FAST_START_TARGET_MTTR
Pregunta 12
Pregunta
12. Identify the statement that is not true regarding the loss of a control file.
Respuesta
-
A. A damaged control file can be repaired by using one of the remaining undamaged control files, assuming there are at least two copies of the control file.
-
B. The missing or damaged control file can be replaced while the instance is still active.
-
C. You can temporarily run the instance with one fewer control file, as long as you remove one of the references to the missing control file in the spfile or init.ora file.
-
D. An instance typically fails when one of the multiplexed control files is lost or damaged.
Pregunta 13
Pregunta
13. Which failures can be detected by the Data Recovery Advisor, which then provides
repair recommendations? Choose all that apply.
Respuesta
-
A. Instance failure
-
B. Accidental deletion of a data file
-
C. Disk containing one redo log member is offline
-
D. User accidentally dropped a table
Pregunta 14
Pregunta
14. The instance can still be started even if some data files are missing; this rule does not
apply to which tablespaces? (Choose all that apply.)
Respuesta
-
A. USERS
-
B. SYSTEM
-
C. TEMP
-
D. SYSAUX
-
E. UNDO
Pregunta 15
Pregunta
15. Select the statement that is not true regarding media failure. A media failure occurs when:
Respuesta
-
A. The network card on the server fails.
-
B. The DBA accidentally deletes one of the data files for the SYSTEM tablespace.
-
C. There is a head crash on all physical drives in the RAID controller box.
-
D. A corrupted track on a CD containing a read-only tablespace causes a query to fail.
Pregunta 16
Pregunta
16. Choose the correct statement about the Data Recovery Advisor.
Respuesta
-
A. The Data Recovery Advisor is a standalone tool.
-
B. The Data Recovery Advisor does not support RAC databases.
-
C. The CHANGE FAILURE command can be used in a SQL*Plus session.
-
D. The REPAIR FAILURE command works only after LIST FAILURE .
Pregunta 17
Pregunta
17. Place the following events or actions leading up to and during instance recovery in the
correct order.
1. The database is opened and available.
2. Oracle uses undo segments in the undo tablespace to roll back uncommitted trans-
actions.
3. The DBA issues the STARTUP command at the SQL*Plus prompt.
4. Oracle applies the information in the online redo log files to the data files.
Respuesta
-
A. 4, 3, 2, 1
-
B. 3, 4, 1, 2
-
C. 2, 1, 3, 4
-
D. 2, 1, 4, 3
-
E. 3, 2, 4, 1
-
F. 3, 4, 2, 1
Pregunta 18
Pregunta
18. You’ve noticed that when an instance crashes, it takes a long time to start up the data-
base. Which advisor can be used to tune this situation?
Respuesta
-
A. The Undo Advisor
-
B. The SQL Tuning Advisor
-
C. The Database Tuning Advisor
-
D. The MTTR Advisor
-
E. The Instance Tuning Advisor
Pregunta 19
Pregunta
19. In ARCHIVELOG mode, the loss of a data file for any tablespace other than the SYSTEM or
UNDO tablespace affects which objects in the database?
Respuesta
-
A. The loss affects only objects whose extents reside in the lost data file.
-
B. The loss affects only the objects in the affected tablespace, and work can continue in other tablespaces.
-
C. The loss will not abort the instance but will prevent other transactions in any tablespace other than SYSTEM or UNDO until the affected tablespace is recovered.
-
D. The loss affects only those users whose default tablespace contains the lost or damaged data file.
Pregunta 20
Pregunta
20. Which of the following conditions prevents the instance from progressing through the
NOMOUNT , MOUNT , and OPEN states?
Respuesta
-
A. One of the redo log-file groups is missing a member.
-
B. The instance was previously shut down uncleanly with SHUTDOWN ABORT .
-
C. Either the spfile or init.ora file is missing.
-
D. One of the five multiplexed control files is damaged.
-
E. The USERS tablespace is offline, with one of its data files deleted.
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.