STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;
STARTUP MOUNT ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;
STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;
STARTUP MOUNT ALTER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;
第1题:
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:RMAN> BACKUPSECTION SIZE 300M TABLESPACE users;Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()
A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
B. The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
D. The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
第2题:
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?()
第3题:
A. Oracle Net Manager
B. Listener Control utility
C. Database Configuration Assistant
D. Oracle Net Configuration Assistant
第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/x7fASM instance to an ASM instance?()
第5题:
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
第6题:
You have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error: ORA-01081: cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error?()
第7题:
You specify a nonzero value for the MEMORY_TARGET initialization parameter,but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?()
第8题:
A. The source database backup must be copied over the net for test database.
B. The source database must be run in ARCHIVELOG mode if the database is open.
C. The source database must be shut down cleanly if the database is in mounted state.
D. A net service name should be set up and a listener configured with the target as well as the source database.
第9题:
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?()
第10题:
You are managing a single instance Oracle 10g database that utilizes the following parameters: Which of the following set of commands must you execute to enable Flashback Database?()