网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）
A
It is NOT possible to switch unless no active transaction exist in UNDO1.
B
It is possible to switch to UNDO2； but current active transactions will abort.
C
It is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2.
D
It is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.
参考答案
参考解析
解析：
暂无解析
更多 “单选题What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）A It is NOT possible to switch unless no active transaction exist in UNDO1. B It is possible to switch to UNDO2； but current active transactions will abort. C It is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2. D It is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.” 相关考题
考题
—Hi, Mike. _________________ after your graduation?—I want to be a photographer.
A. What do you want to doB. What ‟s he want to doC. What does he want to doD. What are you want to do
考题
下列哪些特点体现了客服中心从业人员职业规划流程中“自我认知”的特点。（）A、Who are you？B、What do you want？C、What can you do？D、Where are you from？
考题
Which two statements about configuration an unconnected Catalyst Express 500 switch from setup mode using a PC are true？（）A、You may use Cisco Network Assistant to set up the initial configurationB、You must use CLI for initial configurationC、You may use either CLI or CAN for configurationD、You may make a direct connection to the PC from any point on the switchE、You may only make a direct connection from the port with the flashing green LED to the PC
考题
（）? -I am your agent. I want to see the captain. A、What are you?B、What can I do for you?C、Where are you from?D、What are you doing?
考题
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、the retention period to support flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance
考题
Switch R1 and R2 both belong to the Company VTP domain. What’s true about the switch operation in VTP domains？（）A、A switch can only reside in one management domainB、A switch is listening to VTP advertisements from their own domain onlyC、A switch is listening to VTP advertisements from multi domainsD、A switch can reside in one or more domainsE、VTP is no longer supported on Catalyst switches
考题
You are configuring a new Catalyst switch that you want to manage remotely from workstations on other network segments within your enterprise.Which of the following are required to allow remote management of the switch over IP?（）A、The switch name must match the workgroup name of the local network.B、The switch must be configured with an IP address and default gateway.C、The remote workstations must have access to the management VLAN of the switch.D、CDP must be enabled on the switch so that it can be located by other devices on the network.
考题
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.
考题
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、The retention period to support flashbackB、The expected length of the longest-running queryC、The number of undo tablespaces in the databaseD、The size of the Flash Recovery Area for the database instance
考题
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
考题
In which scenario will you use the Flashback Transaction Query feature？（）A、 when you want to restore an important table that is dropped from the Recycle BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
考题
Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）A、 undo tablespaceB、 index tablespaceC、 read-only tablespaceD、 temporary tablespace
考题
What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）A、It is NOT possible to switch unless no active transaction exist in UNDO1. B、It is possible to switch to UNDO2； but current active transactions will abort. C、It is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2. D、It is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.
考题
多选题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？（）ASet the UNDO_RETENTION parameter to AUTO.BCreate an initial undo segment in undotablespace.CSet the UNDO_RETENTION parameter to 900 or moreDSet the initialization parameter UNDO_MANAGEMENT to AUTOESet the UNDO_MANAGEMENT parameter to the name of an undotablespace
考题
多选题You are configuring a new Catalyst switch that you want to manage remotely from workstations on other network segments within your enterprise.Which of the following are required to allow remote management of the switch over IP?（）AThe switch name must match the workgroup name of the local network.BThe switch must be configured with an IP address and default gateway.CThe remote workstations must have access to the management VLAN of the switch.DCDP must be enabled on the switch so that it can be located by other devices on the network.
考题
单选题Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）A
undo tablespaceB
index tablespaceC
read-only tablespaceD
temporary tablespace
考题
单选题You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A
SQL Tuning AdvisorB
Undo AdvisorC
ADDMD
Memory Advisor
考题
多选题Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）Athe retention period to support flashbackBthe expected length of the longest-running queryCthe number of undo tablespaces in the databaseDthe size of the Flash Recovery Area for the database instance
考题
单选题You are the desktop administrator for your company's sales department. You need to perform a clean installation of Windows XP Professional on a computer that currently runs Windows 98. You start the installation. The text-based portion of Setup finishes successfully. Before the GUI-based portion of Setup starts, the computer stops responding. You investigate and discover that there is a problem with a device driver. You want to know which device is causing the problem. What should you do?（）A
Modify the Boot.ini file to include the /fastdetect switch.B
Modify the Boot.ini file to include the /sos switch.C
Restart Setup by using the /dudisable switch.D
Restart Setup by using the /dushare switch. E
Restart the computer. From the Recovery console, read the Dr. Watson log.F
Restart the computer. From the Recovery console, read the Comsetup.log file.
考题
多选题The EMP table exists in your schema. You want to execute the following query： SELECT ename， sal FROM emp AS OF TIMESTAMP （SYSTIMESTAMP - INTERVAL ’6’ MINUTE） WHERE ename = ’ALLEN’； What are the minimum requirements for the statement to execute successfully？（）AARCHIVELOG mode must be enabledBRow Movement must be enabled for the tableCFLASHBACK must be set to ON for the databaseDThe UNDO_MANAGEMENT parameter must be set to AUTOEThe UNDO_RETENTION parameter must be set appropriately
考题
单选题What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）A
It is NOT possible to switch unless no active transaction exist in UNDO1. B
It is possible to switch to UNDO2； but current active transactions will abort. C
It is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2. D
It is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.
考题
单选题You are using a dialup connection. You want to ensure that your password is encrypted. What protocols from the list below would you disable？ （）A
PAPB
SPAPC
MSCHAPD
MSCHAP V2
考题
多选题You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（）ASYSTEMBSYSAUXCUNDODUSERSETEMPFThis restore is not possible
考题
单选题AUM has been retaining about 15 minutes worth of undo. You want to double the retentionperiod， but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However， AUM still retains only about 15 minutes worth of undo. What is the problem？ （）A
You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.B
You need to increase the size of the undo tablespace.C
The undo tablespace is not set to auto-extend.D
You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.
考题
多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
考题
单选题In which scenario will you use the Flashback Transaction Query feature？（）A
when you want to restore an important table that is dropped from the Recycle BinB
when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC
when you want to restore a dropped user’s schemaD
when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
考题
单选题You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）A
ALTER DATABASE B
SET TRANSACTION C
ALTER ROLLBACK SEGMENT D
ALTER TABLE
考题
多选题Switch R1 and R2 both belong to the Company VTP domain. What’s true about the switch operation in VTP domains？（）AA switch can only reside in one management domainBA switch is listening to VTP advertisements from their own domain onlyCA switch is listening to VTP advertisements from multi domainsDA switch can reside in one or more domainsEVTP is no longer supported on Catalyst switches
热门标签
最新试卷
