niusouti.com

单选题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 datab

题目
单选题
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

相似考题

1.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

2. 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.

3. 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

4. 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 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 datab”相关问题

  • 第1题：

    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 file
    • B、The fixed views
    • C、The data dictionary views
    • D、The operating system log fields
    • E、The dynamic performance views.

    正确答案:E

  • 第2题：

    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 happens
    • B、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

    正确答案:C

  • 第3题：

    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.

    正确答案:C

  • 第4题：

    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.

    正确答案:D

  • 第5题：

    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.

    正确答案:C

  • 第6题：

    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

    正确答案:B

  • 第7题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    多选题
    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 opens normally.

    B

    The database prompts for a database recovery.

    C

    The database writer writes to a trace file， indicating that the temporary file is not found.

    D

    The database gets mounted and throws an error indicating that the temporary file requires recovery.


    正确答案： A,D
    解析： 暂无解析

  • 第11题：

    单选题
    When you create a backup control file， where is the resulting file written to？（）
    A

     The database user dump destination directory

    B

     The database diagnostic destination directory

    C

     To $ORACLE_HOME/rdbms

    D

     To $ORACLE_HOME/admin

    E

     To the directory and filename you specify in the command


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:A,C

  • 第14题：

    In which situation would you use static database registration for a listener（）

    • A、when multiple databases are to be registered with the listener
    • B、when DBAs need to connect remotely to start up the database instance
    • C、when users need to connect the database instance using the host naming method
    • D、when the database instance that is to be registered with the listener is configured in shared server mode

    正确答案:B

  • 第15题：

    When you create a backup control file， where is the resulting file written to？（）  

    • A、 The database user dump destination directory
    • B、 The database diagnostic destination directory
    • C、 To $ORACLE_HOME/rdbms
    • D、 To $ORACLE_HOME/admin
    • E、 To the directory and filename you specify in the command

    正确答案:E

  • 第16题：

    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.

    正确答案:A

  • 第17题：

    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

    正确答案:C

  • 第18题：

    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

    正确答案:A

  • 第19题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）
    A

     MMON

    B

     LGWR

    C

     ARCH

    D

     ARWR

    E

     COPY


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

相关内容