多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）ABackup 

题目
多选题
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）
A

Backup of offline tablespaces.

B

Backup of read-only tablespaces.

C

Backup of system-critical tablespaces.

D

Backup of online， locally managed tablespaces.

E

Backup of read/write dictionary-managed tablespaces.

相似考题

1.Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）A、The database is in mount state.B、One of the tablespaces is offline.C、One of the tablespaces is read only.D、The database operates in ARCHIEVELOG mode. E、The database operates in NOARCHIEVELOG mode.

2.Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）A、adding a new user to the databaseB、dropping a user from the databaseC、dropping a table from the databaseD、dropping a data file from a tablespaceE、adding a new tablespace to the database

3.you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）A、 TrueB、 False

4.For which database operation would you need the database to be in the MOUNT state（）A、renaming the control filesB、re-creating the control filesC、dropping a user in your databaseD、dropping a tablespace in your databaseE、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

更多“Your database is functioning in NOARCHIVELOG mode. Your data”相关问题

  • 第1题：

    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）

    • A、The instance aborts.
    • B、The database cannot be recovered.
    • C、The database can be recovered by restoring the control files from the backup.
    • D、The database remains opened and you have to shut it down with the ABORT option.
    • E、The database can be restored till the point of the last closed whole database backup.

    正确答案:A,E

  • 第2题：

    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

    • A、 backup database all
    • B、 backup compressed database
    • C、 backup as compressed backupset database
    • D、 backup as compressed backup database plus archivelog all
    • E、 backup as compressed backupset database plus compress archivelog all

    正确答案:C

  • 第3题：

    单选题
    Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）
    A

    You can perform open database backups.

    B

    You can perform closed database backups.

    C

    You cannot perform schema-level logical backups.

    D

    You can perform the backup of only the SYSTEM tablespace when the database is open.


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

  • 第4题：

    单选题
    Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）
    A

    until the last commit

    B

    cannot be recovered

    C

    until the last offline backup

    D

    until the beginning of the last transaction


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

  • 第5题：

    单选题
    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）
    A

     backup database all

    B

     backup compressed database

    C

     backup as compressed backupset database

    D

     backup as compressed backup database plus archivelog all

    E

     backup as compressed backupset database plus compress archivelog all


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

  • 第6题：

    单选题
    Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
    A

    You can perform online whole database backups.

    B

    You can performofflinewhole database backups.

    C

    You cannot perform schema-level export/import operations.

    D

    You can perform the backup of only the SYSTEM tablespace when the database is open.


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

  • 第7题：

    多选题
    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）
    A

    backup of offline tablespaces

    B

    backup of read­only tablespaces

    C

    backup of system­critical tablespaces

    D

    backup of online， locally managed tablespaces

    E

    backup of read/write dictionary­managed tablespaces


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

  • 第8题：

    单选题
    You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）
    A

    Only the data files.

    B

    All of the data files and the control files.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    Only the data files belonging to the SYSTEM tablespace and the control files.


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

  • 第9题：

    单选题
    Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）
    A

     Yes， if the database is in ARCHIVELOG mode

    B

     Yes， if the database is in NOARCHIVELOG mode

    C

     No， the backup is not usable in any way

    D

     Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE


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

  • 第10题：

    单选题
    Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
    A

    The database is in mount state.

    B

    One of the tablespaces is offline.

    C

    One of the tablespaces is read only.

    D

    The database operates in ARCHIEVELOG mode. 

    E

    The database operates in NOARCHIEVELOG mode.


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

  • 第11题：

    多选题
    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）
    A

    The instance aborts.

    B

    The database cannot be recovered.

    C

    The database can be recovered by restoring the control files from the backup.

    D

    The database remains opened and you have to shut it down with the ABORT option.

    E

    The database can be restored till the point of the last closed whole database backup.


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

  • 第12题：

    多选题
    The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）
    A

    Restore the data file and perform incomplete recovery.

    B

    Restore the data file and perform point-in-time recover.

    C

    Drop the tablespace and lose all data in the tablespace.

    D

    Restore the database and lose all data since the last backup.


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

  • 第13题：

    Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）  

    • A、 Yes， if the database is in ARCHIVELOG mode
    • B、 Yes， if the database is in NOARCHIVELOG mode
    • C、 No， the backup is not usable in any way
    • D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

    正确答案:C

  • 第14题：

    单选题
    For which database operation would you need the database to be in the MOUNT state（）
    A

    renaming the control files

    B

    re-creating the control files

    C

    dropping a user in your database

    D

    dropping a tablespace in your database

    E

    configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes


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

  • 第15题：

    多选题
    Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）
    A

    adding a new user to the database

    B

    dropping a user from the database

    C

    dropping a table from the database

    D

    dropping a data file from a tablespace

    E

    adding a new tablespace to the database


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

  • 第16题：

    单选题
    Assume your situation can be described as follows： x A full backup taken using RMAN is available on disk.  x The current control files were NOT damaged and do not need to be restored.  x All data files are damaged or lost.  x The database is in NOARCHIVELOG mode.  Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database？（） 1. RMAN> STARTUP MOUNT  2. RMAN> RESTORE DATABASE;  3. RMAN> （）  4. RMAN> ALTER DATABASE OPEN;
    A

    RECOVER DATABASE；

    B

    SWITCH DATAFILE ALL；

    C

    RESTORE CONTROL FILE；

    D

    RECOVER DATABASE USING BACKUP CONTROL FILE；


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

  • 第17题：

    多选题
    Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）
    A

    The destination must be global only.

    B

    A maximum of five destinations can be assigned.

    C

    A maximum of ten different destinations can be assigned.

    D

    All the destinations are determined by the server automatically.

    E

    The destination may be local or remote for a Standby Database.

    F

    The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.


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

  • 第18题：

    单选题
    ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）
    A

    Use the database link.

    B

    Use the SQL*Loader utility.

    C

    Use the Oracle Data Pump utility.

    D

    Create an external table and leave the data in the flat file


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

  • 第19题：

    单选题
    You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）
    A

    Use the database link.

    B

    Use the SQL*Loader utility.

    C

    Use the Oracle Data Pump utility.

    D

    Create an external table and leave the data in the flat file


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

  • 第20题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online


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

  • 第21题：

    单选题
    You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database.  What should you do？（）
    A

    Implement a stored procedure that writes data about schema changes to a log table.

    B

    Implement DDL AFTER triggers that write user and schema information to a log table.

    C

    Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.

    D

    Implement a DML AFTER trigger that writes data about schema changes to a log table.


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

  • 第22题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.


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

  • 第23题：

    单选题
    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and performtablespacerecovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


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

相关内容