单选题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？（）AThe data file cannot be recovered.BThe date file can be restored from the SYSTEM auto backup.CTake thetablespaceoffline，drop，kand re-create it.DRecovery Manager （RMAN） is used to recover the data file.EThe ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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.
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 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.
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.
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.
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
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.
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.
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.
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 tablespaceB、 password fileC、 online redo log filesD、 the current control fileE、 archived redo log filesF、 the current server parameter fileG、 data files belonging to the USERS tablespace and all the default tablespaces
单选题The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）AThe data file cannot be recovered.BThe date file can be restored from theSYSTEMauto backup.CTake thetablespaceoffline，drop，kand re-create it.DRecovery Manager （RMAN） is used to recover the data file.EThe ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
单选题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？（）AOnly bring the tablespace back online.BOnly recover the tablespace and then bring the tablespace back online.CShut down the database， recover the data file and then start up the database.DIssue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.ERecover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
单选题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？（）ARestore all the data files and open the databaseBCreate the data file and perform tablespace recoveryCNo need to restore any file， just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery
多选题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？ （）Aall the data files belonging to the USERS tablespaceBpassword fileConline redo log filesDthe current control fileEarchived redo log filesFthe current server parameter fileGdata files belonging to the USERS tablespace and all the default tablespaces
单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）AOnly the damaged or lost data files.BAll of the data files of the database.COnly the data files belonging to the SYSTEM tablespace.DThe data files belonging to the SYSTEM tablespace and the damaged or lost data files.
单选题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？（）Arecover using Oracle Flashback Database technologyBrestore the data files from backup and perform a complete recoveryCrestore only the corrupted data file and perform tablespace recoveryDrestore the data files from backup and perform cancelbased recoveryErestore the entire database from the most recent backup and start the instance and open the database
单选题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.
多选题Which two statements correctly describe the relation between a data file and the logical databasestructures（）AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data file can have only one segment created in it.EA data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.
多选题Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）AYou find that one of the redo log members in each redo log group is lost.BYou find that a data file that belongs to the USERS tablespace is damaged.CYou find that a data file that belongs to the SYSTEM tablespace is damaged.DYou find that the current redo log group is damaged and is not available for recovery.EYou realized while performing a recovery that an archived redo log file needed for recovery is lost.
单选题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？（）AOnly the data files.BAll of the data files and the control files.COnly the data files belonging to the SYSTEM tablespace.DOnly the data files belonging to the SYSTEM tablespace and the control files.
单选题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？（）ARestore the data file for the SYSTEM tablespace then open the database. BRestore all redo logs form last night's backup, then restart the database. CPerform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. DMount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
单选题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？（）Arestore all the data files from last Sunday’s backup， and then perform a timebased recoveryBrestore all the data files from last Sunday’s backup， and then perform a cancelbased recoveryCrestore all the data files from last Sunday’s backup， and then perform a changebased recoveryDrestore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery
单选题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？（）AThe data file cannot be recovered.BThe date file can be restored from the SYSTEM auto backup.CTake thetablespaceoffline，drop，kand re-create it.DRecovery Manager （RMAN） is used to recover the data file.EThe ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
单选题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？（）Aimp hr/hr TABLES=（ts_employees） rows=yBimp system/manager FROMUSER=hr file=expdat.dmpCimp hr/hr TRANSPORT_TABLESPACE=y file=expdat.dmpDimp system/manager TRANSPORT_TABLESPACE=y TABLESPACE=ts_employees
多选题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？ （）ARestore the lost data file from the backup， and then flash back the database.BRestore the data file pertaining to index tablespace， and then recover the tablespace.CRestore all the data files， and then perform an incomplete recovery to get the tablespace back.DRestore all the data files， and then perform an incomplete recovery using the backup control file.EDrop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
多选题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？（）AThe tablespace has two data files.BAn error is reported and tablespace creation fails.CData files are created with names generated by the instance.DThe tablespace can be extended without specifying the data file.EData files belonging to the USERS tablespace cannot be renamed.
多选题The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）ARestore the data file and perform incomplete recovery.BRestore the data file and perform point-in-time recover.CDrop the tablespace and lose all data in the tablespace.DRestore the database and lose all data since the last backup.
单选题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.