首页/ 题库 / [单选题]

Youre perfo的答案

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS 
which statement is true?()  

单选题
2021-12-31 23:03
A、 You cannot perform the TSPITR with the constraints enabled.
B、 You must perform the TSPITR recovery of both tablespaces for it to be successful.
C、 You can perform TSPITR only on the USERS tablespace.
D、 RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
E、 The TSPITR will only be successful if the constraint is enabled.
查看答案

正确答案
B

试题解析

标签: 1Z0-053
感兴趣题目

Sometimes performance is more important than availability (e.g., in cases where the data can be easily re-created). 
Which of the following is the appropriate disk configuration for an application that requires faster writes over availability()

An administrator performs a Live Partition Mobility operation. After the operation completes, the administrator runs errpt -a. 
What is the machine ID reported by errpt command?()

You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to recover the data files but discover that the archived redo log file with sequence number 45, which is needed to perform complete recovery, is invalid. You then begin incomplete recovery-You receive this prompt: 
ORA-00279:change 309012...03/09/01 11:33:56 needed for thread ORA-00289: suggestion :  
/disk1/archive/arch_45.rdo ORA-00280: change 309012 for thread 1 is in sequence #45 Specify log: 
{=suggested 
 filename 
 AUTO 
 CANCEL} 
What is the correct response?()

You have lost all members of your current redo log file group. You issue this query: SQL> select * from v$log; 
GROUP#    SEQ#     BYTES        ARC STATUS            FIRST_NAME 
1                  60           153600        NO INACTIVE            01-03-09:19:34 
2                  61           153600        NO CURRENT            01-03-09:19:50 
You then perform an incomplete recover. You receive this message: ORA-00279: 
change 309141...03/09/01 19:50:14 Needed for thread 1 
ORA-00289: suggestion : /disk1/archive/arch_61.rdo ORA-00280: change 309043 for thread 1 is in  sequence #61 Specify log: {=suggested 
 filename 
 AUTO 
 CANCEL} How should you respond to this message?()

You create an ASP.NET server control in the SampleControl namespace. The control uses a JavaScript file names Refresh.js to implement AJAX functionality.You need to ensre that the JavaScript file is included in the assembly. 
Which two actions should you perform?()

You are implementing a read-only page that includes the following controls.
You disable view state to improve performance. You need to ensure that the page is updated to display the latest data when the user clicks the refresh button. Which code segment should you use?() 

A customer is interested in reducing energy consumption and infrastructure consolidation for space. The customer needs a maximum of 14 servers in 7U rack. 
Which IBM BladeCenter Chassis should be recommended? ()

You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. 
The current consumption of your CPU is approximately 40 percent. 
Which type of backup should you perform?()  

You are designing a top-level OU structure to meet the business and technical requirements. 
Which top-evel OU or OUs should you use? ()

A customer has installed an IBM System Storage DS8700 with 20 TB of storage, two-way processor version, 32 GB cache, and 16 Fibre Channel ports. The customer is beginning to experience throughput performance issues. 
To address this performance consideration with minimal cost to the customer, which of the following should be the FIRST step to resolve the problem()

You are employed as the Exchange administrator at Company.com.You are in the process of 
installing a new Exchange Server 2010 Organization.After the installation you send a text message to an external client and receive the subsequent non-delivery report (NDR): "Delivery has failed to these recipients or groups: [email protected] ([email protected]).The recipient’s e-mail system isn’t accepting messages now.Please try resending this message later or contact the recipient directly." You attempt to e-mail the user from an external e-mail system with great success.To ensure productivity you need to make sure e-mails can be sent to external clients from within the organization.
What should you do?()

A System p administrator in a manufacturing customer plans to migrate an AIX 5.2 system to a new LPAR on an existing System p using VIOS. 
Which of the following must be completed prior to this migration ()

相关题目

Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?()

You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). 
Server1 runs an application named App1. All client computers run Windows XP Professional Service Pack 3 (SP3). Users from a remote network segment report poor performance when they run App1. You need to identify whether the cause of the poor network performance is packet loss. 
Which tool should you use?()

You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces, and dropped a couple of tablespaces. This morning, due to hardware failure, you lost all your control files. 
How would you recover the database from this situation?()

Your network consists of a single Active Directory forest. The sales department in your company has 600 Windows Server 2008 R2 servers. You need to recommend a solution to monitor the performance of the 600 servers.
Your solution must meet the following requirements:  
èGenerate alerts when the average processor usage is higher than 90 percent for 20 minutes.  
èAutomatically adjust the processor monitoring threshold to allow for temporary changes in the workload.  
What should you recommend?()

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS 
which statement is true?()  

You just completed a manual open database backup. However there seems to be a problem with the database performance. You discover that the database is generating many log switches and the LGWR is consuming lots of CPU time. You have an idea of what the problem is and you begin looking at the information in V$BACKUP and in V$DATAFILE_HEADER.
What do you suspect is the problem?()

A customer has a 4-core POWER6 570 with 4 partitions and a 2-port 1Gbps Integrated Virtual Ethernet (IVE) Adapter. They are having problems with throughput on the Ethernet adapter and want to improve performance. 
Which of the following solutions will help the customer with this issue for the least cost and with the least interruption?()

A customer wants to purchase an IBM System Storage DS8700 to support a high-performance database environment. 
Which technical solution gives the customer the best relationship between I/O performance at the machine’s backend vs. capacity installed in the machine()

You add an Online Responder to an Online Responder Array.  
You need to ensure that the new Online Responder resolves synchronization conflicts for all members of  the Array.  
What should you do()

Exhibit, One of the important tables in the USERStablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true?()

View the Exhibit. 

One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to recover the table. 
Which statement is true?()

Company.com has a non-IBM disk storage unit connected by two Fibre channel connections. The  Nodes have multiple connections to the storage device that allow load balancing. A failure with one Fibre adapter or connection will not be noticed by the application, but it needs to be addressed. 
How can HACMP help make this environment more robust?()  

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK,or any data definition language (DDL) command: 
SQL> SELECT job FROM emp 
2  WHERE job=’CLERK’ FOR UPDATE OF empno; 
SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session?()

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp 
2 WHERE job=’CLERK’ FOR UPDATE OF empno; 
SCOTT has opened another session to work with the database instance. 
Which three operations wouldwait when issued in SCOTT’s second session()

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement:  
SQL> DROP TABLE SCOTT.EMP PURGE;  
After one hour, you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup?()

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror after the INSERT statement is issued and few rows are inserted:INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) *ERROR at line 1:
ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions eitherof which will help you resolve this problem. ()

int index = 1; 
boolean[] test = new Boolean[3]; 
boolean foo= test [index];  
What is the result?()  

An IPCC Express deployment requires support for 20 concurrently logged-in agents. The agents aresplit across two remote sites, and the High Availability CRS Engine, Database Server, VoIP Monitoring, and Recording server processes run at a central data center. The agents will be using CAD with 7960 phones and end-point monitoring. Very little recording and silent monitoring will be performed, and no historical reporting will be done during call center open hours. Assume the minimum number of servers is desired. 
How many IPCC Express hardware servers would be required for this IPCC Express deployment?()

You work as a network technician at Company.com, study the exhibit provided. You are implementing this QoS configuration to improve the bandwidth guarantees for traffic towards two servers, one with the IP address 5.5.5.5 and the other with the IP address 5.5.5.4. Even after the configuration is applied, performance does not seem to improve. Which will be the most likely cause of this problem?()

You create Windows Forms applications by using the .NET Framework 3.5. You plan to deploy a new application by using the ClickOnce technology.During deployment, the application performs the following tasks:
(1)Modifies registry keys  
(2)Modifies the files located in the %PROGRAM FILES% folder 
(3)Administrative permissions are not granted to users who install the application   
You need to ensure that the following requirements are met: 
(1)The application can be deployed to Windows Vista client computers that are not part of an Active Directory domain 
(2)When the application is deployed, users are not prompted to elevate their permissions   
What should you do?()

广告位招租WX:84302438

免费的网站请分享给朋友吧