单选题You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your da

题目

单选题

You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are： 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management （ASM） for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database（）

4 and 6

2，3，4，and 6

1，2，4，5，and 6

1，2，3，4，5，and 6

参考答案和解析

正确答案： D

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

A、Clone
B、Copy
C、Template
D、Terminal

正确答案:C

第2题：

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 utility
B、 by using the export/import utility
C、 by using the ALTER DATABASE command
D、 by enabling the change tracking feature

正确答案:C

第3题：

You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.

What should you do?

A．Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.

B．Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.

C．Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.

D．Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

正确答案：A
解析：Explanation:Detachingandattachingdatabasesissometimesausefultechniqueforquicklymovingadatabasefromonecomputertoanother.Tomoveadatabase,ordatabasefile,toanotherserverordiskthedatabasemustfirstbedetachedfromtheoriginalserverordisk;movedtotheotherserverordiskandthenattachedontheserverordisk.Inadditionthenewlocationofthemovedfile(s)mustbespecified.Thesp_detach_dbstoredprocedureisusedtodetachthedatabaseandcanrunUPDATESTATISTICSonalltablesbeforedetachingthedatabasewhilethesp_attach_dbstoredprocedureisusedtoattachthedatabaseinitsnewlocation.IncorrectAnswers:B:DTScanimportdatafromatextfileorfromanOLEDBdatasourcesuchasaMicrosoftAccess2000databaseintoSQLServer.ItcanalsoexportdatafromSQLServertoanOLEDBdatadestination.Itprovidesforhigh-speeddataloadingfromtextfilesintoSQLServertables.However,itisnotthefastestwaytomoveawholedatabasefromoneservertoanother.C:Beforeadatabasecanberestoredfromabackuptoanewlocation;thedatabasemustfirstberecreatedinthedestinationasthebackupholdsonlythedatafilesthatbelonginthevarioustables.Itdoesnotholdthetabledefinitions.Thisisnotthefastestmethodtomoveadatabase.D:TheDISKINITandDISKREFITcommandscannotbeusedtomoveadatabasefromoneservertoanother.Note:DISKINITandDISKREINITarefeaturesthatareusedinaSQLServer6.x.inSQLServer6.x,DISKINITisusedtocreatedatabaseortransactionlogdevicestostorethespecifieddatabaseortransactionlogwhenDISKINITfollowedeitheraCREATEDATABASEorALTERDATABASEstatementwhileDISKREINITisusedtorestoredeviceentriestoappropriatesystemtableswhenthedeviceentrywasmissingfromsysdevices.InSQLServer2000theCREATEDATABASEandALTERDATABASEstatementsallowforthecreationofseparatedataandlogfiles.BothCREATEDATABASEandALTERDATABASEcreateoperatingsystemfilesanddatabasesinasinglestep.ItisthusrecommendedthatallreferencestoDISKINITshouldberemovedinSQLServer2000andreplacedwithreferencestoeitherCREATEDATABASEorALTERDATABASE.

第4题：

While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

A、configure the database to run in ARCHIVELOG mode
B、configure the Flash Recovery Area to enable automatic database backup
C、schedule the database backup using DBMS_JOB package after creating the database
D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database
E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

正确答案:E

第5题：

If you create your database using Oracle Managed Files （OMF）， what is true？（）

A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures.
B、You must define directories for two online redo log groups and three copies of the control file.
C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.
D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

正确答案:D

第6题：

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.

正确答案:C

第7题：

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files.
B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.
C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.
D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.
E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

正确答案:D

第8题：

A、4 and 6
B、2，3，4，and 6
C、1，2，4，5，and 6
D、1，2，3，4，5，and 6

正确答案:C

第9题：

You are working on a new Oracle Database 11g server， where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant （DBCA）. Some of the requirements set for your database creation task are： 1：Configure the database to operate in shared server mode. 2：Disable automatic maintenance tasks such as optimizer statistics collection. 3：Configure a naming method to help the remote user connect to the database instance. 4：Use Automatic Storage Management （ASM） for storing the database files. 5：Configure daily database backup to flash recovery area. 6：Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database（）

A、4 and 6
B、2，3，4，and 6
C、1，2，4，5，and 6
D、1，2，3，4，5，and 6

正确答案:C

第10题：

In which two cases would you perform only consistent backup？（）

A、You are working on a database where downtime is not tolerated.
B、You are working on a database where downtime can be tolerated.
C、You are working on a database that operates in ARCHIVELOG mode.
D、You are working on a database that operates in NOARCHIVELOG mode.
E、You are working on a database where all the tablespaces are locally managed.
F、You are working on a database where control files and redo log files are multiplexed.
G、You are working on a database where control files and redo log files are not multiplexed.

正确答案:B,D

单选题You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your da

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容