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？（）

题目

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.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 ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant

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 ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control

3.Which of the following options would you choose to implement controlled access using remote authentication for your networks？（）A、OiDB、RADIUSC、Wallet ManagerD、Oracle Names Server

4.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 BuilderB. Oracle Workflow Definition LoaderC. Oracle Business Event Definition LoaderD. Workflow Administrator Web page in E-Business Suite

参考答案和解析
正确答案:A
更多“Your Oracle Database&”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第6题：

    You are doing an environment assessment for a client that has invested in Oracle RAC for fault tolerance， load balancing， and scalability. The client also invested in clustered Oracle WebLogic Server. You notice that this client’s environment is not integrated for active-active high availability deployment of applications.  What will be your recommendation to achieve that ？ （）

    • A、 MetaLink to RAC
    • B、 ClusterLink to RAC
    • C、 TopLink to RAC
    • D、 GridLink to RAC

    正确答案:D

  • 第7题：

    单选题
    You work as a database administrator for Certkiller .com. In your Oracle database10g 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题：

    单选题
    A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）
    A

    The value for MINEXTENTS setting 

    B

    The value for PCTINCREASE setting 

    C

    The value for MAXEXTENTS setting 

    D

    By default, Oracle allocates six extents to all database objects


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第10题：

    多选题
    The following are the details of your database：   Instance name：test   Host name：tech1.us.oracle.com   IP address：145.33.230.186  Enterprise Manager Console HTTP Port number：5500   You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control？（）
    A

    http：//145.33.230.186：5500/em

    B

    http：//www.145.33.230.186：5500/em

    C

    http：//tech1.us.oracle.com：5500/em

    D

    http：//test.145.33.230.186：5500/em

    E

    http：//test.tech1.us.oracle.com：5500

    F

    http：//www.tech1.us.oracle.com：5500/em

    G

    http：//test.tech1.us.oracle.com：5500/em


    正确答案： A,D
    解析： 暂无解析

  • 第11题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into 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 SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


    正确答案： A
    解析： 暂无解析

  • 第12题：

    多选题
    The following are the details of your database：Instance name：test  Host name ： tech1.us.oracle.com IP address：145.33.230.186 Enterprise Manager Console HTTP Port number：5500  You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser.  Which two URLs would you use to access the Database Control？（）
    A

    http：//145.33.230.186：5500/em

    B

    http：//www.145.33.230.186：5500/em

    C

    http：//tech1.us.oracle.com：5500/em

    D

    http：//test.145.33.230.186：5500/em

    E

    http：//test.tech1.us.oracle.com：5500

    F

    http：//www.tech1.us.oracle.com：5500/em

    G

    http：//test.tech1.us.oracle.com：5500/em


    正确答案： G,B
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    单选题
    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）
    A

    SYSTEM 

    B

    OUTLN 

    C

    INTERNAL 

    D

    SYS


    正确答案： A
    解析： 暂无解析

  • 第19题：

    多选题
    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.


    正确答案： D,C
    解析： 暂无解析

  • 第20题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    If you create your database using Oracle Managed Files （OMF）， what is true？（）
    A

    You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 

    B

    You must define directories for two online redo log groups and three copies of the control file. 

    C

    If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 

    D

    You must use only OMF data files when adding new tablespaces or data files to your database in the future.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    On Monday， you dropped the DEPT table from your schema and then you re/x7fcreated the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）
    A

    You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

    B

    You can restore the DEPT table by using the Oracle Flashback Drop feature and a system­generated name will be assigned to the restored table.

    C

    You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.

    D

    You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）
    A

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


    正确答案： F
    解析： 暂无解析

相关内容