You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）A、The database crashes.B、The DBA needs to re-cre

题目

You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

  • A、The database crashes.
  • B、The DBA needs to re-create the file.
  • C、The file gets re-created automatically.
  • D、The file gets restored automatically from the last backup.
  • E、The DBA needs to perform a complete database recovery.
  • F、The DBA needs to perform an incomplete database recovery.
相似考题

1.View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?()A. The text alert log file will be available in Diag TraceB. A copy alert log file will be kept in Diag Incident for every incident.C. The XML version of the alert log file will be available in Diag Trace.D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.

2. You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）A、You must have change tracking enabled in your databaseB、Your database must be running in NOARCHIVELOG modeC、To back up a tablespace, it must be in backup modeD、To back up a tablespace, it must first be taken offline

3.Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A、user-managed backups.B、partial database backups.C、consistent database backups.D、inconsistent database backups.

4.You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.Which statement is true?（）A. The ORACLE_BASE base parameter is not set.B. The installation is being performed by the root user.C. The operating system group that is specified should have the root user as its member.D. The operating system group that is specified must have permission to write to the inventory directory

更多“You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）A、The database crashes.B、The DBA needs to re-cre”相关问题

  • 第1题：

    You are working on the Certkiller database.  What is the default name of the alert log file in this database？（）

    • A、alert_ Certkiller .log
    • B、alertlog_ Certkiller .log
    • C、alert_log_ Certkiller .log
    • D、Certkiller _alert_log.log
    • E、log_alert_： Certkiller .log
    • F、trace_alert_ Certkiller .log

    正确答案:A

  • 第2题：

    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

    • A、 online redo log files
    • B、 alert log files
    • C、 control file
    • D、 datafiles associated with the SYSTEM tablespace

    正确答案:C

  • 第3题：

    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

    • A、to enable operating system authentication for a remote client
    • B、to restrict the scope of administration to identical operating systems
    • C、to allow the start up and shut down of the database from a remote client
    • D、to enable the administration of the operating system from a remote client
    • E、to disable the administration of the operating system from a remote client

    正确答案:A

  • 第4题：

    Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

    • A、 The redo log file should belong to an active group.
    • B、 The redo log file should belong to an inactive group.
    • C、 The redo log file should belong to the current group.
    • D、 The redo log file can be dropped only if all the transactions are stopped.
    • E、 Before a redo log file is dropped， it should be deleted from the operating system （OS）.

    正确答案:B

  • 第5题：

    Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）

    • A、ARCHIVELOG mode.
    • B、NOARCHIVELOG mode.
    • C、Open database backups.
    • D、Consistent whole backups.

    正确答案:A,C

  • 第6题：

    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.

    正确答案:A

  • 第7题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands


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

  • 第8题：

    单选题
    You are working on the Certkiller database.  What is the default name of the alert log file in this database？（）
    A

    alert_ Certkiller .log

    B

    alertlog_ Certkiller .log

    C

    alert_log_ Certkiller .log

    D

    Certkiller _alert_log.log

    E

    log_alert_： Certkiller .log

    F

    trace_alert_ Certkiller .log


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

  • 第9题：

    单选题
    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
    A

     online redo log files

    B

     alert log files

    C

     control file

    D

     datafiles associated with the SYSTEM tablespace


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

  • 第10题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.


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

  • 第11题：

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


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

  • 第12题：

    单选题
    You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）
    A

    The database crashes.

    B

    The DBA needs to re-create the file.

    C

    The file gets re-created automatically.

    D

    The file gets restored automatically from the last backup.

    E

    The DBA needs to perform a complete database recovery.

    F

    The DBA needs to perform an incomplete database recovery.


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

  • 第13题：

    You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

    • A、You can perform consistent backups only.
    • B、You can perform a complete database backup without shutting down the database instance.
    • C、You can back up data files only when all data files have the same SCN recorded in the control file.
    • D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

    正确答案:B,D

  • 第14题：

    You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true?（）

    • A、The ORACLE_BASE base parameter is not set.
    • B、The installation is being performed by the root user.
    • C、The operating system group that is specified should have the root user as its member.
    • D、The operating system group that is specified must have permission to write to the inventory directory

    正确答案:D

  • 第15题：

    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）

    • A、 RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
    • B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
    • C、 RMAN would relocate all the database files to an ASM disk group.
    • D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

    正确答案:C

  • 第16题：

    You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）

    • A、Upgrade the hardware/memory to accommodate the data.
    • B、Load the data into your database by using the PARALLEL clause.
    • C、Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.
    • D、Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.

    正确答案:D

  • 第17题：

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

    • A、The backup status will be marked expired in RMAN recovery catalog.
    • B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
    • C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
    • D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
    • E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

    正确答案:C

  • 第18题：

    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）

    • A、RMAN would relocate all the database files to an ASM disk group.
    • B、RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
    • C、RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
    • D、RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location， defined using OMF

    正确答案:A

  • 第19题：

    单选题
    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）
    A

    to enable operating system authentication for a remote client

    B

    to restrict the scope of administration to identical operating systems

    C

    to allow the start up and shut down of the database from a remote client

    D

    to enable the administration of the operating system from a remote client

    E

    to disable the administration of the operating system from a remote client


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

  • 第20题：

    单选题
    Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）
    A

    user-managed backups.

    B

    partial database backups.

    C

    consistent database backups.

    D

    inconsistent database backups.


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

  • 第21题：

    单选题
    Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）
    A

     The redo log file should belong to an active group.

    B

     The redo log file should belong to an inactive group.

    C

     The redo log file should belong to the current group.

    D

     The redo log file can be dropped only if all the transactions are stopped.

    E

     Before a redo log file is dropped， it should be deleted from the operating system （OS）.


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

  • 第22题：

    单选题
    You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）
    A

    You must have change tracking enabled in your database

    B

    Your database must be running in NOARCHIVELOG mode

    C

    To back up a tablespace, it must be in backup mode

    D

    To back up a tablespace, it must first be taken offline


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

  • 第23题：

    单选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
    A

    The backup status will be marked expired in RMAN recovery catalog.

    B

    The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.

    C

    The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl

    D

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.

    E

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.


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

相关内容