网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
What privileges must be granted to allow an account to create the recovery catalog？（）
- A、 RECOVERY_CATALOG_OWNER
- B、 DBA
- C、 RESOURCE
- D、 SELECT ANY DICTIONARY
- E、 CONNECT
参考答案
更多 “What privileges must be granted to allow an account to create the recovery catalog？（）A、 RECOVERY_CATALOG_OWNERB、 DBAC、 RESOURCED、 SELECT ANY DICTIONARYE、 CONNECT” 相关考题
考题
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.
考题
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 existsB. The recovery catalog is emptyC. The base recovery catalog must be droppedD. A target database is registered in the recovery catalog
考题
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?()
A. no privilegesB. only the SELECT privilegeC. only the CONNECT privilegeD. all the privileges of a default user
考题
You are granted the CREATE VIEW privilege. What does this allow you to do? ()
A. Create a table view.B. Create a view in any schema.C. Create a view in your schema.D. Create a sequence view in any schema.E. Create a view that is accessible by everyone.F. Create a view only of it is based on tables that you created.
考题
The DBA issues this SQL command:CREATE USER scottIDENTIFIES by tiger;What privileges does the user Scott have at this point? ()
A. No privileges.B. Only the SELECT privilege.C. Only the CONNECT privilege.D. All the privileges of a default user.
考题
Whatprivilegesmustbegrantedtoallowanaccounttocreatetherecoverycatalog?()
A.RECOVERY_CATALOG_OWNERB.DBAC.RESOURCED.SELECTANYDICTIONARYE.CONNECT
考题
Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?()
A.EXECUTE_CATALOG_ROLEB.CONNECTC.RESOURCED.RECOVERY_CATALOG_OWNERE.RECOVERY_CATALOG_USER
考题
The RVPC user can do which of the following？（）A、 Register databases if granted the register database privilegeB、 See all databases in the recovery-catalog schemaC、 See all database-related metadata in the recovery catalog if they are granted access to that databaseD、 Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant commandE、 Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes
考题
You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations. 2. Register the target database in the catalog. 3. Create the catalog using the RMAN command line interpreter. 4. Create a user and schema which will own the recovery catalog. 5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog. 6. Connect to the target database using SYSDBA privileges.A、4，1，5，6，3，2B、4，3，1，5，6，2C、4，5，1，3，2，6D、5，4，1，3，2，6E、5，4，1，3，6，2
考题
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 existsB、 The recovery catalog is emptyC、 The base recovery catalog must be droppedD、 A target database is registered in the recovery catalog
考题
What is the purpose of the catalog command？（） A、 To review RMAN control file and recovery catalog metadata and ensure that its correctB、 To delete RMAN backup-related metadata from the recovery catalogC、 To create metadata in the control file and the recovery catalog related to backup set pieces D、 To create a report that lists database backupsE、 To rebuild the recovery catalog
考题
What RMAN command must you use before you can back up a database using the recovery catalog？（）A、 create catalogB、 install databaseC、 catalog databaseD、 merge Catalog with databaseE、 register database
考题
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point?（）A、No privileges.B、Only the SELECT privilege.C、Only the CONNECT privilege.D、All the privileges of a default user.
考题
In what order would you execute the following steps to create a recovery catalog？（） a.Issue the create catalog command. b.Create the recovery-catalog database. c.Create the recovery-catalog user. d.Grant the recovery_catalog_owner privilege to the recovery-catalog user. e.Issue the register database command from the target database.A、a，b，c，d，eB、b，a，d，c，eC、b，c，d，a，eD、b，c，d，e，aE、b，d，c，a，e
考题
Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）A、The commands execute successfully.B、Command 6 produces an error because of circular role grant.C、Command 5 produces an error because a role cannot be granted to another role.D、Command 3 produces an error because the MGRROLE role already contains system privileges.E、The table created by HR remains and HR still has the CREATE TABLE system privilege.F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
You are granted the CREATE VIEW privilege. What does this allow you to do?（）A、Create a table view.B、Create a view in any schema.C、Create a view in your schema.D、Create a sequence view in any schema.E、Create a view that is accessible by everyone.F、Create a view only of it is based on tables that you created.
考题
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）A、no privilegesB、only the SELECT privilegeC、only the CONNECT privilegeD、all the privileges of a default user
考题
Which command do you use to create a recovery-catalog schema? （）A、create recovery catalog B、create catalogC、build catalog D、catalog create E、mount catalog
考题
You deploy Windows Server 2008 VPN server behind a firewall. Remote users connect to the VPN by using portable computers that run Windows Vista with the latest service pack. The firewall is configured to allow only secured web communications. You need to enable remote users to connect as securely as possible. you must achieve this goal without opening any additional ports on the firewall. What should you do （ ）？ A、Create an IPsec tunnelB、Create an SSTP VPN connectionC、Create a PPTP VPN connectionD、Create an L2TP VPN connection
考题
多选题What privileges must be granted to allow an account to create the recovery catalog？（）ARECOVERY_CATALOG_OWNERBDBACRESOURCEDSELECT ANY DICTIONARYECONNECT
考题
单选题What is the purpose of the catalog command？（）A
To review RMAN control file and recovery catalog metadata and ensure that its correctB
To delete RMAN backup-related metadata from the recovery catalogC
To create metadata in the control file and the recovery catalog related to backup set pieces D
To create a report that lists database backupsE
To rebuild the recovery catalog
考题
单选题What RMAN command must you use before you can back up a database using the recovery catalog？（）A
create catalogB
install databaseC
catalog databaseD
merge Catalog with databaseE
register database
考题
单选题You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations. 2. Register the target database in the catalog. 3. Create the catalog using the RMAN command line interpreter. 4. Create a user and schema which will own the recovery catalog. 5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog. 6. Connect to the target database using SYSDBA privileges.A
4，1，5，6，3，2B
4，3，1，5，6，2C
4，5，1，3，2，6D
5，4，1，3，2，6E
5，4，1，3，6，2
考题
单选题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 existsB
The recovery catalog is emptyC
The base recovery catalog must be droppedD
A target database is registered in the recovery catalog
考题
单选题The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）A
no privilegesB
only the SELECT privilegeC
only the CONNECT privilegeD
all the privileges of a default user
考题
单选题Which command do you use to create a recovery-catalog schema? （）A
create recovery catalog B
create catalogC
build catalog D
catalog create E
mount catalog
热门标签
最新试卷
