单选题The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command： RMANCONFIGURE MAXSETSIZE 10MB； What will be the impact of the above setting？（）A While performing the backup of the datafile，data1.dbf，one backup set is created.B While performing the backup of the datafile，data1.dbf，two backup sets are created.C While performing the backup of the datafile，data1.dbf，three backup sets are created.D While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.
单选题
The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command： RMAN>CONFIGURE MAXSETSIZE 10MB； What will be the impact of the above setting？（）
A
While performing the backup of the datafile，data1.dbf，one backup set is created.
B
While performing the backup of the datafile，data1.dbf，two backup sets are created.
C
While performing the backup of the datafile，data1.dbf，three backup sets are created.
D
While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.
参考解析
解析：
暂无解析
相关考题：
单选题The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement： SQLALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’； What will be the outcome of this statement？（）A The statement will deactivate DAY_PLAN.B The statement will activate DAY_PLAN as the top plan.C The statement will activate MANAGERS_PLAN as the top plan.D The statement will return an error because MANAGERS_PLAN is not the top plan.
单选题You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： $ rman target / What would be the effect of this command？（）ARMAN would use the current operating system location to place the backup.BRMAN would use the control file of the target database to maintain the backup.CRMAN would use the recovery catalog of the target database to maintain the backup.DRMAN would use the control file of the target database to maintain the backup metadata. ERMAN would use the recovery catalog of the target database to maintain the backup metadata.
单选题Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN RUN { 2 SET UNTIL SEQUENCE 230 THREAD 1； 3 ALTER DATABASE MOUNT； 4 RESTORE DATABASE； 5 RECOVER DATABASE； 6 ALTER DATABASE OPEN RESETLOGS； 7 }； With reference to this scenario， which statement is true？（）A RMAN recovers up to log sequence 230， but not including 230.B RMAN returns an error because the log sequence number mentioned in the command should be 229.C RMAN returns an error because the log sequence number mentioned in the command may never be missing.D RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
单选题You accepted the recommended SQL Profile by executing the following code： DECLARE sqlprofile_name varchar2（30）； BEGIN sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（ task_name = ’my_task’， profile_name = ’my_profile’）； END； Which advisor will analyze this profile？（）A SQL Access AdvisorB Undo AdvisorC Segment AdvisorD SQL Tuning Advisor
单选题While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）A Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.B Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.C Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.D Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
单选题Consider the following configuration： /devices/diskP1 is a member of disk group grp1. /devices/diskP2 is a member of disk group grp1. /devices/diskP3 is a member of disk group grp1. /devices/diskP4 is a candidate disk. /devices/diskQ1 is a member of disk group grp2. /devices/diskQ2 is a member of disk group grp2. /devices/diskQ3 is a member of disk group grp2. /devices/diskQ4 is a candidate disk. Which command will add the disk /devices/diskP4 to the disk group， grp1？（）A ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP1’， ADD DISK ’/devices/diskP4’；B ALTER DISKGROUP grp1 ADD DISK ’/devices/disk*4’；C ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP*’；D ALTER DISKGROUP grp1 ADD DISK ’/devices/diskQ*’， ADD DISK ’/devices/diskP*’；
单选题You have two listener processes， named L1 and L2. Both the listener processes are currently functional. While viewing the listener.ora file on your database server， you find the following entry： PASSWORDS_L1 = （1sanfrjp43） What would be the impact of this setting？（）AThe listener process named L1 will disconnect the unauthorized users.BThe listener process named L1 will be prevented from being started by unauthorized users. CThe listener process named L1 will be prevented from being stopped by unauthorized users. DThe listener process named L1 will be prevented from being reloaded by unauthorized users.EThe listener process named L1 will be prevented from accepting connections from unauthorized users.
多选题While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges. Which two commands would you use to resolve this error？（）AGRANT dba TO dbmgr;BGRANT connect TO dbmgr;CGRANT resource TO dbmgr;DGRANT hs_admin_role TO dbmgr;EGRANT manage scheduler TO dbmgr;
单选题The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（）A The database will hang.B The database will be crashed.C The database will be shut down.D The LGWR process writes redo log entries to the other redo log member of the Group2 group
多选题You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？ （）ATop SQLBsnapshotsCSQL Tuning setsDindex access pathEoptimizer statisticsFmaterialized view logs
单选题You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly. On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLS tablespace， you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting？（）Aconfigure a default device for RMAN backupsBtemporarily disable the retention policy for RMAN backupsCconfigure automatic channel allocation for RMAN backupsDuse the CONFIGURE command to reconfigure the recovery window to 60 days
单选题You accepted the recommended SQL Profile by executing the following code： DECLARE sqlprofile_name varchar2（30）； BEGIN sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（ task_name = ’my_task’， profile_name = ’my_profile’）； END； Which advisor will analyze this profile？（）A SQL Access AdvisorB Undo AdvisorC Segment AdvisorD SQL Tuning Advisor
单选题You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF； What would be the effect of this command on the existing flashback logs？（）A Flashback logs are not deleted.B Flashback logs are deleted automatically.C Flashback logs are deleted only if you are using Recovery Manager （RMAN）D Flashback logs are deleted only if you are using Oracle Manager Files （OFM）E Flashback logs are deleted only if you are using Automatic Storage Management （ASM）
单选题You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）ADB_BLOCK_SIZEBCONTROL_FILESCLARGE_POOL_SIZEDLOG_ARCHIVE_DESTELOG_ARCHIVE_FORMATFDB_CREATE_FILE_DEST
单选题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.
单选题Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（）A ALTER SYSTEM KILL SESSIONB ALTER SYSTEM DISCONNECT SESSIONC ALTER SYSTEM QUIESCE RESTRICTEDD ALTER SYSTEM ENABLE RESTRICTED SESSION
单选题You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A by using the Flashback Database featureB by using RMAN incomplete recoveryC by performing a user-managed incomplete recoveryD by dropping and re-creating the index tablespace
单选题You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）Aperform pointintime recoveryBperform a Flashback Table operation to restore the table to the state it was in two days ago Cperform a Flashback Database operation to restore the database to the state it was in two days agoDperform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）A You do not need to restore all the data files.B You do not need to open the database with the RESETLOGS operationC You do not need to perform a full backup after the RESETLOGS operation.D You do not need to recover all the data files to the same system change number （SCN）.
单选题You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A DBA_SCHEDULER_JOB_RUN_DETAILSB DBA_SCHEDULER_RUNNING_JOBSC DBA_SCHEDULER_JOBSD DBA_SCHEDULER_JOB_LOG
单选题You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）A RBALB CKPTC SMOND PMONE MMONF CTWRG DBWR
单选题By using the transaction identifier provided by （） for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.AFlashback TableBFlashback DatabaseCFlashback Versions QueryDthe RMAN REPORT commandEthe DBA_PENDING_TRANSACTIONS view
单选题Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）A The database will operate normally without generating any redo.B The database will hang， and you must shut down and restart the instance.C The database will crash， and you must recover the database from the point of failure.D The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.
单选题You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）A space allocated in the tablespaceB space required for the bitmap index on a column of the tableC space remaining in the tablespace after creating the tableD estimated value of the PCTFREE storage parameter
单选题Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）A DROP TABLESPACE temp1；B DROP TABLESPACE temp1 INCLUDING CONTENTS；C DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；D DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；
多选题You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN. Which two statements are correct in this scenario？（）AYou must ensure that the SALES database is mounted or open.BYou must restore a backup control file to perform a block media recovery.CYou must take the tools01.dbf data file offline before you start a block media recovery.DYou must put the database in NOARCHIVELOG mode to perform a block media recovery.EYou can perform only a complete media recovery of individual blocks； point-in-time recovery of individual data blocks is not supported.
多选题Which two statements are correct regarding the Oracle Flashback Drop feature？ （）ARecycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.BYou can flash back a dropped table provided row movement has been enabled on the table.CIf you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.DWhen you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.EWhen a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.FIf you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.
单选题A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）A Do nothing.B Restart the database.C Perform recovery on the database.D Restore the alert log from the last backup.