You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

相似题目

• ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）

  A . Issue ALTER DATABASE BACKUP CONTROLFILE TO filename B . Make a copy of the control file with the database shut down C . Issue ALTER DATABASE BACKUP CONTROLFILE TO trace D . Make a copy of the control file with the database still running&e

  查看最佳答案

• You are connecting to an Oracle database server from a client by using the following connect string：  SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb  Which naming method is being used in this case？（）

  A . Local Naming B . Easy Connect C . External Naming D . Directory Naming

  查看最佳答案

• You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb  Which three statements are correct regarding the connection string？（）

  A . mydb is a service name. B . test.us.oracle.com is a database name. C . 1521 is the listener port number. D . mydb is a host name. E . test.us.oracle.com is a net service name. F . hr is a username. G . test.us.oracle.com is an instance name.

  查看最佳答案

• You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use？（）

  A . Only host B . Only local C . Either host or local D . Both host and local

  查看最佳答案

• You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? （）

  A . Its entries are specific to a single database. B . It contains file systems that have been mounted by Direct NFS. C . It is globally available to all Oracle 11g databases on the machine. D . It contains file systems that have been mounted by the kernel NFS system.

  查看最佳答案

• You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）

  A .  This operation resets the SCN for the database. B .  This operation creates a new incarnation of the database. C .  This operation moves all the redo log files to a different location. D .  This operation deletes the old redo log files and creates new redo log files. E .  This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• 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

  查看最佳答案

• You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）

  A .  The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances. B .  RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group. C .  The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk. D .  ASM compatibility controls which features for the ASM will be enabled.

  查看最佳答案

• You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

  A .  The target database must be in the MOUNT mode to ensure restoration of the datafiles. B .  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility. C .  The control file must be recreated. D .  The database must be opened with the RESETLOGS option.

  查看最佳答案

• You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

  A .  One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST. B .  One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST. C .  One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST. D .  One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

  查看最佳答案

• 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.

  查看最佳答案

• You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（） 

  A . to uniquely identify the archived log files with the restore operation B . to uniquely identify the archived log files with the redo log group number C . to uniquely identify the archived log files for each incarnation of the database D . to uniquely identify the archived log files with the number of recovery operations performed

  查看最佳答案

• 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

  查看最佳答案

• 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

  查看最佳答案

• You are connecting to an Oracle database server from a client by using the following connect string：   SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb   Which naming method is being used in this case？（）

  A . Local Naming B . Easy Connect C . External Naming D . Directory Naming

  查看最佳答案

• You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）

  A . LOGICAL_READS_PER_SESSION  B . CONNECT_TIME  C . COMPOSITE_LIMIT  D . CPU_PER_SESSION  E . PRIVATE_SGA

  查看最佳答案

• 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.&e

  查看最佳答案

• our 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

  查看最佳答案

• 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

  查看最佳答案

• You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

  A . Datafiles B .  Current control file C .  Server parameter file （spfile） D .  Password file

  查看最佳答案

• You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file？（））  

  A .  Its entries are specific to a single database. B .  It contains file systems that have been mounted by Direct NFS. C .  It is globally available to all Oracle 11g databases on the machine. D .  It contains file systems that have been mounted by the kernel NFS system.

  查看最佳答案

• 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.

  查看最佳答案

• 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.

  查看最佳答案