itgle.com

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、flash back all the tables in the data file， one by oneB、

题目

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  • A、flash back all the tables in the data file， one by one
  • B、restore the data file to a new location and perform a media recovery
  • C、flash back the database; there is no need to restore the data file
  • D、restore the data file from the most recent backup and flash back the database
相似考题

1.Examine the following RMAN script:Which statement describes the purpose of the script?()A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

2.A data( )is a file that contains metadata—that is，data about data.A．structureB．tableC．baseD．dictionary

3.You are the administrator of a SQL Server 2000 computer. The server contains a database named Acct. You purge the Acct database of old records and perform. a full backup. The database now uses 4 GB of space. The database files are configured as shown in the Acct Properties exhibit.The server has two hard disks that are configured as shown in the Server Configuration exhibit.The 3 GB transaction log file for the Acct database is stored on drive C. You need to make room for a new database that has a 3 GB data file and a 1 GB transaction log file. You want to optimize database performance on both databases. You also want to minimize administrative overhead.What should you do?A．Shrink the empty data file on drive E. Place the new data file and the new log file on drive E.B．Shrink the empty data file on drive E. Backup and shrink the log file on drive C to 2 GB. Place the new data file on drive E and the new log file on drive C.C．Shrink the data file on drive D to 1 GB, and then shrink the data file on drive E to 2 GB. Place the new data file on drive D and the new log file on drive E.D．Shrink and delete the data file on drive C, and then shrink the database files on drives D and E so that they are both 2 GB. Place the new data file and the new log file on drive C.

4.Which four actions are possible during an Online Data file Move operation?()A. Creating and dropping tables in the data file being movedB. Performing file shrink of the data file being movedC. Querying tables in the data file being movedD. Performing Block Media Recovery for a data block in the data file being movedE. Flashing back the databaseF. Executing DML statements on objects stored in the data file being moved

参考答案和解析
正确答案:B
更多“A data file beca”相关问题

  • 第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.


    参考答案：C

  • 第2题：

    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.

    正确答案:A,C

  • 第3题：

    A system administrator has an existing mksysb image, but would like to modify the image.data file on the mksysb before installing it on a system. Which of the following procedures is most appropriate to perform?（）

    • A、Create a new image.data file and recreate the mksysb image.
    • B、Use the dd command to replace the image.data file on the mksysb tape.
    • C、Use the tctl command to palce the new image.data file on the mksysb tape.
    • D、Place the new image.data file on a diskette that will be road during the installation of the mksysb.

    正确答案:D

  • 第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.

    正确答案:A

  • 第5题：

    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

  • 第6题：

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

  • 第7题：

    单选题
    You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）
    A

    The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.

    B

    The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.

    C

    The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.

    D

    The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.


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

  • 第8题：

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

  • 第9题：

    单选题
    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）
    A

     Flash back all the tables in the data file， one by one.

    B

     Restore the data file to a new location and perform a media recovery.

    C

     Flash back the database， there is no need to restore the data file.

    D

     Restore the data file from the most recent backup and flash the database.


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

  • 第10题：

    单选题
    You issue this SQL statement：  ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’；  What does this SQL statement do？（）
    A

    It updates the control file with the new location of the data file. 

    B

    It updates only the data dictionary with the new location of the data file. 

    C

    It changes the location of the user_data01.dbf file in the operating system. 

    D

    It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.


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

  • 第11题：

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

  • 第12题：

    单选题
    Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA  ADD ALIAS ’+tdgroupA/data/datafile.dbf’  FOR ’+tdgroupA.231.45678’；  Which task would be accomplished by the command？（）
    A

    The command drops the file +tdgroupA·231.45678.

    B

    The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.

    C

    The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.

    D

    The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.

    E

    The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.


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

  • 第13题：

    Which file characteristic cannot be used in the Cisco IronPort Data Security policies？（） 

    • A、 file type
    • B、 file size
    • C、 file age
    • D、 file  name

    正确答案:C

  • 第14题：

    Which four actions are possible during an Online Data file Move operation?（）

    • A、Creating and dropping tables in the data file being moved
    • B、Performing file shrink of the data file being moved
    • C、Querying tables in the data file being moved
    • D、Performing Block Media Recovery for a data block in the data file being moved
    • E、Flashing back the database
    • F、Executing DML statements on objects stored in the data file being moved

    正确答案:A,C,D,F

  • 第15题：

    Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA  ADD ALIAS ’+tdgroupA/data/datafile.dbf’  FOR ’+tdgroupA.231.45678’；  Which task would be accomplished by the command？（）

    • A、The command drops the file +tdgroupA·231.45678.
    • B、The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
    • C、The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
    • D、The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
    • E、The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.

    正确答案:D

  • 第16题：

    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

    • A、 Flash back all the tables in the data file， one by one.
    • B、 Restore the data file to a new location and perform a media recovery.
    • C、 Flash back the database， there is no need to restore the data file.
    • D、 Restore the data file from the most recent backup and flash the database.

    正确答案:B

  • 第17题：

    单选题
    Which statements are true， given the code new FileOutputStream（"data"， true） for creating an object of class FileOutputStream？（）
    A

    FileOutputStream has no constructors matching the given arguments.

    B

    An IOExeception will be thrown if a file named data already exists.

    C

    An IOExeception will be thrown if a file named data does not already exist.

    D

    If a file named data exists， its contents will be reset and overwritten.

    E

    If a file named data exists， output will be appended to its current contents.


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

  • 第18题：

    单选题
    Your network contains a file server that runs Windows Server 2008 R2. The server has File Server Resource Manager (FSRM) installed.A file screen is created for a folder named Data. Data is located on the C drive. The file screen is configured to block files contained in the Audio and Video file group.You need to allow users in the sales department to upload video files to C:/Data/Sales. What should you do?（）
    A

    Create a file screen exception.

    B

    Modify the Audio and Video file group.

    C

    Implement an active file screen on C:/Data/Sales.

    D

    Implement a passive file screen on C:/Data/Sales.


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

  • 第19题：

    多选题
    Which four actions are possible during an Online Data file Move operation?（）
    A

    Creating and dropping tables in the data file being moved

    B

    Performing file shrink of the data file being moved

    C

    Querying tables in the data file being moved

    D

    Performing Block Media Recovery for a data block in the data file being moved

    E

    Flashing back the database

    F

    Executing DML statements on objects stored in the data file being moved


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

  • 第20题：

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

  • 第21题：

    单选题
    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.


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

  • 第22题：

    单选题
    Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）
    A

    Rebuild the index using the online option. 

    B

    Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 

    C

    Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 

    D

    Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.


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

  • 第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
    解析： 暂无解析

相关内容