违法和不良信息举报 联系客服
免费注册 登录

A data file be

题目

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.
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

A data( )is a file that contains metadata—that is，data about data.

A．structure

B．table

C．base

D．dictionary


正确答案：D
解析：数据字典就是包含元数据的文件，即关于数据的数据。

第2题：

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

第3题：

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


参考答案：D

第4题：

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

第5题：

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

第6题：

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.


正确答案：B
解析：Explanation: We must add a new 3GB database with a 1GB transaction log file. Currently we have database that is using 4GB for data and 3GB for the log file. We should place the log file and the data file on two different physical disks out of performance reasons.

The command DBCC SHRINKFILE with the EMPTYFILE option can be used to shrink a datafile to empty. The data will be migrated to the other files in the filegroup. We use this method to free 4.5 GB on Drive E. Then we backup the log file on C and reduce it to 2GB. Then we put the database data file on drive (3GB) and put the log file of the new database on drive C (1GB).

Incorrect answers:
A: It’s better to put the data file and the log file of the new database on two different physical disks out of performance reasons.

C: It’s better to put the data file and the log file of the new database on two different physical disks out of performance reasons.

D: It’s better to put the data file and the log file of the new database on two different physical disks out of performance reasons.

第7题：

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

第8题：

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

第9题：

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

正确答案:B

第10题：

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

更多相关问题
相关内容