网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）
A
The ASM compatibility attribute controls the format of the disk group metadata.
B
RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
C
The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
D
The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
E
The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.
参考答案
参考解析
解析：
暂无解析
更多 “多选题You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）AThe ASM compatibility attribute controls the format of the disk group metadata.BRDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.CThe RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.DThe ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.EThe ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.” 相关考题
考题
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()
A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant
考题
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?（）A. The installation terminates with an error.B. The installation proceeds with the default value without warnings and errors.C. The installation proceeds with the default value but it would not be an OFA-compliant database.D. The installation proceeds with the default value but a message would be generated in the alert log file.
考题
You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?()
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.
考题
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.
考题
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
考题
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.
考题
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？（）A、ORA_PATHB、ORACLE_SIDC、ORACLE_BASED、ORACLE_HOMEE、LD_LIBRARY_PATH
考题
You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control
考题
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area （FRA） for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
考题
You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）A、The backups would be consistent.B、The backups would be inconsistent.C、The backups would be possible only if the database is running in ARCHIVELOG mode.D、The backups would be possible only if the database is running in NOARCHIVELOG mode.E、The backups need to be restored and the database has to be recovered in case of a media failure
考题
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）A、The ASM compatibility attribute controls the format of the disk group metadata.B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.
考题
You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option. - Use Oracle Enterprise Manager Database Control to manage the database. - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications. Some tools available to you for installation are： 1：Oracle Universal Installer （OUI） 2：Database Configuration Assistant （DBCA） 3：Database Upgrade Assistant （DBUA） 4：Oracle Net Configuration Assistant Which tools would you use for this installation（）A、2B、3C、1 and 2D、3 and 4E、1，2，and 4
考题
You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error. SQL startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 SQL alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1： ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log What steps must you take to resolve the error？（） a. Issue the recover database redo logs command. b. Issue the Startup Mount command to mount the database. c. Restore the last full database backup. d. Perform a point-in-time recovery， applying all archived redo logs that are available. e. Restore all archived redo logs generated during and after the last full database backup. f. Open the database using the alter database open resetlogs command. g. Issue the alter database open command.A、b， a， fB、e， b， a， fC、e， b， a， gD、b， a， gE、c， e， b， d， f
考题
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A、 Oracle Net ManagerB、 Listener Control utilityC、 Database Configuration AssistantD、 Oracle Net Configuration Assistant
考题
In a new installation of Oracle Database 11g， you perform these activities： 1：Organize software and data on different subdirectories to avoid poor performance. 2：Use consistent naming conventions for database files. 3：Separate administrative information pertaining to the database in different directories. Which option corresponds to the type of activities you performed（）A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architectureE、Automatic Storage Management
考题
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） A、 Generate reports on data failure such as data file failures.B、 You can track the Service Request （SR） and implement repairs.C、 You can package and upload diagnostic data to Oracle Support.D、 You can manually run health checks to gather diagnostic data for a problem.
考题
单选题You have created a database link， devdb.us.oracle.com， between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database， DEVDB， to the production database， PRODDB. You execute the following command on the target database server： $impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr flashback_time = 2004-02-03 09：00 The command fails， displaying the following error： ORA-39001： invalid argument value ORA-39000： bad dump file specification ORA-31640： unable to open dump file “/home/oracle/schema/schemas.dat” for read ORA-27037： unable to obtain file status What would you do to overcome the error（）A
remove the dumpfile option in the commandB
remove the flashback_time option in the commandC
remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command（Replace thedumpfile option with the network_link = devdb.us.oracle.com）D
add the user， SYSTEM， to the schemas option in the commandE
remove the schemas option and add the network_link = devdb.us.oracle.com option in the command F
add network_link = devdb.us.oracle.com option in the command
考题
单选题You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）A
Transportable databaseB
Transportable tablespaceC
Data Pump full export/importD
The DBMS_PDB packageE
RMAN
考题
多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
考题
单选题You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）A
Multiplex all database files.B
Configure the Flash Recovery Area.C
Configure the database instance for ARCHIVELOG mode.D
Configure the FAST_START_MTTR_TARGET initialization parameter
考题
单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A
Oracle Net ManagerB
Listener Control utilityC
Database Configuration AssistantD
Oracle Net Configuration Assistant
考题
单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）A
When the instance is started B
When the database is mounted C
When the database is opened D
When the database is closed
考题
单选题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 manageability 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.
考题
单选题You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task（）A
Multiplex all database filesB
Configure the Flash Recovery Area.C
Configure the database instance for ARCHIVELOG mode.D
Configure the FAST_START_MTTR_TARGET initialization parameter.
考题
单选题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.
考题
单选题You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option. - Use Oracle Enterprise Manager Database Control to manage the database. - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications. Some tools available to you for installation are： 1：Oracle Universal Installer （OUI） 2：Database Configuration Assistant （DBCA） 3：Database Upgrade Assistant （DBUA） 4：Oracle Net Configuration Assistant Which tools would you use for this installation（）A
2B
3C
1 and 2D
3 and 4E
1，2，and 4
考题
单选题You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status What would you do to overcome the error（）A
Add the user， SYSTEM， to the schemas option.B
Add the network_link = devdb.us.oracle.com option.C
Change the dumpfile option to schema.dat@devdb.us.oracle.com.D
Replace the schemas option with the network_link = devdb.us.oracle.comE
Replace the dumpfile option with the network_link = devdb.us.oracle.com
热门标签
最新试卷