单选题Which statement is true regarding virtual private catalogs？（）AA virtual private catalog owner can create a local stored script， and have read/write access to a global stored script.BThe virtual private catalog owner cannot create and modify the stored 

第1题：

A trigger can be created on which of the following objects?（）

• A、View
• B、Catalog Table
• C、Stored Procedure
• D、Global Temporary Table

第2题：

S9300支持的VPN类型有（）

• A、VPDN（Virtual Private Dial Network）
• B、VPRN（Virtual Private Routing Network）
• C、VLL（Virtual Leased Line）
• D、VPLS（Virtual Private LAN Service）

第3题：

Which statement is false about sales catalogs？（）

• A、Sales catalogs are used for customer display purposes.
• B、With a sales catalog products can be placed in many locations.
• C、If sales catalogs are used then it is not necessary to have a master catalog.
• D、Sales catalogs can be used to target specific customer segments.
• E、Sales catalogs can be used to control what products a customer can see.

第4题：

Which statement is true regarding virtual private catalogs?（）

• A、A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
• B、The virtual private catalog owner cannot create and modify the stored scripts.
• C、The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
• D、To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

第5题：

Which two statements regarding a SQL profile are true？（）

• A、 It is built by Automatic Tuning Optimizer.
• B、 It cannot be stored persistently in the data dictionary.
• C、 It can be used by the query optimizer automatically.
• D、 It can be created manually by using the CREATE PROFILE command.

第6题：

The following databases are registered in the base recovery catalog： PROD1， PROD2， and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this：   1.SQL> GRANT recovery_catalog_owner TO vpc1； 2.RMAN> CONNECT CATALOG vpc1/password@catdb；  3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1； 4.RMAN> CONNECT CATALOG catowner/password@catdb；  5.RMAN> CREATE VIRTUAL CATALOG；   What is the correct sequence in which the commands have to be executed？（）  

• A、 1，4，5，2，3
• B、 1，4，3，2，5
• C、 4，5，2，3，1
• D、 2，3，4，5，1
• E、 1，4，2，3，5

第7题：

Which statement about using RMAN stored scripts is true？（）  

• A、 To create and execute an RMAN stored script，you must use a recovery catalog.
• B、 When executing a stored script and a command fails，the remainder of the script is executed，and a message is written to the alert log file.
• C、 RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
• D、 When you execute a stored script，it always executes using the persistent channel settings previously set with the CONFIGURE command.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

In a JSP-centric web application， you need to create a catalog browsing JSP page. The catalog is stored asa List object in the catalog attribute of the webapp’s ServletContext object.  Which scriptlet code snippetgives you access to the catalog object？（）

• A、<% List catalog = config.getAttribute（"catalog"）； %>
• B、<% List catalog = context.getAttribute（"catalog"）； %>
• C、<% List catalog = application.getAttribute（"catalog"）； %>
• D、<% List catalog = servletContext.getAttribute（"catalog"）； %>

第14题：

VPN技术全称（）。

• A、VIRTUAL PRIVATE NARATOR
• B、VIRTUAL PRIVATE NETWORK
• C、VIRTUAL PRESENT NETWORK
• D、VIRTUAL PRIVATE NET

第15题：

Which statement is true regarding RMAN components？（）

• A、Each target database requires its own recover catalog. 
• B、RMAN scripts can be stored in the recovery catalog or the target control file. 
• C、A channel is a stream of data to a device type and corresponds to one server session. 
• D、The RMAN executable interprets sever session commands and establishes connections to the target database.

第16题：

You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository.  Which condition must be met before you create the VPC？（）  

• A、 A base catalog exists
• B、 The recovery catalog is empty
• C、 The base recovery catalog must be dropped
• D、 A target database is registered in the recovery catalog

第17题：

RMAN provides more granular catalog security through which feature？（）

• A、 Virtual private database
• B、 Virtual private catalog
• C、 RMAN virtual database
• D、 RMAN secure catalog
• E、 Oracle Database Vault

第18题：

Which statement is true regarding virtual private catalogs? （）

• A、A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script. 
• B、The virtual private catalog owner cannot create and modify the stored scripts. 
• C、The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner. 
• D、To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database. 

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：