单选题Which command is used to open the database after an incomplete recovery？（）A alter database openB alter database open repairlogC alter database open resetlogsD alter database open resetlogE alter database resetlogs open
单选题
Which command is used to open the database after an incomplete recovery？（）
A
alter database open
B
alter database open repairlog
C
alter database open resetlogs
D
alter database open resetlog
E
alter database resetlogs open
参考解析
解析：
暂无解析
相关考题：
单选题What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration？（）A It improves resync operations.B This feature enables much faster file opens.C It improves performance as fewer extent pointers are needed in the shared pool.D It improves performance by reading from a copy of an extent closest to the node.
单选题How many database instances are used during a database-duplication process？（）A OneB TwoC ThreeD FourE Five
多选题Which three statements are true about persistent configuration？（）AA user cannot set privileges on the persistent lightweight jobsBPersistent lightweight jobs generate a large amount of metadataCIt is possible to create fully self-contained persistent lightweight jobsDThe use of a template is mandatory to create persistent lightweight jobsEPersistent lightweight jobs are useful when users need to create a large number of jobs in a short time
单选题Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature？（）A RSTLNEB NLSRTLC LISTENERD NLSSORTE Linguistic sorts
多选题Which two statements are true with respect to the maintenance window？（） .AA DBA can enable or disable an individual task in all maintenance windows.BA DBA cannot change the duration of the maintenance window after it is created.CIn case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.DA DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window
单选题You issue the following RMAN command to set a retention policy on a database： RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2； What will be the outcome of issuing this command？（）A After two days，a backup will be marked obsoleteB After two days，a backup will be deleted from the mediaC If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.D If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.
单选题A user sends you an email with the following error message： create table idtable（id number） * ERROR at line 1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error： 2： No such file or directory Additional information： 3 You can choose from the following steps： a. Restore the missing database datafiles. b. Take the missing datafile offline. c. Shut down the database. d. Issue the recover tablespace USERS command. e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online. g. Issue the alter database open command. Which is the correct order of these steps in this case？（）Ab， a， d， fBc， a， e， b， d， f， gCc， e， d， gDb， d， f Ee， d， g
单选题The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this？（）A to prevent the creation of an excessive number of scheduler job classesB to allow the Automated Maintenance Tasks to use system resources without any restrictionC to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
单选题Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation？（）A ADD DIRECTORYB DROP DISKC RESIZE DISKD REBALANCEE ADD FAILGROUP
单选题You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours： ALTER DISKGROUP dg01 SET ATTRIBUTE ’disk_repair_time’ = ’5h’； To which disks in the disk group will the new value be applicable？（）A all disks in the disk groupB all disks that are currently in OFFLINE modeC all disks that are not currently in OFFLINE modeD all disks in the disk group only if all of them are ONLINE
单选题A user sends you an email with the following error message： create table idtable（id number） * ERROR at line 1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error： 2： No such file or directory Additional information： 3 You can choose from the following steps： a. Restore the missing database datafiles. b. Take the missing datafile offline. c. Shut down the database. d. Issue the recover tablespace USERS command. e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online. g. Issue the alter database open command. Which is the correct order of these steps in this case？（）Ab， a， d， fBc， a， e， b， d， f， gCc， e， d， gDb， d， f Ee， d， g
单选题When youre performing active database duplication，a backup of what kind is required？（）A A current RMAN backup-set backup is required.B No backup is required.C An RMAN image backup is required.D A manual backup is required.E A duplicate preparatory backup is required.
单选题Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）A/u01/app/oracle/product/11.1.0/db_1B/u01/app/oracleC$ORACLE_HOME/bdumpD$ORACLE_HOME/log
单选题You executed the following command in the Recovery Manager (RMAN): RMAN REPORT NEED BACKUP days 3; What is the output of this command?（）AA list of files that require a backup within 3 daysBA list of files requiring more than 3 days of archivelogs to applyCA list of files that RMAN recommends be backed up only once in every three days, based on low volatilityDA list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
单选题Evaluate the following code： SQLVARIABLE task_name VARCHAR2（255）； SQLVARIABLE sql_stmt VARCHAR2（4000）； SQLBEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’； DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR， ：task_name， ：sql_stmt）； END； What is the outcome of this block of code？（）A It creates a task and workload， and executes the task.B It creates a task and workload but does not execute the task.C It produces an error because a template has not been created.D It produces an error because the SQL Tuning Set has not been created.
单选题The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this？（）A ownerB touserC attachD remap_schema
多选题What is the purpose of the RMAN recovery catalog？（）AMake backups fasterBStore RMAN metadataCStore RMAN scriptsDProvide the ability to do centralized backup reportingEMake recovery faster
单选题Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service （IPS） to MetaLink？（）A The database must be running in ARCHIVELOG mode.B No special setup is required， and the feature is enabled by default.C The path for the Automatic Diagnostic Repository （ADR） must be configured with the DIAGNOSTIC_DEST initialization parameter.D The Enterprise Manager Support Workbench can be enabled only if the background process manage ability monitor （MMON） is configured.E Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software， provide valid MetaLink credentials and select license agreement.
单选题What will be the result of the following configuration？（） Log_archive_dest_1=location=c：/oracle/arch/mydb Log_archive_dest_2=location=z：/oracle/arch/mydbA An error will occur during database startup because the second parameter is not valid.B An error will occur during database startup since you are trying to create archived redo logs in two different locations.C Archived redo logs will be created in two different locations by the ARCH process.D Archived redo logs will be created in two different locations by the LGWR process.E Neither parameter setting is valid， so the database will not start up.
单选题You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）A Enable supplemental logging for the database.B Specify undo retention guarantee for the databaseC Create Flashback Data Archive in the tablespace where the tables are stored.D Create Flashback Data Archive and enable Flashback Data Archive for specific tables
单选题Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database？（）A 13：00 on Tuesday.B 15：00 on Tuesday.C Up until the last available archived redo log on Sunday.D To any point； all the redo should still be available in the online redo logs.E The database is not recoverable.
单选题You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=’GLOBAL’）； You need statistics to be collected more quickly. What can you do to achieve this？（）A Set DYNAMIC_SAMPLING to level 4B Set the STATISTICS_LEVEL parameter to BASICC Set the INCREMENTAL value to TRUE for the partition tableD Increase the value of STALE_PERCENT for the partition table
单选题Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified？（）A only the control file， the current SPFILE， and data filesB only the current SPFILE and data files if autobackup is disabledC only the data files and the archived redo logsD the control file，current SPFILE file，data files，and archived redo logs
单选题While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）AIt updates the existing SQL profiles with current statistics.BIt makes the statistics information available to GATHER_STATS_JOBCIt initiates the statistics collection process by running GATHER_STATS_JOBDIt logs a warning message in the alert log so that the DBA can perform statistics collection manually.
单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements. What would you do with these SQL statements？（）A Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B Capture the plans from the previous version using STS and then load them into the stored outline.C Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）D Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
多选题The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements？（）ADate formatBDecimal characterCGroup separatorDFirst day of the monthENone of the aboveFAll of the above
单选题You issue the following command： RMANCONFIGURE BACKUP OPTIMIZATION ON； What is the result of this command on your backups？（）A An incremental backup strategy will be used automatically.B Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.C RMAN will configure itself for maximum performance at the cost of CPU.D RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.E RMAN will automatically compress backups.
多选题Which three are the valid statements in relation to SQL plan baselines？（）AThe plans can be manually loaded to the SQL plan baseline.BThe plans in the SQL plan baseline are verified and accepted plans.CThe plans generated for every SQL statement are stored in the SQL plan baseline by default.DThe plan baselines are stored temporarily in the memory as long as the database instance is running.EFor the SQL plan baselines to be accessible to the optimizer， the SYSAUX tablespace must be online.