多选题Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）AThe C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.BThe C # # C_ADMIN us

题目
多选题
Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）
A

The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.

B

The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

C

The C # # A_ADMIN user can perform wallet operations.

D

The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

E

The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

相似考题

1.You executed the following command in the Recovery Manager (RMAN):RMAN> REPORT NEED BACKUP days 3;What is the output of this command?()A. A list of files that require a backup within 3 daysB. A list of files requiring more than 3 days of archivelogs to applyC. A list of files that RMAN recommends be backed up only once in every three days, based on low volatilityD. A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

2.Which of the following statements is NOT true about RMAN？（）A、It improves usability by enabling you to reuse the scripts to perform recovery operations.B、It detects block corruption while restoration and recovery operations.C、It enables you to perform block media recovery.D、It is capable to recover through unrecoverable operations， with only full database backups.

3. 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.

4.You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN).To accomplish the backup, you issued the following RMAN command:RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;Which two statements are true about the execution of the above command? （）(Choose two.)A. The backup piece size will be limited to 300 MBB. The RMAN uses multiplexing to perform backupC. The operation is accomplished using the default channel availableD. The RMAN parallelizes the backup although the parallelism is not set for a channel

更多“多选题Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）AThe C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.BThe C # # C_ADMIN us”相关问题

  • 第1题：

    All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.  SQL> DELETE FROM persons WHERE exp=’Y’； 3 rows deleted.  The SYS user opens a new session after HR executed the above commands.  Which sessions can seethe effect of the UPDATE and DELETE commands （）

    • A、all sessions of the HR user only
    • B、all sessions of the HR user and the SYS user
    • C、the session of the HR user that executed the commands
    • D、all the sessions for which the database users have access privilege to the PERSONS table

    正确答案:C

  • 第2题：

    You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)

    • A、The backup piece size will be limited to 300 MB
    • B、The RMAN uses multiplexing to perform backup
    • C、The operation is accomplished using the default channel available
    • D、The RMAN parallelizes the backup although the parallelism is not set for a channel

    正确答案:A,C

  • 第3题：

    Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

    • A、The SKD user cannot log in to the database instance.
    • B、The objects owned by the SKD user are not accessible to any user.
    • C、The other users can access the objects owned by the SKD user， on which they have access.
    • D、The password for the SKD user expires and the user is forced to change the password at the next log in

    正确答案:A,C

  • 第4题：

    You executed the following command in the Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）  

    • A、 A list of files that require a backup within 3 days
    • B、 A list of files requiring more than 3 days of archivelogs to apply
    • C、 A list of files that RMAN recommends be backed up only once in every three days，based on low volatility
    • D、 A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

    正确答案:B

  • 第5题：

    You executed the following command in Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）  

    • A、 a list of files that require a backup within three days
    • B、 a list of files requiring more than 3 days of archive logs to apply
    • C、 a list of files that RMAN recommends be backed up only once in every three days，based on low volatility
    • D、 a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

    正确答案:A

  • 第6题：

    You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：  RMAN> REPORT NEED BACKUP days 3;  What would be the output of this command？（） 

    • A、a list of files that require a backup within three days
    • B、a list of files that have not been backed up for three days
    • C、a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
    • D、a list of files for which a backup has already been performed and may need a backup after three days

    正确答案:B

  • 第7题：

    多选题
    Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’；   Which two statements are true regarding the backup created using this command？（）
    A

    The copy of the datafile created is stored in the RMAN repository.

    B

    The copy of the datafile created can be viewed using the LIST BACKUP command.

    C

    The copy of the datafile created using this COPY command can be placed only on the disk.

    D

    The copy of the datafile created is similar to the backup of the file created using the BACKUP command.

    E

    The copy of the datafile created can be used for recovering the database using the user-managed recovery method.


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

  • 第8题：

    单选题
    Which of the following statements is NOT true about RMAN？（）
    A

    It improves usability by enabling you to reuse the scripts to perform recovery operations.

    B

    It detects block corruption while restoration and recovery operations.

    C

    It enables you to perform block media recovery.

    D

    It is capable to recover through unrecoverable operations， with only full database backups.


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

  • 第9题：

    多选题
    You issue this RMAN command：   RMAN> create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   （database include current controlfile）；   sql ‘alter database archive log current’；   }  Which three statements are true about the Level0Backup script you just created？（）
    A

    The script is stored only in the control file.

    B

    The script is stored only in the recover catalog.

    C

    The script can be executed only by using the RMAN RUN command.

    D

    The commands of the script can be displayed with the LIST command.

    E

    The commands of the script can be displayed with the PRINT command.

    F

    The commands of the script can be displayed with the REPORT command.


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

  • 第10题：

    多选题
    Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）
    A

    System privileges apply only to the PDB in which they are used.

    B

    Local users cannot use local system privileges on the schema of a common user.

    C

    The granter of system privileges must possess the set container privilege.

    D

    Common users connected to a PDB can exercise privileges across other PDBs.

    E

    System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.


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

  • 第11题：

    多选题
    You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation？（）
    A

    The backup as copy can only be taken to disk

    B

    The backup as copy can only be taken to tape

    C

    Backup can be performed only when the instance is shutdown

    D

    Backup will constitute all used and unused blocks in the database


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

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands.  Which sessions can see theeffect of the UPDATE and DELETE commands（）

    • A、All sessions of the HR user only
    • B、All sessions of the HR user and the SYS user
    • C、The session of the HR user that executed the commands
    • D、All the sessions for which the database users have access privilege to the PERSONS table

    正确答案:C

  • 第14题：

    Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATECHANNEL commands in RMAN（） (choose all that apply)

    • A、Limiting the input/output (I/O) bandwidth consumption
    • B、Specifying the size of backup sets and backup pieces
    • C、Specifying vendor-specific information for a media manager
    • D、Specifying the parallelism for backup and restore operations

    正确答案:A,C

  • 第15题：

    Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

    • A、The SKD user cannot log in to the database instance.
    • B、The objects owned by the SKD user are not accessible to any user.
    • C、The other users can access the objects owned by the SKD user， on which they have access.
    • D、The password for the SKD user expires and the user is forced to change the password at the next log in.

    正确答案:A,C

  • 第16题：

    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

    • A、shut down and restart the instance
    • B、add new tempfiles to the temporary tablespaces after recovery
    • C、perform a media recovery and open the database with the RESETLOGS option
    • D、perform a media recovery and bring the database to NOARCHIVELOG mode

    正确答案:B,C

  • 第17题：

    Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）

    • A、The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
    • B、The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
    • C、The C # # A_ADMIN user can perform wallet operations.
    • D、The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
    • E、The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

    正确答案:B,D,E

  • 第18题：

    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

  • 第19题：

    多选题
    Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
    A

    The SKD user cannot log in to the database instance.

    B

    The objects owned by the SKD user are not accessible to any user.

    C

    The other users can access the objects owned by the SKD user， on which they have access.

    D

    The password for the SKD user expires and the user is forced to change the password at the next log in


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

  • 第20题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）
    A

     a list of files that require a backup within three days

    B

     a list of files requiring more than 3 days of archive logs to apply

    C

     a list of files that RMAN recommends be backed up only once in every three days，based on low volatility

    D

     a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them


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

  • 第21题：

    多选题
    Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）
    A

    The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.

    B

    The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

    C

    The C # # A_ADMIN user can perform wallet operations.

    D

    The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

    E

    The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.


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

  • 第22题：

    多选题
    Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
    A

    The SKD user cannot log in to the database instance.

    B

    The objects owned by the SKD user are not accessible to any user.

    C

    The other users can access the objects owned by the SKD user， on which they have access.

    D

    The password for the SKD user expires and the user is forced to change the password at the next log in.


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

  • 第23题：

    多选题
    You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)
    A

    The backup piece size will be limited to 300 MB

    B

    The RMAN uses multiplexing to perform backup

    C

    The operation is accomplished using the default channel available

    D

    The RMAN parallelizes the backup although the parallelism is not set for a channel


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

  • 第24题：

    多选题
    Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATECHANNEL commands in RMAN（） (choose all that apply)
    A

    Limiting the input/output (I/O) bandwidth consumption

    B

    Specifying the size of backup sets and backup pieces

    C

    Specifying vendor-specific information for a media manager

    D

    Specifying the parallelism for backup and restore operations


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

相关内容