-
Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member. When you attempt to start the database, you receive the following errors:()
A . ALTER DATABASE DROP LOGFILE GROUP 1
B . ALTER DATABASE CLEAR LOGFILE GROUP 1
C . ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
D . ALTER DATABASE DROP LOGFILE MEMBER ’D:\REDO01.LOG&rsquo
-
If you create your database using Oracle Managed Files (OMF), what is true?()
A . You must use Oracle predefined names to identify raw partitions that will hold OMF structures.
B . You must define directories for two online redo log groups and three copies of the control file.
C . If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.
D . You must use only OMF data files when adding new tablespaces or data files to your database in the future.
-
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file, current SPFILE file, data files, and archived redo log
-
You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()
A . The backup is similar to image copy.
B . The backup contains all used data blocks.
C . The backup contains only unused data blocks.
D . The backup contains all data blocks changed since the last incremental level 1 backup.
-
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()
A . Oracle Net Manager
B . Listener Control utility
C . Database Configuration Assistant
D . Oracle Net Configuration Assistant
-
Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command?()
A . The command would return an error because LOG_BUFFER is a static parameter.
B . The parameter value would be changed and it would come into effect immediately.
C . You need to restart the database so that parameter changes can come into effect.
D . The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
-
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()
A . Restore and recover the datafile.
B . Restore and recover the tablespace.
C . Restore and recover the database.
D . Restore and recover the control file.
E . Restore and recover the parameter file.
-
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
A . renaming the control files
B . dropping a user in your database
C . enabling or disabling redo log archiving
D . dropping a tablespace in your database
E . re-creating the control files, after you lost all the control files in your database
-
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()
A . backup of offline tablespaces
B . backup of readonly tablespaces
C . backup of systemcritical tablespaces
D . backup of online, locally managed tablespaces
E . backup of read/write dictionarymanaged tablespace
-
You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()
A . Archiving will be disabled because the destination for the redo log files is missing.
B . The database instance will shut down and the error details will be logged in the alert log file.
C . Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.
D . Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.
-
Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()
A . You can perform open database backups.
B . You can perform closed database backups.
C . You cannot perform schema-level logical backups.
D . You can perform the backup of only the SYSTEM tablespace when the database is open.
-
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()
A . Backup of offline tablespaces.
B . Backup of read-only tablespaces.
C . Backup of system-critical tablespaces.
D . Backup of online, locally managed tablespaces.
E . Backup of read/write dictionary-managed tablespaces.
-
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 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 backu
-
our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()
A . Oracle Net Manager
B . Listener Control utility
C . Database Configuration Assistant
D . Oracle Net Configuration Assistant
-
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()
A . Oracle Net Manager
B . Listener Control utility
C . Database Configuration Assistant
D . Oracle Net Configuration Assistant
-
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage?()
A . You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
B . You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
C . You can use the SWITCH DATABASE TO COPY Recovery Manager (RMAN) command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
D . You cannot use Recovery Manager (RMAN) to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
-
Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()
A . The SGA advisor will be disabled.
B . The MTTR advisor will be disabled.
C . Automatic checkpoint tuning will be disabled.
D . Checkpoint information will not be written to the alert log file.
-
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()
A . Restore and recover the datafile.
B . Restore and recover the tablespace.
C . Restore and recover the database.
D . Restore and recover the control file.
E . Restore and recover the parameter file.
-
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified?()
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file,current SPFILE file,data files,and archived redo log
-
The online redo log group configuration for your database is as follows: What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database?()
A . The database will hang.
B . The database will be crashed.
C . The database will be shut down.
D . The LGWR process writes redo log entries to the other redo log member of the Group2 grou
-
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command: RESTORE CONTROLFILE FROM AUTOBACKUP; Which of the following statements is true?()
A . The command restores only the missing control file.
B . The command restores all the control files.
C . The command fails because the database is running.
D . This is the correct way to address this problem.
E . This is not the correct way to address this problem.
-
Your database instance is started using the server parameter file (SPFILE). You executed acommand to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command()
A . The command succeeds only if Automatic Memory Management is not enabled.
B . The command succeeds, but you need to restart the database for changes to take effect.
C . The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D . The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
-
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()
A . User process
B . Server process
C . System Monitor (SMON)
D . Process Monitor (PMON)
E . Checkpoint process (CKPT)
-
Flashback is enabled for your multitenant container database (CDB), which contains two plu
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema?()
A. Only 1
B. Only 2
C. Only 3
D. 3 and 1
E. 1 and 2