单选题Which of the following roles must be granted to a user to perform a full database import？（）A CONNECTB IMP_FULL_DATABASEC FULL_EXPORT_PRIVSD RESOURCEE FULL_IMPORT_PRIVS

题目
单选题
Which of the following roles must be granted to a user to perform a full database import？（）
A

CONNECT

B

IMP_FULL_DATABASE

C

FULL_EXPORT_PRIVS

D

RESOURCE

E

FULL_IMPORT_PRIVS

相似考题

1.You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE －5／24);Which two statements are true about this?()A. The database must have multiplexed redo log filesB. The database must be in the MOUNT state to execute the commandC. The database must be in the NOMOUNT state to execute the commandD. The database must be opened in RESTRICTED mode before this operationE. The database must be opened with the RESETLOGS option after the flashback operation

2.In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:Which two statements are true?()A. The C # # ROLE1 role is created in the root database and all the PDBs.B. The C # # ROLE1 role is created only in the root database because the container clause is not used.C. Privileges are granted to the C##A_ADMIN user only in the root database.D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.E. The statement for granting a role to a user fails because the CONTAINER clause is not used.

3.Examine the following impdp command to import a database over the network from a pre－12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?()A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.B. All the user-defined tablespaces must be in read-only mode on the source database.C. The export dump file must be created before starting the import on the target database.D. The source and target database must be running on the same platform with the same endianness.E. The path of data files on the target database must be the same as that on the source database.F. The impdp operation must be performed by the same user that performed the expdp operation.

4.Which two are prerequisites for performing a flashback transaction?()A. Flashback Database must be enabled.B. Undo retention guarantee for the database must be configured.C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.D. Supplemental logging must be enabled.E. Recycle bin must be enabled for the database.F. Block change tracking must be enabled tor the database.

参考答案和解析
正确答案： E
解析： 暂无解析
更多“单选题Which of the following roles must be granted to a user to perform a full database import？（）A CONNECTB IMP_FULL_DATABASEC FULL_EXPORT_PRIVSD RESOURCEE FULL_IMPORT_PRIVS”相关问题

  • 第1题：

    Whichofthefollowingrolesmustbegrantedtoausertoperformafulldatabaseimport?()

    A.CONNECT

    B.IMP_FULL_DATABASE

    C.FULL_EXPORT_PRIVS

    D.RESOURCE

    E.FULL_IMPORT_PRIVS


    参考答案：B

  • 第2题：

    Which two roles or privileges must you have to export tables owned by another user？（）

    • A、CREATE USER
    • B、CREATE SESSION
    • C、CREATE ANY TABLE
    • D、IMP_FULL_DATABASE
    • E、EXP_FULL_DATABASE

    正确答案:B,E

  • 第3题：

    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

  • 第4题：

    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

    • A、 The database must have multiplexed redo log files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第5题：

    To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）

    • A、OPEN
    • B、MOUNT
    • C、NOMOUNT
    • D、CLOSE

    正确答案:B

  • 第6题：

    Which two are prerequisites for performing a flashback transaction?（）

    • A、Flashback Database must be enabled.
    • B、Undo retention guarantee for the database must be configured.
    • C、EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
    • D、Supplemental logging must be enabled.
    • E、Recycle bin must be enabled for the database.
    • F、Block change tracking must be enabled tor the database.

    正确答案:B,C

  • 第7题：

    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

    • A、control file
    • B、password file
    • C、listener controller file
    • D、control file and password file

    正确答案:B

  • 第8题：

    单选题
    Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）
    A

    The user must be granted the database administrator （DBA） privilege.

    B

    The user must be listed in the password file for the authentication.

    C

    No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.

    D

    Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）
    A

     The database will open，and the tablespace automatically comes out of the backup mode.

    B

     The database will be mounted，and recovery must be performed on the USERS tablespace.

    C

     The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.

    D

     The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    多选题
    Which two statements are true about the roles in the Oracle database？（）
    A

    A role can be granted to itself.

    B

    Roles are owned by the SYS user.

    C

    Roles can be granted to other roles.

    D

    A role cannot be assigned external authentication.

    E

    A role can contain both system and object privileges.


    正确答案： E,D
    解析： 暂无解析

  • 第11题：

    多选题
    Which two are prerequisites for performing a flashback transaction?（）
    A

    Flashback Database must be enabled.

    B

    Undo retention guarantee for the database must be configured.

    C

    EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

    D

    Supplemental logging must be enabled.

    E

    Recycle bin must be enabled for the database.

    F

    Block change tracking must be enabled tor the database.


    正确答案： D,C
    解析： 暂无解析

  • 第12题：

    单选题
    To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）
    A

    OPEN

    B

    MOUNT

    C

    NOMOUNT

    D

    CLOSE


    正确答案： B
    解析： 暂无解析

  • 第13题：

    Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）

    • A、The user must be granted the database administrator （DBA） privilege.
    • B、The user must be listed in the password file for the authentication.
    • C、No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
    • D、Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.

    正确答案:D

  • 第14题：

    You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

    • A、You must have change tracking enabled in your database
    • B、Your database must be running in NOARCHIVELOG mode
    • C、To back up a tablespace, it must be in backup mode
    • D、To back up a tablespace, it must first be taken offline

    正确答案:C

  • 第15题：

    Which are the prerequisites for performing flashback transactions on your database？（）

    • A、 Undo retention guarantee for the database must be configured.
    • B、 Supplemental log must be enabled for the primary key.
    • C、 Supplemental log must be enabled.
    • D、 Execute permission on the DBMS_FLASHBACK package must be granted to the user.

    正确答案:B,C,D

  • 第16题：

    Which of the following roles must be granted to a user to perform a full database import？（）

    • A、CONNECT
    • B、IMP_FULL_DATABASE
    • C、FULL_EXPORT_PRIVS
    • D、RESOURCE
    • E、FULL_IMPORT_PRIVS

    正确答案:B

  • 第17题：

    You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.（）

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

    正确答案:C

  • 第18题：

    Which two statements are true about the roles in the Oracle database？（）

    • A、A role can be granted to itself.
    • B、Roles are owned by the SYS user.
    • C、Roles can be granted to other roles.
    • D、A role cannot be assigned external authentication.
    • E、A role can contain both system and object privileges.

    正确答案:C,E

  • 第19题：

    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

    • A、The database will open, and the tablespace automatically comes out of the backup mode
    • B、The database will be mounted, and recovery must be performed on the USERS tablespace.
    • C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
    • D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

    正确答案:C

  • 第20题：

    单选题
    You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.（）
    A

    2，1，3，4，5，6

    B

    1，3，4，5，6，7

    C

    1，4，3，5，6，7

    D

    2，1，3，4，5，6，7

    E

    1，5，6，4，3，2


    正确答案： E
    解析： 暂无解析

  • 第21题：

    单选题
    You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）
    A

    You must have change tracking enabled in your database

    B

    Your database must be running in NOARCHIVELOG mode

    C

    To back up a tablespace, it must be in backup mode

    D

    To back up a tablespace, it must first be taken offline


    正确答案： A
    解析： 暂无解析

  • 第22题：

    多选题
    Which two roles or privileges must you have to export tables owned by another user？（）
    A

    CREATE USER

    B

    CREATE SESSION

    C

    CREATE ANY TABLE

    D

    IMP_FULL_DATABASE

    E

    EXP_FULL_DATABASE


    正确答案： C,A
    解析： 暂无解析

  • 第23题：

    单选题
    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）
    A

    control file

    B

    password file

    C

    listener controller file

    D

    control file and password file


    正确答案： B
    解析： 暂无解析

相关内容