You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）

相似题目

• Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode. E . The database operates in NOARCHIEVELOG mode.

  查看最佳答案

• As part of your design， you are evaluating whether to upgrade all domains to Windows Server 2003. Based on current configurations，  which server or servers prevent you from achieving this goal？（）

  A .  DC2 B .  DC3 C .  DC4 D .  DC5 E .  DC6 F .  Server1

  查看最佳答案

• If you create your database using Oracle Managed Files （OMF）， what is true？（）

  A . You must use Oracle predefined names to identify raw partitions that will hold OMF structures.  B . You must define directories for two online redo log groups and three copies of the control file.  C . If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.  D . You must use only OMF data files when adding new tablespaces or data files to your database in the future.

  查看最佳答案

• You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users’ passwords？（）  

  A .  All passwords automatically become case-sensitive. B .  All passwords remain non-case-sensitive till they are changed. C .  All passwords remain non-case-sensitive and cannot be changed. D .  All passwords remain non-case-sensitive until their password attribute in the profile is altered.

  查看最佳答案

• You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）

  A .  It must be executed from the Oracle Database 11g environment. B .  It must be executed only after the SYSAUX tablespace has been created. C .  It must be executed from the environment of the database that is being upgraded. D .  It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E .  It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

  查看最佳答案

• You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）

  A . Compare Period ADDM report B . AWR Compare Period report C . Active Session History (ASH) report D . Taking a new snapshot and comparing it with a preserved snapshot

  查看最佳答案

• You upgrade all client computers in your network to Windows 2000 Professional. Then you apply the basicwk.inf security template to the computers. Now， none of the users can run the company’s database application. What should you do？（）

  A . Apply the compactws.inf security template to the computers. B . Delete the basicwk.inf security template file from the computers. C . Use the system policy editor to configure a new security policy for the database application. D . For each user account， allow read permission to the database application and in associated files.

  查看最佳答案

• You want to upgrade your MS Windows 98 computer to Windows 2000 professional. Before the actual installation， you want to know whether your system’s hardware or software is compatible with Windows 2000 professional or not.   What you will do. （）

  A . Consult the HCL. B . See the online documentation of Windows 2000 professional.  C . Run WINNT32/CHECKUPGRADEONLY. D . Consult the technical support team of Windows 2000.

  查看最佳答案

• You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.  Which objective will be achieved by this setting？（）

  A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

  查看最佳答案

• You have a domain that was created and configured with WebLogic 10.3.5. You want to upgrade  the domain to use WebLogic 12c. Which Oracle tool must you use to upgrade your domain?（）

  A . Oracle WebLogic Domain Upgrade tool B . Smart Update  C . Smart Upgrade   D . No tool required, just install WebLogic 12c, update the domain to point to the new WebLogic installation and start your domain. E . JDeveloper

  查看最佳答案

• As part of your design, you are evaluating whether to upgrade all domains to Windows Server 2003. Based on current configurations, which server or servers prevent you from achieving this goal?（）

  A . DC2 B . DC3 C . DC4 D . DC5 E . DC6 F . Server1

  查看最佳答案

• You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

  A . SYSTEM  B . OUTLN  C . INTERNAL  D . SYS

  查看最佳答案

• You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

  A .  by using the Flashback Database feature B .  by using RMAN incomplete recovery C .  by performing a user-managed incomplete recovery D .  by dropping and re-creating the index tablespace

  查看最佳答案

• You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

  A . It must be executed from the Oracle Database 11g environment. B . It must be executed only after the SYSAUX tablespace has been created. C . It must be executed from the environment of the database that is being upgraded. D . It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E . It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

  查看最佳答案

• You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

  A .  online redo log files B .  alert log files C .  control file D .  datafiles associated with the SYSTEM tablespace

  查看最佳答案

• You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

  A .  MMAN B .  PMON C .  MMON D .  MMNL

  查看最佳答案

• You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

  A . One tablespace has only one datafile B . Many tablespaces can share one datafile C . One tablespace can have many datafiles D . One datafile can contain many tablespace

  查看最佳答案

• For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

  A .  Automatic PGA Memory Management B .  Automatic SGA Memory Management C .  Automatic Shared Memory Management D .  Automatic Memory Management E .  Manual SGA Memory Management F .  None of the above

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

  A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

  查看最佳答案

• Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode.  E . The database operates in NOARCHIEVELOG mode.

  查看最佳答案

• 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.&e

  查看最佳答案

• You are upgrading your Cisco router IOS from a TFTP server over the network. The upgrade procedure is stopped and you are prompted to erase the current flash contents before continuing. What is most plausible reason for this? （）

  A . There is insufficient room for more than one image. B . The router has detected a copy of the current software image on the TFTP server. C . The file can be relocated and not compressed. D . The image to load is a binary executable file.

  查看最佳答案

• While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

  A . configure the database to run in ARCHIVELOG mode B . configure the Flash Recovery Area to enable automatic database backup C . schedule the database backup using DBMS_JOB package after creating the database D . schedule the database backup using Recovery Manager （RMAN）commands after creating the database E . schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

  查看最佳答案

• If you don’t use English from time to time, you can’t maintain your current English level, let alone upgrade your oral English to the upper level._______________

  查看最佳答案