网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 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 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？（）A
RMAN would use the current operating system location to place the backup.B
RMAN would use the control file of the target database to maintain the backup.C
RMAN would use the recovery catalog of the target database to maintain the backup.D
RMAN would use the control file of the target database to maintain the backup metadata. E
RMAN 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？（）A
The listener process named L1 will disconnect the unauthorized users.B
The listener process named L1 will be prevented from being started by unauthorized users. C
The listener process named L1 will be prevented from being stopped by unauthorized users. D
The listener process named L1 will be prevented from being reloaded by unauthorized users.E
The 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？（）A
configure a default device for RMAN backupsB
temporarily disable the retention policy for RMAN backupsC
configure automatic channel allocation for RMAN backupsD
use 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？（）A
DB_BLOCK_SIZEB
CONTROL_FILESC
LARGE_POOL_SIZED
LOG_ARCHIVE_DESTE
LOG_ARCHIVE_FORMATF
DB_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？（）A
perform pointintime recoveryB
perform a Flashback Table operation to restore the table to the state it was in two days ago C
perform a Flashback Database operation to restore the database to the state it was in two days agoD
perform 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.A
Flashback TableB
Flashback DatabaseC
Flashback Versions QueryD
the RMAN REPORT commandE
the 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.
热门标签
最新试卷