违法和不良信息举报 联系客服
免费注册 登录

You are working as a DBA on Oracle Database 9i. You plan to 

题目
单选题
You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）
A

 The archived redo logs are stored in an operating system-dependent location.

B

 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.

C

 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.

D

 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

参考答案和解析
正确答案： D
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  • A、 Flashback logs are not archived.
  • B、 Flashback logs are maintained in redo log files.
  • C、 Flashback logs are maintained in the Flash Recovery Area.
  • D、 Flashback logs are used to maintain Flashback Database related errors.
  • E、 Flashback logs need to be cleared manually after you disable Flashback Database.

正确答案:A,C

第2题：

You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

  • A、Application Server Control
  • B、Oracle Management Service
  • C、Oracle Enterprise Manager Repository
  • D、Oracle Enterprise Manager Database Control

正确答案:C,D

第3题：

You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）

A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.


参考答案：B

第4题：

In which two cases would you perform only consistent backup？（）

  • A、You are working on a database where downtime is not tolerated.
  • B、You are working on a database where downtime can be tolerated.
  • C、You are working on a database that operates in ARCHIVELOG mode.
  • D、You are working on a database that operates in NOARCHIVELOG mode.
  • E、You are working on a database where all the tablespaces are locally managed.
  • F、You are working on a database where control files and redo log files are multiplexed.
  • G、You are working on a database where control files and redo log files are not multiplexed.

正确答案:B,D

第5题：

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

  • A、 V$FLASHBACK_DATABASE_LOG
  • B、 V$FLASHBACK_DATABASE_STAT
  • C、 V$DATABASE
  • D、 V$UNDOSTAT

正确答案:A

第6题：

You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）

  • A、More than one database is to be registered with the listener.
  • B、The users will connect the database by using the host naming method.
  • C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
  • D、The database that is to be registered with the listener is configured in shared server mode.
  • E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

正确答案:C,E

第7题：

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

  • A、Use the external table population.
  • B、Use the Oracle Data Pump export and import utility.
  • C、Use the conventional path data load of the SQL*Loader utility.
  • D、Use the INSERT INTO...SELECT command to load the data

正确答案:C

第8题：

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?（）

A. The source database should be open

B. The target database should be in ARCHIVELOG mode if it is open

C. RMAN should be connected to both the instances as SYSDBA

D. The target database backups should be copied to the source database backup directories

E. The password file must exist for the source database and have the same SYS user password as the target


参考答案：B, C, E

第9题：

You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）

  • A、The backups would be consistent.
  • B、The backups would be inconsistent.
  • C、The backups would be possible only if the database is running in ARCHIVELOG mode.
  • D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
  • E、The backups need to be restored and the database has to be recovered in case of a media failure

正确答案:B,C,E

第10题：

Identify four uses of the Oracle Scheduler.（）

  • A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
  • B、 enables Oracle database to do patches according to a DBA-defined schedule
  • C、 enables you to schedule the execution of jobs based on time
  • D、 enables you to execute jobs in a clustered environment
  • E、 enables you to periodically execute operating systemscript files located on the same server as the database
  • F、 enables you to create a job that makes use of saved programs and schedules
  • G、 enables you to automate the management of the jobs that are created using the DBMS_JOB package

正确答案:C,D,E,F

更多相关问题
相关内容