网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
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. 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? ()ASYSDATE should not be used with TIMESTAMP.BThe database must have multiplexed redo log files.CThe database must be in the MOUNT state to execute the command.DThe database must be opened with the RESETLOGS option after the flashback operation.EThe entire database needs to be restored from the most recent backup before the flashback operation.” 相关考题
考题 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

考题 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.

考题 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.

考题 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.

考题 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、 MMANB、 PMONC、 MMOND、 MMNL

考题 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

考题 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 FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architecture

考题 You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?()A、PhaseB、StatusC、Source TypeD、Rule FunctionE、Customization Level

考题 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 catalogB、Oracle Enterprise Manager RepositoryC、Automatic Workload Repository (AWR)D、Oracle 10g Enterprise Manager Grid ControlE、Automatic Database Diagnostic Monitor (ADDM)

考题 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.

考题 You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database

考题 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.

考题 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

考题 Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT

考题 单选题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 subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?()A PhaseB StatusC Source TypeD Rule FunctionE Customization Level

考题 单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology, you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation, you make the following changes in your initialization parameter file:LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d:/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database?()A  The archived redo logs are stored in an operating system-dependent location.B  The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C  The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D  The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

考题 多选题You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by all the transactions during a given period of time.ETo view changes made by a single transaction during a given period of time.

考题 多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.

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

考题 单选题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:   RMAN CONNECT TARGET sys/sys@APPPROD RMAN CONNECT AUXILIARY sys/sys@DUPDB RMAN DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK;   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.

考题 单选题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 managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()A When the instance is started B When the database is mounted C When the database is opened D When the database is closed

考题 单选题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  MMANB  PMONC  MMOND  MMNL

考题 单选题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 catalogB  Oracle Enterprise Manager RepositoryC  Automatic Workload Repository (AWR)D  Oracle 10g Enterprise Manager Grid ControlE  Automatic Database Diagnostic Monitor (ADDM)

考题 单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?()A V$DATABASE B DBA_TABLES C SYSAUD$ D EMP

考题 单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A  target databaseB  auxiliary databaseC  third-party databaseD  recovery catalog database