网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
考题
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.
考题
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.
考题
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
考题
When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）A、Size of typical transactions B、Concurrent transactions C、Size of rows in table most frequently changed D、Number of anticipated disk sorts
考题
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
考题
单选题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.
考题
单选题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
考题
单选题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.
考题
单选题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.
考题
单选题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.
考题
多选题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 determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）A
Size of typical transactions B
Concurrent transactions C
Size of rows in table most frequently changed D
Number of anticipated disk sorts
考题
单选题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.
考题
单选题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.
考题
单选题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.
热门标签
最新试卷
