You are managing a single instance Oracle 10g database that 

题目
单选题
You are managing a single instance Oracle 10g database that utilizes the following parameters:  Which of the following set of commands must you execute to enable Flashback Database?()
A

  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;

B

  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;

C

  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;

D

  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:RMAN> BACKUPSECTION SIZE 300M TABLESPACE users;Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()

A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.

B. The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.

C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.

D. The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1


参考答案:B

第2题:

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components?()  

  • A、 MMAN
  • B、 PMON
  • C、 MMON
  • D、 MMNL

正确答案:A

第3题:

Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant


参考答案:B

第4题:

In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files.  Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance?()

  • A、Oracle Migration Assistant
  • B、Recovery Manager (RMAN)
  • C、Oracle Data Pump Export and Import
  • D、conventional Oracle Export and Import
  • E、operating system utilities to copy the files to the ASM instance

正确答案:B

第5题:

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()

  • A、You must shut down the database instance to perform the backups.
  • B、You must configure the Flash Recovery Area (FRA) for the database.
  • C、You can perform complete database backups without closing the database.
  • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

正确答案:C,D

第6题:

You have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error:  ORA-01081: cannot start - already running ORACLE - shut it down first  Which environmental variable would you set before starting up the PAYDB database to overcome this error?()

  • A、ORA_PATH
  • B、ORACLE_SID
  • C、ORACLE_BASE
  • D、ORACLE_HOME
  • E、LD_LIBRARY_PATH

正确答案:B

第7题:

You specify a nonzero value for the MEMORY_TARGET initialization parameter,but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true?()

  • A、 The database instance starts,and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
  • B、 The database instance starts,and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
  • C、 The database instance starts,but Automatic Memory Management is disabled
  • D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

正确答案:B

第8题:

You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?()

A. The source database backup must be copied over the net for test database.

B. The source database must be run in ARCHIVELOG mode if the database is open.

C. The source database must be shut down cleanly if the database is in mounted state.

D. A net service name should be set up and a listener configured with the target as well as the source database.


参考答案:B, C, D

第9题:

In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()

  • A、Oracle Migration Assistant
  • B、Recovery Manager (RMAN)
  • C、Oracle Data Pump Export and Import
  • D、conventional Oracle Export and Import
  • E、operating system utilities to copy the files to the ASM instance

正确答案:B

第10题:

You are managing a single instance Oracle 10g database that utilizes the following parameters:  Which of the following set of commands must you execute to enable Flashback Database?()

  • A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;
  • B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;
  • C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;
  • D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;

正确答案:D

更多相关问题