Your Oracle Database&

题目

Your Oracle Database 10g is online when you execute the following statement:        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF;   What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()

  • A、 The database does not record flashback logs for MY_TABLESPACE
  • B、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
  • C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
  • D、 None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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

第2题:

You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16?()  

  • A、 by using the RMAN utility
  • B、 by using the export/import utility
  • C、 by using the ALTER DATABASE command
  • D、 by enabling the change tracking feature

正确答案:C

第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-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

第5题:

You have a domain that was created and configured with WebLogic 10.3.5. You want to upgrade  the domain to use WebLogic 12c. Which Oracle tool must you use to upgrade your domain?()

  • A、Oracle WebLogic Domain Upgrade tool
  • B、Smart Update 
  • C、Smart Upgrade  
  • D、No tool required, just install WebLogic 12c, update the domain to point to the new WebLogic installation and start your domain.
  • E、JDeveloper

正确答案:D

第6题:

Which of the following options would you choose to implement controlled access using remote authentication for your networks?()

  • A、OiD
  • B、RADIUS
  • C、Wallet Manager
  • D、Oracle Names Server

正确答案:B

第7题:

You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()

  • A、The Oracle kernel will be placed in this location.
  • B、The Oracle software will be placed in this location.
  • C、The server parameter file (SPFILE) will be placed in this location.
  • D、The database files will be placed in this location, if not specified explicitly.
  • E、The location will be considered for the base of Oracle Managed Files (OMF).
  • F、The location will be considered for the base of Optimal Flexible Architecture (OFA).

正确答案:F

第8题:

You have been tasked with creating Business Events for an E-Business Suite workflow project. Whatwould you use to create your Business Events?()

A. Oracle Workflow Builder

B. Oracle Workflow Definition Loader

C. Oracle Business Event Definition Loader

D. Workflow Administrator Web page in E-Business Suite


参考答案:D

第9题:

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

第10题:

You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()

  • A、Oracle Flashback uses undo information to construct consistent data. 
  • B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
  • C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
  • D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

正确答案:A,B

更多相关问题