单选题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 perfo

题目
单选题
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.

相似考题

1.In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.Which statement is true?()A. The CDB must be open.B. The CDB must be in the mount stage.C. The CDB must be in the nomount stage.D. Alt existing PDBs must be closed.

2.You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

3.You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?A．Increase the maximum file size of Sales_Data to 1,500MB.B．Use the DBCC SHRINKDATABASE statement.C．Set automatic file growth to 10 percent.D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.

4.You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?A．Enable the torn page detection database option for each database.B．Disable write caching on all disk controllers.C．Ensure that write caching disk controllers have battery backups.D．Create a database maintenance plan to check database integrity and make repairs each night.

参考答案和解析
正确答案： C
解析： 暂无解析
更多“You want to create a new optimized database for your transac”相关问题

  • 第1题：

    At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）

    • A、 Start the database in OPEN mode， and create a new index tablespace.
    • B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.
    • C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.
    • D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.

    正确答案:D

  • 第2题：

    tony wants to create a duplicate of the video application. He wants to keep a version of the data on the same server as the production application but does not want any new documents or documents modifications to be replicated into his new database once he creates it. Which one of the following should tony do to create his archive?（）

    • A、create a new copy of the database
    • B、create a replica of the database
    • C、Use the windows explorer to create a copy of the database file.
    • D、Create a replica copy of the database and disable replication on the database file.

    正确答案:D

  • 第3题：

    You completed the development of a new application and want to create a new domain in a new environment for functional testing. You want to have the same settings for your new domain as your old domain, with the option of changing the configuration in the new target environment. Which two actions should you execute?（）

    • A、Use the introspect () command in WLST to gather the configuration information from the  original domain.
    • B、Use pack/unpack to transfer the domain from one machine to another.
    • C、Create a domain template from the original domain using the Domain Template Builder and use  the Configuration Wizard to create a new domain from the template.
    • D、Use the Admin Console of the original domain to create a domain template from the original  domain and use the Configuration Wizard to create a new domain from the template.

    正确答案:C

  • 第4题：

    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

  • 第5题：

    You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

    • A、Set the UNDO_RETENTION parameter to AUTO.
    • B、Create an initial undo segment in undotablespace.
    • C、Set the UNDO_RETENTION parameter to 900 or more
    • D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
    • E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

    正确答案:D,E

  • 第6题：

    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

    • A、 redo log files
    • B、 password file
    • C、 control file
    • D、 change tracking file

    正确答案:D

  • 第7题：

    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

    • A、 You will need to open the database with the resetlogs command.
    • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
    • C、 You will use the resetlogs version of the create controlfile command.
    • D、 You will use the noresetlogs version of the create controlfile command.
    • E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

    正确答案:D

  • 第8题：

    单选题
    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）
    A

     redo log files

    B

     password file

    C

     control file

    D

     change tracking file


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）
    A

    create baseline metrics for today’s performance

    B

    write the current database metrics to a database table and create a trigger to compare with future database statistics

    C

    write the current database metrics to a flat file and create an operating script to compare with future database statistics

    D

    write the current database metrics to a database table and create a procedure to compare with future database statistics

    E

    write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks.   To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   After creating the password file， you remove the operating system authentication and change the value of the  REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）
    A

     CONNECT / AS SYSDBA

    B

     CONNECT sys/admin AS SYSDBA

    C

     CONNECT sys/admin@mynewdb AS SYSDBA

    D

     CONNECT sys/change_on_install AS SYSDBA


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    You completed the development of a new application and want to create a new domain in a new environment for functional testing. You want to have the same settings for your new domain as your old domain, with the option of changing the configuration in the new target environment. Which two actions should you execute?（）
    A

    Use the introspect () command in WLST to gather the configuration information from the  original domain.

    B

    Use pack/unpack to transfer the domain from one machine to another.

    C

    Create a domain template from the original domain using the Domain Template Builder and use  the Configuration Wizard to create a new domain from the template.

    D

    Use the Admin Console of the original domain to create a domain template from the original  domain and use the Configuration Wizard to create a new domain from the template.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）

    • A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.
    • B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’
    • C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）
    • D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

    正确答案:C

  • 第14题：

    You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）

    • A、create baseline metrics for today’s performance
    • B、write the current database metrics to a database table and create a trigger to compare with future database statistics
    • C、write the current database metrics to a flat file and create an operating script to compare with future database statistics
    • D、write the current database metrics to a database table and create a procedure to compare with future database statistics
    • E、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

    正确答案:A

  • 第15题：

    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

  • 第16题：

    You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）

    • A、Start the instance and open the database， instance recovery automatically recoverscontrol files
    • B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
    • C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
    • D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
    • E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

    正确答案:D

  • 第17题：

    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

    • A、 ONLINE
    • B、 REVERSE
    • C、 PARALLEL
    • D、 COMPRESS
    • E、 NOLOGGING
    • F、 COMPUTE STATISTICS

    正确答案:C,E

  • 第18题：

    You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）

    • A、Start the instance and open the database, instance recovery automatically recovers control files 
    • B、Create a file based on the contents of the trace file and save it to the control file locations and start the database 
    • C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 
    • D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 
    • E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

    正确答案:D

  • 第19题：

    多选题
    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）
    A

    ONLINE

    B

    REVERSE

    C

    PARALLEL

    D

    COMPRESS

    E

    NOLOGGING

    F

    COMPUTE STATISTICS


    正确答案： E,B
    解析： 暂无解析

  • 第20题：

    单选题
    You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

     mount the new disk group in the ASM instance

    B

     restart the ASM instance and the production database instance

    C

     register the new disk groups in the production database instance

    D

     restart the ASM instance without restarting the production database instance

    E

     include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

    mount the new disk group in the ASM instance

    B

    restart the ASM instance and the production database instance

    C

    register the new disk groups in the production database instance

    D

    restart the ASM instance without restarting the production database instance

    E

    include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）
    A

    The CDB must be open.

    B

    The CDB must be in the mount stage.

    C

    The CDB must be in the nomount stage.

    D

    Alt existing PDBs must be closed.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）
    A

     You will need to open the database with the resetlogs command.

    B

     All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

    C

     You will use the resetlogs version of the create controlfile command.

    D

     You will use the noresetlogs version of the create controlfile command.

    E

     You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command


    正确答案： E
    解析： 暂无解析

  • 第24题：

    多选题
    You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）
    A

    Reregistering the target database in recovery catalog

    B

    Transporting the new tablespaces to the recovery catalog database

    C

    Syncronizing the recovery catalog with the target database control file

    D

    Performing a fresh backup of the target database to include the new data files in the catalog database


    正确答案： C,A
    解析： 暂无解析

相关内容