单选题The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）A The data file cannot be recovered.B The date file can be restored from the SYSTEM auto backup.C Take thetablespac

题目
单选题
The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）
A

The data file cannot be recovered.

B

The date file can be restored from the SYSTEM auto backup.

C

Take thetablespaceoffline，drop，kand re-create it.

D

Recovery Manager （RMAN） is used to recover the data file.

E

The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

相似考题

1.Which of the following statements is TRUE about mounting a file system?()A.A file system cannot be mounted on a directory containing data.B.Mounting a file system on a mount point containing data will delete the data.C.Mounting a file system on a amount point containing data will make the data temporarily inaccessible.D.A systems administrator must manually create an empty directory prior to mounting an AIX JFS.

2. The user HR receives the following error while inserting data into the TTK table： ERROR at line 1：  ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation， you find that SMD is a small file tablespace.  Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

3.The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）A、The data file cannot be recovered.B、The date file can be restored from theSYSTEMauto backup.C、Take thetablespaceoffline，drop，kand re-create it.D、Recovery Manager （RMAN） is used to recover the data file.E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

4.Which two statements correctly describe the relation between a data file and the logical databasestructures（）A、An extent cannot spread across data files.B、A segment cannot spread across data files.C、A data file can belong to only one tablespace.D、A data file can have only one segment created in it.E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.

更多“The data file belonging to the SYSTEM tablespace is corrupte”相关问题

  • 第1题：

    When performing an incomplete recover of the whole database， which data files must you restore？ （）

    • A、Only the damaged or lost data files.
    • B、All of the data files of the database.
    • C、Only the data files belonging to the SYSTEM tablespace.
    • D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

    正确答案:B

  • 第2题：

    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

    • A、The tablespace has two data files.
    • B、An error is reported and tablespace creation fails.
    • C、Data files are created with names generated by the instance.
    • D、The tablespace can be extended without specifying the data file.
    • E、Data files belonging to the USERS tablespace cannot be renamed.

    正确答案:C,D

  • 第3题：

    The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）

    • A、 The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
    • B、 The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
    • C、 The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.
    • D、 The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.
    • E、 The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent.

    正确答案:A

  • 第4题：

    单选题
    The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）
    A

    The data file cannot be recovered.

    B

    The date file can be restored from theSYSTEMauto backup.

    C

    Take thetablespaceoffline，drop，kand re-create it.

    D

    Recovery Manager （RMAN） is used to recover the data file.

    E

    The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.


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

  • 第5题：

    单选题
    You work as a database administrator for Supportcenter.cn. 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 perform tablespace recovery

    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


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

  • 第6题：

    单选题
    When performing an incomplete recover of the whole database， which data files must you restore？ （）
    A

    Only the damaged or lost data files.

    B

    All of the data files of the database.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    The data files belonging to the SYSTEM tablespace and the damaged or lost data files.


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

  • 第7题：

    单选题
    You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）
    A

     Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.

    B

     Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.

    C

     Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.

    D

     Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.


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

  • 第8题：

    多选题
    Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）
    A

    You find that one of the redo log members in each redo log group is lost.

    B

    You find that a data file that belongs to the USERS tablespace is damaged.

    C

    You find that a data file that belongs to the SYSTEM tablespace is damaged.

    D

    You find that the current redo log group is damaged and is not available for recovery.

    E

    You realized while performing a recovery that an archived redo log file needed for recovery is lost.


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

  • 第9题：

    单选题
    Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）
    A

    Restore the data file for the SYSTEM tablespace then open the database. 

    B

    Restore all redo logs form last night's backup, then restart the database. 

    C

    Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. 

    D

    Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online. 


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

  • 第10题：

    单选题
    You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct？（）
    A

    imp hr/hr TABLES=（ts_employees） rows=y

    B

    imp system/manager FROMUSER=hr file=expdat.dmp

    C

    imp hr/hr TRANSPORT_TABLESPACE=y file=expdat.dmp

    D

    imp system/manager TRANSPORT_TABLESPACE=y TABLESPACE=ts_employees


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

  • 第11题：

    多选题
    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）
    A

    The tablespace has two data files.

    B

    An error is reported and tablespace creation fails.

    C

    Data files are created with names generated by the instance.

    D

    The tablespace can be extended without specifying the data file.

    E

    Data files belonging to the USERS tablespace cannot be renamed.


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

  • 第12题：

    单选题
    The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）
    A

     The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.

    B

     The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

    C

     The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.

    D

     The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.

    E

     The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent.


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

  • 第13题：

    The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）

    • A、Add a data file to the SMD tablespace.
    • B、Add a data file to the temporary tablespace associated with the user HR.
    • C、Resize the data file associated with the SMD tablespace to make it larger.
    • D、Alter the data file associated with the SMD tablespace to grow automatically.
    • E、Change the segment space management for the SMD tablespace to automatic

    正确答案:A,C,D

  • 第14题：

    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

    • A、Only bring the tablespace back online.
    • B、Only recover the tablespace and then bring the tablespace back online.
    • C、Shut down the database， recover the data file and then start up the database.
    • D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
    • E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

    正确答案:D

  • 第15题：

    View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

    • A、 all the data files belonging to the USERS tablespace
    • B、 password file
    • C、 online redo log files
    • D、 the current control file
    • E、 archived redo log files
    • F、 the current server parameter file
    • G、 data files belonging to the USERS tablespace and all the default tablespaces

    正确答案:A,D,F

  • 第16题：

    单选题
    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）
    A

    Only bring the tablespace back online.

    B

    Only recover the tablespace and then bring the tablespace back online.

    C

    Shut down the database， recover the data file and then start up the database.

    D

    Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.

    E

    Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.


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

  • 第17题：

    多选题
    View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）
    A

    all the data files belonging to the USERS tablespace

    B

    password file

    C

    online redo log files

    D

    the current control file

    E

    archived redo log files

    F

    the current server parameter file

    G

    data files belonging to the USERS tablespace and all the default tablespaces


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

  • 第18题：

    单选题
    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）
    A

    recover using Oracle Flashback Database technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel­based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


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

  • 第19题：

    多选题
    Which two statements correctly describe the relation between a data file and the logical databasestructures（）
    A

    An extent cannot spread across data files.

    B

    A segment cannot spread across data files.

    C

    A data file can belong to only one tablespace.

    D

    A data file can have only one segment created in it.

    E

    A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.


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

  • 第20题：

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

  • 第21题：

    单选题
    Your database operates in ARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8：30 a.m. With reference to this scenario， what would you do to recover the database？（）
    A

    restore all the data files from last Sunday’s backup， and then perform a time­based recovery

    B

    restore all the data files from last Sunday’s backup， and then perform a cancel­based recovery

    C

    restore all the data files from last Sunday’s backup， and then perform a change­based recovery

    D

    restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery


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

  • 第22题：

    多选题
    You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）
    A

    Restore the lost data file from the backup， and then flash back the database.

    B

    Restore the data file pertaining to index tablespace， and then recover the tablespace.

    C

    Restore all the data files， and then perform an incomplete recovery to get the tablespace back.

    D

    Restore all the data files， and then perform an incomplete recovery using the backup control file.

    E

    Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.


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

  • 第23题：

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

相关内容