单选题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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?（）A. authentication by password fileB. authentication by using certificates over SSLC. authentication by using the Oracle Internet DirectoryD. authentication by using the local OS of the database server
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL@utlu111i.sqlWhich statement about the execution of this script is true?（）A. It must be executed from the Oracle Database 11g environment.B. It must be executed only after the SYSAUX tablespace has been created.C. It must be executed from the environment of the database that is being upgraded.D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.() A. Change in the Oracle Database versionB. Change in your network infrastructureC. Change in the hardware configuration of the database serverD. Migration of database storage from non-ASM to ASM storageE. Database and operating system upgrade
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN REPORT NEED BACKUP days 3；What would be the output of this command？（）A、 a list of files that require a backup within three daysB、 a list of files that have not been backed up for three daysC、 a list of files that RMAN recommends be backed up only once in every three days， based on low volatilityD、 a list of files for which a backup has already been performed and may need a backup after three days
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（） A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQLALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）A、SQL*PlusB、iSQL*PlusC、Management ServerD、Management RepositoryE、Oracle Enterprise Manager 10g Database Control
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？（）A、Oracle Migration AssistantB、Recovery Manager （RMAN）C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
In your database，the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory （OID）. SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command：$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name. Which authentication method would be used first？（） A、 authentication by password fileB、 authentication by using certificates over SSLC、 authentication by using the Oracle Internet DirectoryD、 authentication by using the local OS of the database server
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？（）A、Oracle Migration AssistantB、Recovery Manager （RMAN）C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）A、Change in the Oracle Database versionB、Change in your network infrastructureC、Change in the hardware configuration of the database serverD、Migration of database storage from non-ASM to ASM storageE、Database and operating system upgrade
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
单选题n 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？（）A Oracle Migration AssistantB Recovery Manager （RMAN）C Oracle Data Pump Export and ImportD conventional Oracle Export and ImportE operating system utilities to copy the files to the ASM instance
单选题Purging air from a hydraulic system is necessary when（）Aadding small amounts of oil to the systemBthe system has been overheatedCthe system has been drained and then filled with new oilDthe system has been idle for a long period of time
多选题In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）Aaverage row sizeBlast analyzed dateCsize of table in bytesDsize of table in database blocksEnumber of free blocks in the free listFnumber of extents present in the table
多选题Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）AChange in the Oracle Database versionBChange in your network infrastructureCChange in the hardware configuration of the database serverDMigration of database storage from non-ASM to ASM storageEDatabase and operating system upgrade
单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）Ato enable operating system authentication for a remote clientBto restrict the scope of administration to identical operating systemsCto allow the start up and shut down of the database from a remote clientDto enable the administration of the operating system from a remote clientEto disable the administration of the operating system from a remote client
多选题SQ L*Loader is a utility that can perform which two tasks？（）ALoad data from a disk， tape， or named pipes.BLoad data into an Oracle database using DML statements.CExtract， reorganize， and insert data within an Oracle database.DLoad data from external files into tables in an Oracle database.ELoad data into an Oracle database using operating system commands.FLoad data directly from a non-Oracle database to an Oracle database.
单选题Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）AShut down the database, restore the two data files and then start up the database. BTake the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. CShut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. DTake the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
单选题You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQLALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）A The log sequence is reset to 0.B All the online redo logs are deleted.C All the archived redo logs from a previous incarnation become useless.D The full database backup taken from a previous incarnation can be used in future.E Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
单选题You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）A by using the RMAN utilityB by using the export/import utilityC by using the ALTER DATABASE commandD by enabling the change tracking feature
单选题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?（）ASet OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.BCapture the plans from the previous version using STS and then load them into the stored outline.CCapture the plans from the previous version using STS and then load them into SQL Management Base (SMB).DSet OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）ARestore all the data files and open the databaseBCreate the data file and performtablespacerecoveryCNo need to restore any file， just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery
单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script： SQL@utlu111i.sql Which statement about the execution of this script is true？（）A It must be executed from the Oracle Database 11g environment.B It must be executed only after the SYSAUX tablespace has been created.C It must be executed from the environment of the database that is being upgraded.D It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile