多选题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?（）

Creating and dropping tables in the data file being moved

Performing file shrink of the data file being moved

Querying tables in the data file being moved

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

Flashing back the database

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

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 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：

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 channelsB. The data files is in the read-write mode after being backed up in the read only modeC. The backup was taken after the data files was taken offline-normal or is in the read only modeD. The data file backup complies with the back retention policy and the backup duplexing feature

点击查看答案
相关问题 3：

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 channelsB. The data files is in the read-write mode after being backed up in the read only modeC. The backup was taken after the data files was taken offline-normal or is in the read only modeD. The data file backup complies with the back retention policy and the backup duplexing feature

点击查看答案
相关问题 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

点击查看答案
相关问题 5：

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.

点击查看答案
相关问题 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.

点击查看答案
相关问题 7：

Which file characteristic cannot be used in the Cisco IronPort Data Security policies？（） A、 file typeB、 file sizeC、 file ageD、 file name

点击查看答案

1Z0-060

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

相关问题 2：

相关问题 3：

相关问题 4：

相关问题 5：

相关问题 6：

相关问题 7：

相关内容