You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）A、When the instance is started B、When the database is mounted C、When the database is opened D、When the database is closed
You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）
- A、When the instance is started
- B、When the database is mounted
- C、When the database is opened
- D、When the database is closed
相关考题：
What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）A、 MMONB、 LGWRC、 ARCHD、 ARWRE、 COPY
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement： ALTER TABLESPACE data1 BEGIN BACKUP； While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（） A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D、 If you restart the database，the database will not be opened.
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A、’SQL ALTER DATABASE OPEN’；B、SQL ALTER DATABASE ’OPEN’；C、OPEN DATABASE；D、DATABASE OPEN
You work as a database administrator for Certkiller .com. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.
ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）A、Issue ALTER DATABASE BACKUP CONTROLFILE TO filenameB、Make a copy of the control file with the database shut downC、Issue ALTER DATABASE BACKUP CONTROLFILE TO traceD、Make a copy of the control file with the database still running
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block
You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）A、The trace fileB、The fixed viewsC、The data dictionary viewsD、The operating system log fieldsE、The dynamic performance views.
Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）A、 The database writer writes to a trace file， indicating that the temporary file is not found.B、 The database prompts for a database recovery.C、 The database opens normally.D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.
In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）A、Nothing happensB、Oracle will automatically switch redo logs when detected C、Oracle eventually won't allow new records to be added to the database D、The instance crashes
In which situation would you use static database registration for a listener（）A、when multiple databases are to be registered with the listenerB、when DBAs need to connect remotely to start up the database instanceC、when users need to connect the database instance using the host naming methodD、when the database instance that is to be registered with the listener is configured in shared server mode
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（） A、 Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.C、 Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D、 The database will open with the file in hot backup mode. You can restart the backup at any time.E、 The datafile in hot backup mode will be corrupted and you will have to recover it.
When you create a backup control file， where is the resulting file written to？（） A、 The database user dump destination directoryB、 The database diagnostic destination directoryC、 To $ORACLE_HOME/rdbmsD、 To $ORACLE_HOME/adminE、 To the directory and filename you specify in the command
When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（） A、 To indicate the location of the auxiliary-instance online redo logs.B、 To indicate the location of the target database datafiles.C、 To indicate the location of the auxiliary-instance control file and online redo logs.D、 To indicate the location of the auxiliary-instance database datafiles.E、 This is not a valid parameter when duplicating a database.
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）A、RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B、RMAN reads the block change tracking file when it performs both incremental backups.C、RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D、RMAN does not read the block change tracking file when it performs either incremental backup.
Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）A、 DROP TABLESPACE temp1；B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；
You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.B、 Before the instance starts， you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.
You executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5ignorecase=N Which statement describes the purpose of the above password file（）A、It records usernames and passwords of users when granted the DBA role.B、It contains usernames and passwords of users for whom auditing is enabled.C、It is used by Oracle to authenticate users for remote database administration.D、It records usernames and passwords of all users when they are added to OSDBA or OSOPER operatingsystem groups
单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）AWhen the instance is started BWhen the database is mounted CWhen the database is opened DWhen the database is closed
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）AThe DATA1 tablespace is automatically taken out of backup mode when the instance aborts.BIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.CIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.DIf you restart the database, the database will not be opened.
单选题What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）A MMONB LGWRC ARCHD ARWRE COPY
单选题You work as a database administrator for Certkiller .com. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）AYou must have started the database instance in restricted mode.BYou must have started the database instance inNORMALmode.CYou must have started the database instance with server parameter file.DYou must have started the database instance but must not have mounted.EYou must have started the database instance but must not have opened.
多选题Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）AThe database opens normally.BThe database prompts for a database recovery.CThe database writer writes to a trace file， indicating that the temporary file is not found.DThe database gets mounted and throws an error indicating that the temporary file requires recovery.
单选题When you create a backup control file， where is the resulting file written to？（）A The database user dump destination directoryB The database diagnostic destination directoryC To $ORACLE_HOME/rdbmsD To $ORACLE_HOME/adminE To the directory and filename you specify in the command
单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A’SQL ALTER DATABASE OPEN’；BSQL ALTER DATABASE ’OPEN’；COPEN DATABASE；DDATABASE OPEN
单选题When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）A To indicate the location of the auxiliary-instance online redo logs.B To indicate the location of the target database datafiles.C To indicate the location of the auxiliary-instance control file and online redo logs.D To indicate the location of the auxiliary-instance database datafiles.E This is not a valid parameter when duplicating a database.
单选题You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）ARMAN reads the block change tracking file only when it performs the incremental level 0 backup.BRMAN reads the block change tracking file when it performs both incremental backups.CRMAN reads the block change tracking file only when it performs the incremental level 1 backup.DRMAN does not read the block change tracking file when it performs either incremental backup.