多选题Which four actions are possible during an Online Data file Move operation?()ACreating and dropping tables in the data file being movedBPerforming file shrink of the data file being movedCQuerying tables in the data file being movedDPerforming Block Med

题目
多选题
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


相似考题
更多“多选题Which four actions are possible during an Online Data file Move operation?()ACreating and dropping tables in the data file being movedBPerforming file shrink of the data file being movedCQuerying tables in the data file being movedDPerforming Block Med”相关问题
  • 第1题:

    You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.

    You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.

    You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.

    What should you do?

    A.Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.

    B.Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.

    C.Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.

    D.Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.


    正确答案:D
    解析:Explanation:Asthecolumnsthatwewantinthetextfileareondifferenttablesinthedatabase,wewouldhavetocombinethecolumnintoatableorview.Becausewewillnotneedtoreproducethefile,wecanwecancombinethecolumnfromthevarioustablesintoaglobaltemporarytablebyusingtheSELECTINTOstatement.Thenweusethebcputilitytoexportthedatafromtheglobaltemporaryfiletoatextfile.Note:Temporarytablesarenotstoredinthecurrentdatabase;theyarestoredinthetempdbsystem.Therearetwotypesoftemporarytables:localtemporarytables,whicharevisibleonlytotheconnectionthatcreatedthem,andglobaltemporarytables,thatarevisibletoallconnections.Ifglobaltemporarytablesarenotdroppedexplicitlybeforetheconnectionthatcreatedthemdisconnects,theyaredroppedassoonasallothertasksstopreferencingthem.Nonewtaskscanreferenceaglobaltemporarytableaftertheconnectionthatcreateditdisconnects.ThebcputilitycopiesdatabetweenaninstanceofSQLServer2000andadatafileinauser-specifiedformat.ItcanbeusedtotransferdatafromaSQLServertabletoadatafileforuseinotherprograms.Furthermore,datacanalsobetransferredoutbyspecifyingaSELECTstatement.Thebcputilitycanuseglobaltemporarytables,butnotlocaltemporarytables.IncorrectAnswers:A:CreatingaglobaltemporarytablebyusingtheSELECTstatementandusingthebcputilitytoexportdatafromthattablewouldrequirelessadministrativeeffortthanusingbcptoexporttherequiredcolumnsfromeachtableintoaseparatetextfileandthenmergingthosetextfilesintoasingletextfile.B:Becausewewouldnotneedtore-createthedatafileagain,itwouldbeeasiertousetheSELECTstatementtocreateaglobaltemporarytableasthesetablesaredroppedautomaticallywhennothingreferencethem.C:Thebcputilitycannotuselocaltemporarytables.Note:Temporarytablesarenotstoredinthecurrentdatabase;theyarestoredinthetempdbsystem.Therearetwotypesoftemporarytables:localtemporarytables,whicharevisibleonlytotheconnectionthatcreatedthem,andglobaltemporarytables,thatarevisibletoallconnections.

  • 第2题:

    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

  • 第3题:

    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

  • 第4题:

    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

  • 第5题:

    For which two tasks would it be best NOT to use the utility SQL*Loader?()

    • A、When loading selected rows into each table.
    • B、When loading data from an export dump file.
    • C、When loading data from disk, tape, or named pipes.
    • D、When your data is NOT being inserted from a flat file.
    • E、When using a record management system to access data files.

    正确答案:B,D

  • 第6题:

    You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.()

    • A、 The data file backup is done with multiple channels
    • B、 The data files is in the read-write mode after being backed up in the read only mode
    • C、 The backup was taken after the data files was taken offline-normal or is in the read only mode
    • D、 The data file backup complies with the back retention policy and the backup duplexing fe ture

    正确答案:C,D

  • 第7题:

    The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()

    • A、until SCN
    • B、until time
    • C、until cancel
    • D、using backup control file

    正确答案:C

  • 第8题:

    单选题
    Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } 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


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

  • 第9题:

    多选题
    For which two tasks would it be best NOT to use the utility SQL*Loader?()
    A

    When loading selected rows into each table.

    B

    When loading data from an export dump file.

    C

    When loading data from disk, tape, or named pipes.

    D

    When your data is NOT being inserted from a flat file.

    E

    When using a record management system to access data files.


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

  • 第10题:

    多选题
    You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.() (Choose two.)
    A

    The data file backup is done with multiple channels

    B

    The data files is in the read-write mode after being backed up in the read only mode

    C

    The backup was taken after the data files was taken offline-normal or is in the read only mode

    D

    The data file backup complies with the back retention policy and the backup duplexing feature


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

  • 第11题:

    多选题
    Which two statements are true regarding the usage of the SQL*Loader utility()
    A

    You can load data into multiple tables during the same load session.

    B

    You can load data from multiple files to a table during the same load session.

    C

    You cannot perform selective data loading based on the values available in the records.

    D

    You can use an export file generated by the EXPDP utility as an input data file to load the data.

    E

    You can load data only if the input file is available on the disk and tape but not in a named pipes.


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

  • 第12题:

    多选题
    You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.()
    A

    The data file backup is done with multiple channels

    B

    The data files is in the read-write mode after being backed up in the read only mode

    C

    The backup was taken after the data files was taken offline-normal or is in the read only mode

    D

    The data file backup complies with the back retention policy and the backup duplexing fe ture


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

  • 第13题:

    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.

  • 第14题:

    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

  • 第15题:

    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

  • 第16题:

    Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } 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

  • 第17题:

    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

  • 第18题:

    Which two statements are true regarding the usage of the SQL*Loader utility()

    • A、You can load data into multiple tables during the same load session.
    • B、You can load data from multiple files to a table during the same load session.
    • C、You cannot perform selective data loading based on the values available in the records.
    • D、You can use an export file generated by the EXPDP utility as an input data file to load the data.
    • E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

    正确答案:A,B

  • 第19题:

    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

  • 第20题:

    多选题
    Which two activities are NOT supported by the Data Recovery Advisor?()
    A

    Diagnose and repair a data file corruption offline.

    B

    Diagnose and repair a data file corruption online.

    C

    Diagnose and repair failures on a standby database.

    D

    Recover from failures in the Real Application Cluster (RAC) environment.


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

  • 第21题:

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

  • 第22题:

    多选题
    Which two activities are NOT supported by the Data Recovery Advisor DRA()
    A

    Recover from failures in the RAC environment.

    B

    Diagnose and repair a data file corruption online.

    C

    Diagnose and repair a data file corruption offline.

    D

    Diagnose and repair failures on a standby database


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

  • 第23题:

    多选题
    Which two statements correctly describe the relation between a data file and the logical database structures()
    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


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