1z0-043

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

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 work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()

  • A、A backup of the target database when it is mounted
  • B、A backup of online redo log files when the database is open
  • C、A backup of only used data blocks in the file beingbeingbackup up
  • D、A backup of online, read/write data files when the database is open
  • E、A backup of only those data blocks that have changed since a previous backup
  • F、A backup of online, read/write data files when the database is in the NOMOUNT state.

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

第3题:

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

第4题:

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.

正确答案:D

第5题:

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

第6题:

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

正确答案:A

第7题:

You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQL>ALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()

  • A、 The log sequence is reset to 0.
  • B、 All the online redo logs are deleted.
  • C、 All the archived redo logs from a previous incarnation become useless.
  • D、 The full database backup taken from a previous incarnation can be used in future.
  • E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

正确答案:D

第8题:

You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance:   SQL> ALTER SYSTEM SWITCH LOGFILE;   Which two tasks are performed when the statement is executed? ()

  • A、 The DBWn process writes to the datafile.
  • B、 Changes in the background process are recorded.
  • C、 The log file is updated with the current SCN number.
  • D、 The System Change Number (SCN) is recorded in the control file.
  • E、 The changes to the listener configuration in the listener.ora file are recorded.

正确答案:A,D

第9题:

You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()

  • A、SQL*Plus
  • B、iSQL*Plus
  • C、Management Server
  • D、Management Repository
  • E、Oracle Enterprise Manager 10g Database Control

正确答案:E

第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

更多相关问题