违法和不良信息举报 联系客服
免费注册 登录

You perform the following activ

题目

You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）

  • A、to minimize plan regression due to the use of a new optimizer version
  • B、to completely avoid the use of new plans generated by a new optimizer version
  • C、to prevent plan capturing when the SQL statement is executed after the database upgrade
  • D、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You need to configure a new computer to dual－boot to the following operating systems:·Microsoft Windows XP Professional·Microsoft Windows VistaWhich two procedures should you perform?()

A.A

B.B

C.C

D.D


参考答案：A, D

第2题：

Which of the following statements is NOT true about RMAN？（）

  • A、It improves usability by enabling you to reuse the scripts to perform recovery operations.
  • B、It detects block corruption while restoration and recovery operations.
  • C、It enables you to perform block media recovery.
  • D、It is capable to recover through unrecoverable operations， with only full database backups.

正确答案:A

第3题：

View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()

A. 4

B. 8

C. 7

D. 0


参考答案：A

第4题：

Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

  • A、 The target database must be in NOARCHIVELOG mode.
  • B、 No backup is required of the database before you perform a TSPITR.
  • C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
  • D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
  • E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

正确答案:A,B

第5题：

Which three are true regarding the use of outer joins? （）

  • A、You cannot use IN operator in a condition that involves an outerjoin.
  • B、You use (+) on both sides of the WHERE condition to perform an outerjoin.
  • C、You use (*) on both sides of the WHERE condition to perform an outerjoin.
  • D、You use an outerjoin to see only the rows that do not meet the join condition.
  • E、In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
  • F、You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.

正确答案:D,E,F

第6题：

You have a server that runs Windows Server 2003 Service Pack 2 (SP2). The server is configured as shown in the following table.You need to ensure that you can restore the server and all its data in the event of a complete system failure.You perform an Automated System Recovery (ASR) backup.What else should you backup? （）

A.volume C

B.volume D

C.volume E

D.the system state


参考答案：C

第7题：

You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）

  • A、 Whole database
  • B、 Tablespaces
  • C、 Datafiles
  • D、 Archive logs
  • E、 Redo logs

正确答案:E

第8题：

You perform an in-place upgrade on a Microsoft Windows XP Service Pack 2 (SP2) computer to Windows Vista.After the upgrade, you attempt to run a custom application. You receive the following error message: This application is only designed to run on Windows XP or later.”You need to run the application on Windows Vista.What should you do?（）

A.A

B.B

C.C

D.D


参考答案：D

第9题：

You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). On Server1, you have the following backup schedule: ·Normal backups every Saturday at 01:00 Differential backups every weekday at 02:00, except on Saturday You need to perform a complete manual backup of Server1 on Tuesday. The backup must not change which files are backed up during the next scheduled backup. Which type of backup should you perform? （）

  • A、copy
  • B、daily
  • C、incremental
  • D、normal

正确答案:A

第10题：

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

  • A、shut down and restart the instance
  • B、add new tempfiles to the temporary tablespaces after recovery
  • C、perform a media recovery and open the database with the RESETLOGS option
  • D、perform a media recovery and bring the database to NOARCHIVELOG mode

正确答案:B,C

更多相关问题
相关内容