多选题You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）ASet the UNDO_RETENTION parameter to 900 or more.BCreate an initial undo segment in the undo tablespace.CEnable the retention guarantee for the undo tablespace.DSet the UNDO_TABLESPACE parameter to UNDO_TBS1.ESet the UNDO_MANAGEMENT initialization parameter to AUTO.
多选题
You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）
A
Set the UNDO_RETENTION parameter to 900 or more.
B
Create an initial undo segment in the undo tablespace.
C
Enable the retention guarantee for the undo tablespace.
D
Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
E
Set the UNDO_MANAGEMENT initialization parameter to AUTO.
参考解析
解析：
暂无解析
相关考题：
You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.You are also the administrator of Oracle relational database management system (RDBMS) server.This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create reports on the SQL Server computer by using the minimum amount of disk space.What should you do?A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.
You are configuring for Oracle Shared Server. Which service is required？ （）A、Oracle Net ServiceB、Oracle HTTP ServiceC、Oracle Paging ServiceD、Internet Directory Service
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（） A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start， and the undo segment will contain the undo data for at least one hour.D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.
Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ？（）A、 If you select a non-XA JDBC driver， you can use WebLogic AQ JMS in both local global transactionsB、 Oracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMSC、 Oracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic ServerD、 If you select an XA JDBC driver， you can use WebLogic AQ JMS in both local and global transactions
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）A、Oracle Flashback uses undo information to construct consistent data. B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
Which two statements are true regarding transactions in an Oracle database（）A、Multiple transactions can use the same undo segment.B、A transaction is assigned an undo segment when it is started.C、More than one transaction cannot share the same extent in the undo tablespace.D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）A、INSERT B、SELECT C、UPDATE D、DELETE
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（） A、It would return information regarding only the last committed transaction.B、It would return only the active transactions in all the undo segments in the database.C、It would return only the committed transactions in all the undo segments in the database.D、It would return both active and committed transactions in all the undo segments in the database.E、It would return information regarding the transactions that began and were committed in the last 30 minutes.
Your network consists of two subnets named Subnet1 and Subnet2. You have a server named Server1 that runs Windows Sever 2003 Service Pack 2 (SP2). Server1 is located on Subnet1. Users from Subnet1 report poor performance when they connect to Server1. Users from Subnet2 report that they are unable to connect to Server1.You monitor both network segments and discover a large number of NetBIOS broadcasts on both network segments.You need to reduce the number of broadcasts on the network. What should you deploy?（）A、a DHCP Relay Agent B、a WINS server C、Connection Point Services (CPS) D、Simple TCP/IP Services on all computers
You need to design a method to allow the new-ideas-testking.com Web site to function in accordance with security and business requirements. What should you do？（）A、Require a PPTP VPN for all connections to the Web serverB、Require that traffic between Web browsers and the Web server uses an L2TP/IPSec tunnelC、Require that traffic between Web browsers and the Web server uses SSLD、Require certificate mappings between the Web server and Active Directory
Your network consists of a single Active Directory site that includes two network segments. Thenetwork segments connect by using a router that is RFC 1542 compliant. You plan to use Windows Deployment Services （WDS） to deploy Windows Server 2008 R2 servers. All new servers support Pre-Boot Execution Environment （PXE）. You need to design a deployment strategy to meet the following requirements： èSupport Windows Server？2008 R2 èDeploy the servers by using WDS in both network segments èMinimize the number of servers used to support WDS What should you include in your design？（） A、Deploy one server. Install WDS and DHCP on the server. Configure the IP Helper tables on therouterbetween the network segments.B、Deploy two servers. Install WDS and DHCP on both servers. Place one server on each of the network segments. Configure both servers to support DHCP option 60.C、Deploy two servers. Install WDS and DHCP on both servers. Place one server on each of the network segments. Configure both servers to support DHCP option 252.D、Deploy two servers. Install WDS and DHCP on one server. Install DHCP on the other server. Place one server on each of the network segments. Configure both servers to support DHCP option60.
You have two stand-alone servers that run Windows Server 2003 Service Pack 2 （SP2）. You assign the Secure Server （Require security） IPSec policy to both servers. From Server1， you notice that you cannot access resources on Server2. You need to ensure that you can access resources on Server2. All communications between Server1 and Server2 must be encrypted. What should you do？（）A、On Server1， assign the Client （Respond only） IPSec policy.B、On Server2， assign the Server （Request Security） IPSec Policy.C、On Server1 and Server2， modify the authentication settings in the Secure Server （Require security） IPSec Policy.D、On Server1 and Server2， enable Master Key perfect forward secrecy （PFS） in the Secure Server （Require security） IPSec Policy.
You need to design an administrative model that meets the business and technical requirements. What should you do？（）A、Assign permissions to manage Mailbox and Exchange Server configuration to the server-admins groupB、Assign permissions to manage Mailbox and Exchange Server configuration to the domain-admins groupC、Assign permissions to manage Mailboxes to the server-admins group. Assign permissions to manage Exchange Servers configuration to the domain-admins groupD、Assign permissions to manage Mailboxes to the domain-admins group. Assign permissions to manage Exchange Servers configuration to the server-admins group
You need to design a remote administration solution for servers on the internal network. Your solution must meet business and security requirements. What should you do？（）A、Permit administrators to use an HTTP interface to manage servers remotelyB、Permit only administrators to connect to the servers’ Telnet serviceC、Permit administrators to manage the servers by using Microsoft NetMeetingD、Require administrators to use Remote Desktop for Administration connections to manage the servers
单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A VERSIONS_STARTSCNB VERSIONS_STARTTIMEC VERSIONS_XIDD VERSIONS_OPERATION
多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
单选题When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）AOnline BPending online COffline DStale
单选题You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）AIncrease the undo returnBCreate more undo segmentsCCreate another undotablespaceDIncrease the size of the undotablespace
单选题Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）Aincrease the undo retentionBcreate more undo segmentsCcreate another undo tablespaceDincrease the size of the undo tablespace
多选题Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ？（）AIf you select a non-XA JDBC driver， you can use WebLogic AQ JMS in both local global transactionsBOracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMSCOracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic ServerDIf you select an XA JDBC driver， you can use WebLogic AQ JMS in both local and global transactions
单选题You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）AIncrease the undo returnBCreate more undo segmentsCCreate another undotablespaceDIncrease the size of the undo tablespace
单选题You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）A The database will not start.B The database will start but will not retain the undo data in the undo segment.C The database will start， and the undo segment will contain the undo data for at least one hour.D The database will start， and the undo segment will retain the undo data for at least 15 minutes.
单选题You have two stand-alone servers that run Windows Server 2003 Service Pack 2 (SP2). You assign the Secure Server (Require security) IPSec policy to both servers. From Server1, you notice that you cannot access resources on Server2.You need to ensure that you can access resources on Server2. All communications between Server1 and Server2 must be encrypted. What should you do?（）AOn Server1, assign the Client (Respond only) IPSec policy. BOn Server2, assign the Server (Request Security) IPSec Policy. COn Server1 and Server2, modify the authentication settings in the Secure Server (Require security) IPSec Policy. DOn Server1 and Server2, enable Master Key perfect forward secrecy (PFS) in the Secure Server (Require security) IPSec Policy.
单选题You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）AIt would return information regarding only the last committed transaction.BIt would return only the active transactions in all the undo segments in the database.CIt would return only the committed transactions in all the undo segments in the database.DIt would return both active and committed transactions in all the undo segments in the database.EIt would return information regarding the transactions that began and were committed in the last 30 minutes.
单选题You manage a domain controller that runs Windows Server 2008 R2 and the DNS Server server role.The DNS server hosts an Active Directory-integrated zone for your domain.You need to provide a user with the ability to manage records in the zone. The user must not be able to modify the DNS server settings.What should you do？（）AAdd the user to the DNSUpdateProxy Global security group.BAdd the user to the DNSAdmins Domain Local security group.CGrant the user permissions on the zone.DGrant the user permissions on the DNS server.
单选题Your network consists of two subnets named Subnet1 and Subnet2. You have a server named Server1 that runs Windows Sever 2003 Service Pack 2 （SP2）. Server1 is located on Subnet1. Users from Subnet1 report poor performance when they connect to Server1. Users from Subnet2 report that they are unable to connect to Server1. You monitor both network segments and discover a large number of NetBIOS broadcasts on both network segments.You need to reduce the number of broadcasts on the network. What should you deploy？（）Aa DHCP Relay AgentBa WINS serverCConnection Point Services（CPS）DSimple TCP/IP Services on all computers