What privileges must be granted to allow an account to create the recovery catalog?()A、 RECOVERY_CATALOG_OWNERB、 DBAC、 RESOURCED、 SELECT ANY DICTIONARYE、 CONNECT

题目

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
参考答案和解析
正确答案:A,C
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

The DBA issues this SQL command: CREATE USER scott IDENTIFIED 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


参考答案:A

第2题:

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.


参考答案:A

第3题:

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.


参考答案:A

第4题:

下列()不是一个角色。

  • A、CONNECT
  • B、DBA
  • C、RESOURCE
  • D、CREATE SESSION

正确答案:D

第5题:

Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?()

A.EXECUTE_CATALOG_ROLE

B.CONNECT

C.RESOURCE

D.RECOVERY_CATALOG_OWNER

E.RECOVERY_CATALOG_USER


参考答案:D

第6题:

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.


参考答案:C

第7题:

Whatprivilegesmustbegrantedtoallowanaccounttocreatetherecoverycatalog?()

A.RECOVERY_CATALOG_OWNER

B.DBA

C.RESOURCE

D.SELECTANYDICTIONARY

E.CONNECT


参考答案:A, C

第8题:

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


参考答案:A

第9题:

The RVPC user can do which of the following?()

  • A、 Register databases if granted the register database privilege
  • B、 See all databases in the recovery-catalog schema
  • C、 See all database-related metadata in the recovery catalog if they are granted access to that database
  • D、 Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with  the grant command
  • E、 Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

正确答案:A,C

第10题:

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,2
  • B、4,3,1,5,6,2
  • C、4,5,1,3,2,6
  • D、5,4,1,3,2,6
  • E、5,4,1,3,6,2

正确答案:E

更多相关问题