Oracle认证考试
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题：
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
正确答案:C
第2题：
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
第3题：
A. The text alert log file will be available in Diag Trace
B. 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.
第4题：
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
第5题：
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
第6题：
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.
正确答案:C
第7题：
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
第8题：
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
第9题：
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
第10题：
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