首页计算机考试Oracle认证
(单选题)

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade,you observe that the DBA executes the following script:   SQL> @utlrp.sql   What is the significance of executing this script?()  

A It performs parallel recompilation of only the stored PL/SQL code.

B It performs sequential recompilation of only the stored PL/SQL code.

C It performs parallel recompilation of any stored PL/SQL as well as Java code.

D It performs sequential recompilation of any stored PL/SQL as well as Java code.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()

    答案解析

  • (单选题)

    You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()  

    答案解析

  • (单选题)

    In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What isthe impact of this setting()

    答案解析

  • (单选题)

    in your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impactof this setting()

    答案解析

  • (单选题)

    You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()

    答案解析

  • (单选题)

    You issue the following command:   RMAN>CONFIGURE BACKUP OPTIMIZATION ON;   What is the result of this command on your backups?()

    答案解析

  • (单选题)

    Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received en error regarding DISK 3 on your server. This is the location of your data file for the SYSTEM tablespace. Which option is open to you?()

    答案解析

  • (单选题)

    You issued the following statement in your SQL*Plus session:   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()

    答案解析

  • (单选题)

    You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16?()  

    答案解析

  • (单选题)

    Your database runs in ARCHIVELOG mode, and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database.  How can you do this?()

    答案解析

快考试在线搜题