You are working on an Oracle Database 10g database. Because 

题目
多选题
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command:  SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24);  Which two statements are true? ()
A

SYSDATE should not be used with TIMESTAMP.

B

The database must have multiplexed redo log files.

C

The database must be in the MOUNT state to execute the command.

D

The database must be opened with the RESETLOGS option after the flashback operation.

E

The entire database needs to be restored from the most recent backup before the flashback operation.

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

第1题:

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

第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 an Oracle 10g database, the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics?() 

  • A、recovery catalog
  • B、Oracle Enterprise Manager Repository
  • C、Automatic Workload Repository (AWR)
  • D、Oracle 10g Enterprise Manager Grid Control
  • E、Automatic Database Diagnostic Monitor (ADDM)

正确答案:C

第5题:

While planning to manage more than one database in your system, you perform the following activities:  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you?()

  • A、Oracle Managed Files
  • B、Oracle Grid Architecture
  • C、Optimal Flexible Architecture
  • D、Oracle database architecture

正确答案:C

第6题:

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

第7题:

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

第8题:

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?()

A. They execute and create a virtual catalog for pre-Oracle 11g clients.

B. They produce an error because PROD1 and PROD2 databases belong to the older version.

C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

D. They produce an error because you need to connect to the target database to execute this packaged procedure.


参考答案:A

第9题:

You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?()

  • A、Phase
  • B、Status
  • C、Source Type
  • D、Rule Function
  • E、Customization Level

正确答案:E

第10题:

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()

  • A、 To recover a dropped table.
  • B、 To recover a dropped schema.
  • C、 To recover data from a truncated table.
  • D、 To view changes made by all the transactions during a given period of time.
  • E、 To view changes made by a single transaction during a given period of time.

正确答案:D,E

更多相关问题