Such a database would be extremely costly to set up.A:update B:transfer C:destroy D:establish

题目
Such a database would be extremely costly to set up.

A:update
B:transfer
C:destroy
D:establish
相似考题

1.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.

2.Such a database would be extremely costly to set up.A:destroy B:transfer C:update D:establish

3. You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database.  What action would you take to achieve this？（）A、Use the Database Resource Manager.B、Set the limits in the profiles used by users.C、Modify the SESSIONS initialization parameter.D、Set the warning threshold for the Current Logons Count metric.

4.Such a database would be extremely costly to set up.A:transfer B:destroy C:establish D:update

更多“Such a database would be extremely costly to set up.”相关问题

  • 第1题：

    You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? （）

    • A、Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
    • B、Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
    • C、Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
    • D、Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

    正确答案:A,D

  • 第2题：

    Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command？（）

    • A、The command would return an error because LOG_BUFFER is a static parameter.
    • B、The parameter value would be changed and it would come into effect immediately.
    • C、You need to restart the database so that parameter changes can come into effect.
    • D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

    正确答案:A

  • 第3题：

    Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）：  CREATE TABLESPACE user_tbsp  DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M；  What would be the result of this command？（）

    • A、It would result in an error because the template cannot be used along with the disk group.
    • B、It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
    • C、It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.
    • D、It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.

    正确答案:C

  • 第4题：

    You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）

    • A、The database performance would be enhanced.
    • B、The redo log files would be get filled more frequently.
    • C、The overall database performance would be degraded.
    • D、The mean time to recover （MTTR） would be increased.

    正确答案:C

  • 第5题：

    The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

    • A、 Enable flashback logging.
    • B、 Start the database in the ARCHIVELOG mode.
    • C、 Issue the ALTER DATABASE FLASHBACK ON； command.
    • D、 Set the FAST_START_MTTR_TARGET initialization parameter.

    正确答案:A

  • 第6题：

    You want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）

    • A、NLSLANG
    • B、NLSLENGTHSEMANTICS
    • C、NLSTERRITORY
    • D、NLSLANGUAGE
    • E、NLSCHARACTERSET
    • F、NLSDATELANGUAGE
    • G、NLSNCHARCHARACTERSET

    正确答案:A

  • 第7题：

    What is the purpose of importing from an export，and specifying that no rows be imported and that the output goes to a log file？（）

    • A、To verify space requirements in the target database before importing.
    • B、To generate the SQL for the DDL operations that would occur during import.
    • C、To check character set compatibility between the export file and the target database.
    • D、To check for integrity constraint violations that would occur in the target database.

    正确答案:C

  • 第8题：

    单选题
    The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）
    A

     Enable flashback logging.

    B

     Start the database in the ARCHIVELOG mode.

    C

     Issue the ALTER DATABASE FLASHBACK ON； command.

    D

     Set the FAST_START_MTTR_TARGET initialization parameter.


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

  • 第9题：

    单选题
    Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH；  What would be the outcome of this command？ （）
    A

    The command would return an error because LOG_BUFFER is a static parameter.

    B

    The parameter value would be changed and it would come into effect immediately.

    C

    You need to restart the database so that parameter changes can come into effect.

    D

    The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.


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

  • 第10题：

    多选题
    Which two statements are true regarding undo tablespaces（）
    A

    The database can have more than one undo tablespace.

    B

    The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.

    C

    Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.

    D

    An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.


    正确答案： C,B
    解析： A答案：可以有一个或多个undo表空间，A答案正确。 
    sys@TEST0924> select TABLESPACE_NAME，CONTENTS from dba_tablespaces； TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT UNDOTBS1 UNDO TEMP TEMPORARY USERS PERMANENT UNDOTBS2 UNDO 
    EXAMPLE PERMANENT LXTBS PERMANENT FLA_TBS1 PERMANENT FLA_TBS2 PERMANENT 10 rows selected. 
    B答案：UNDO_TABLESPACE只能用于自动undo段模式，B答案错误

  • 第11题：

    单选题
    What is the purpose of importing from an export，and specifying that no rows be imported and that the output goes to a log file？（）
    A

    To verify space requirements in the target database before importing.

    B

    To generate the SQL for the DDL operations that would occur during import.

    C

    To check character set compatibility between the export file and the target database.

    D

    To check for integrity constraint violations that would occur in the target database.


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

  • 第12题：

    单选题
    You want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）
    A

    NLSLANG

    B

    NLSLENGTHSEMANTICS

    C

    NLSTERRITORY

    D

    NLSLANGUAGE

    E

    NLSCHARACTERSET

    F

    NLSDATELANGUAGE

    G

    NLSNCHARCHARACTERSET


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

  • 第13题：

    In a database with the database character set of US7ASCII and a national character set of UTF-8， which datatypes would be capable of storing Unicode data by default？（）

    • A、 VARCHAR2
    • B、 CHAR
    • C、 NVARCHAR2
    • D、 CLOB
    • E、 LONG

    正确答案:C

  • 第14题：

    The database users are connecting to the PROD database from different  applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one.  Which action would you take to achieve this objective？（）

    • A、set the SESSIONS to 1 in the parameter file
    • B、grant SINGLE SESSION privilege to all of the users
    • C、set the SESSIONS_PER_USER to 1 in the users’ profile
    • D、grant RESTRICTED SESSION privilege to all of the database users
    • E、create a role with SINGLE SESSION privilege and assign the role to the users

    正确答案:C

  • 第15题：

    Which two statements are true regarding undo tablespaces（）

    • A、The database can have more than one undo tablespace.
    • B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
    • C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
    • D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

    正确答案:A,C

  • 第16题：

    The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）  

    • A、 The Oracle database will perform block checking for the index blocks only
    • B、 The Oracle database will not perform block checking for any of the data blocks
    • C、 The Oracle database will perform block checking for the default permanent tablespace only
    • D、 The Oracle database will perform block checking for the data blocks in all user tablespaces
    • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

    正确答案:E

  • 第17题：

    You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

    • A、The database would open normally.
    • B、The database would not open， and it would stop at mount stage.
    • C、The database would open after automatically performing instance recovery.
    • D、The database would not open， and you have to perform database recovery to open it.

    正确答案:C

  • 第18题：

    Which of the following would you use to enable automatic media recovery for a database？（）

    • A、SET AUTORECOVERY ON
    • B、SET RECOVERY ON
    • C、SET AUTO ON
    • D、You cannot enable automatic media recovery.

    正确答案:A

  • 第19题：

    单选题
    In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?（）
    A

    VARCHAR2

    B

    CHAR

    C

    NVARCHAR2

    D

    CLOB

    E

    LONG


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

  • 第20题：

    单选题
    Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA，  which configuration would you set to support more than 1，500 connections at a time（）
    A

    You would configure more listeners for the database.

    B

    You would configure the database in shared server mode to use the connection pooling feature.

    C

    You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.

    D

    You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.


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

  • 第21题：

    单选题
    From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
    A

     set the CPU time per call in the users profile

    B

     set the CPU time per session in the users profiles

    C

     set the TIMED_STATISTICS parameter to TRUE in the parameter file

    D

     set the CPU levels for the users’ group using Resource Manager


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

  • 第22题：

    单选题
    In a database with the database character set of US7ASCII and a national character set of UTF-8， which datatypes would be capable of storing Unicode data by default？（）
    A

     VARCHAR2

    B

     CHAR

    C

     NVARCHAR2

    D

     CLOB

    E

     LONG


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

  • 第23题：

    单选题
    You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）
    A

    The database performance would be enhanced.

    B

    The redo log files would be get filled more frequently.

    C

    The overall database performance would be degraded.

    D

    The mean time to recover （MTTR） would be increased.


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

  • 第24题：

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


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

相关内容