网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Such a database would be extremely costly to set up.
A:transfer
B:destroy
C:establish
D:update
B:destroy
C:establish
D:update
参考答案
参考解析
解析：建立这样的数据库成本会非常高。set up：建立；transfer：转移；destroy：破坏；establish:成立，最符合题意；update：更新。
更多 “Such a database would be extremely costly to set up.A:transfer B:destroy C:establish D:update ” 相关考题
考题
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.
考题
Such a database would be extremely costly to set up.A:destroy
B:transfer
C:update
D:establish
考题
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.
考题
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.
考题
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、 VARCHAR2B、 CHARC、 NVARCHAR2D、 CLOBE、 LONG
考题
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.
考题
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 fileB、grant SINGLE SESSION privilege to all of the usersC、set the SESSIONS_PER_USER to 1 in the users’ profileD、grant RESTRICTED SESSION privilege to all of the database usersE、create a role with SINGLE SESSION privilege and assign the role to the users
考题
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.
考题
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.
考题
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.
考题
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 onlyB、 The Oracle database will not perform block checking for any of the data blocksC、 The Oracle database will perform block checking for the default permanent tablespace onlyD、 The Oracle database will perform block checking for the data blocks in all user tablespacesE、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
考题
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.
考题
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.
考题
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、NLSLANGB、NLSLENGTHSEMANTICSC、NLSTERRITORYD、NLSLANGUAGEE、NLSCHARACTERSETF、NLSDATELANGUAGEG、NLSNCHARCHARACTERSET
考题
Which of the following would you use to enable automatic media recovery for a database？（）A、SET AUTORECOVERY ONB、SET RECOVERY ONC、SET AUTO OND、You cannot enable automatic media recovery.
考题
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.
考题
单选题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
VARCHAR2B
CHARC
NVARCHAR2D
CLOBE
LONG
考题
单选题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.
考题
单选题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.
考题
单选题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.
考题
单选题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 profileB
set the CPU time per session in the users profilesC
set the TIMED_STATISTICS parameter to TRUE in the parameter fileD
set the CPU levels for the users’ group using Resource Manager
考题
多选题Which two statements are true regarding undo tablespaces（）AThe database can have more than one undo tablespace.BThe UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.CUndo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.DAn 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.
考题
单选题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
VARCHAR2B
CHARC
NVARCHAR2D
CLOBE
LONG
考题
单选题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.
考题
单选题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.
考题
单选题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
NLSLANGB
NLSLENGTHSEMANTICSC
NLSTERRITORYD
NLSLANGUAGEE
NLSCHARACTERSETF
NLSDATELANGUAGEG
NLSNCHARCHARACTERSET
考题
单选题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.
热门标签
最新试卷