单选题You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）A Use the DROP DATAFILE command.B Use the DROP TABLESPACE command.C Ensu

题目
单选题
You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）
A

Use the DROP DATAFILE command.

B

Use the DROP TABLESPACE command.

C

Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.

D

Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.

相似考题

1.You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?A．Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.B．Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.C．Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.D．Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

2.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.

3.You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace

4.You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.The destination table is configured as shown in the exhibit.You want to load the data into the table as quickly as possible. What should you do?A．Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.B．Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.C．Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.D．Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.

更多“单选题You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）A Use the DROP DATAFILE command.B Use the DROP TABLESPACE command.C Ensu”相关问题

  • 第1题：

    You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）

    • A、flash back the database
    • B、import the temporary tablespace from the last export
    • C、restore all the data files and temporary files from the last full database backup and perform a recovery
    • D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

    正确答案:D

  • 第2题：

    You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

    • A、 SQL scripts
    • B、 Recovery Manager （RMAN） script
    • C、 Data Pump
    • D、 SQL*Loader
    • E、 Flashback database

    正确答案:A,C

  • 第3题：

    One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）

    • A、drop and re­create the read­only tablespaces
    • B、rename the read­only data files to their correct file names
    • C、change the tablespace status from read/write to read­only
    • D、re­create the read­only tablespace because it is automatically removed

    正确答案:B

  • 第4题：

    You have a read/x7fonly tablespace on read/x7fonly media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read/x7fonly tablespace was read/write when the control file was backed up. What should you consider？（）

    • A、drop the read­only tablespace and re­create the tablespace after recovery
    • B、take data files from the read­only tablespace offline before performing a recovery
    • C、perform a recovery; status of the tablespace in control file will be changed automatically
    • D、recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

    正确答案:B

  • 第5题：

    Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

    • A、 DROP TABLESPACE temp1；
    • B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；
    • C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
    • D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

    正确答案:C

  • 第6题：

    You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）  

    • A、 alter tablespace MY_DATA begin backup
    • B、 alter tablespace MY_DATA start backup
    • C、 alter tablespace MY_DATA backup begin
    • D、 alter MY_DATA begin backup
    • E、 You cannot back up individual tablespaces

    正确答案:A

  • 第7题：

    You are the administrator of your company's network. You are preparing to deploy 20 new Windows 2000 Professional computers on your network. You want to be able to recover from disk failures and corrupt system files on the new computers. You want to configure the computers to automatically update their system configuration and emergency repair files on a scheduled bases.   What should you do?（）

    • A、Use the at command to schedule a weekly job to back up the boot partition.
    • B、Use the at command to schedule a weekly job to run the system file checker.
    • C、Use Windows backup to schedule a backup of the System State Data.
    • D、Use Windows backup to schedule a backup of the system partition and the boot partition.

    正确答案:C

  • 第8题：

    单选题
    You install Windows 2000 Professional on your portable computer. You install an SCSI and PC card adapter, that you can use in the office to use color scanner. You use a docking station for your computer when you are in the office. You want to maximize the battery performance for your portable computer. You also want to prevent the driver from loading whenever you are away from the office. What should you do?（）
    A

    When away from the office use Device Manager to remove the adapter. 

    B

    When away from the office configure the startup properties for the adapter to be automatic. 

    C

    Remove the computer from the docking station and start Windows 2000 Professional to disable the SCSI PC card adapter device for the current profile.

    D

    Remove the computer from the docking station and start Windows 2000 Professional, use Device Manager to remove SCSI PC card adapter device.


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

  • 第9题：

    单选题
    You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）
    A

     take data files from the read-only tablespace offline before performing a recovery

    B

     recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

    C

     drop the read-only tablespace and re-create the tablespace after recovery

    D

     perform a recovery； status of the tablespace in control file will be changed automatically


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

  • 第10题：

    单选题
    You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）
    A

     flash back the database

    B

     import the temporary tablespace from the last export

    C

     restore all the data files and temporary files from the last full database backup and perform a recovery

    D

     not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace


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

  • 第11题：

    单选题
    You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）
    A

    Use the DROP DATAFILE command.

    B

    Use the DROP TABLESPACE command.

    C

    Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.

    D

    Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.


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

  • 第12题：

    单选题
    You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）
    A

     alter tablespace MY_DATA begin backup

    B

     alter tablespace MY_DATA start backup

    C

     alter tablespace MY_DATA backup begin

    D

     alter MY_DATA begin backup

    E

     You cannot back up individual tablespaces


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

  • 第13题：

    Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

    • A、You need to perform the restore and recover operations manually, because the backup was made manually. 
    • B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
    • C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
    • D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

    正确答案:C

  • 第14题：

    You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

    • A、 take data files from the read-only tablespace offline before performing a recovery
    • B、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
    • C、 drop the read-only tablespace and re-create the tablespace after recovery
    • D、 perform a recovery； status of the tablespace in control file will be changed automatically

    正确答案:A

  • 第15题：

    You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）

    • A、Use the DROP DATAFILE command.
    • B、Use the DROP TABLESPACE command.
    • C、Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
    • D、Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.

    正确答案:B

  • 第16题：

    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？ （）

    • A、 Restore the lost data file from the backup， and then flash back the database.
    • B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.
    • C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
    • D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.
    • E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

    正确答案:B,E

  • 第17题：

    USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?（）

    • A、Use Data Pump to transfer the existing data to a new encrypted tablespace
    • B、Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace
    • C、Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace
    • D、Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace
    • E、Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted

    正确答案:A,B,C

  • 第18题：

    You install Windows 2000 Professional on your portable computer. You install an SCSI and PC card adapter, that you can use in the office to use color scanner. You use a docking station for your computer when you are in the office. You want to maximize the battery performance for your portable computer. You also want to prevent the driver from loading whenever you are away from the office. What should you do?（）

    • A、When away from the office use Device Manager to remove the adapter. 
    • B、When away from the office configure the startup properties for the adapter to be automatic. 
    • C、Remove the computer from the docking station and start Windows 2000 Professional to disable the SCSI PC card adapter device for the current profile.
    • D、Remove the computer from the docking station and start Windows 2000 Professional, use Device Manager to remove SCSI PC card adapter device.

    正确答案:C

  • 第19题：

    单选题
    At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）
    A

     Start the database in OPEN mode， and create a new index tablespace.

    B

     Start the database in OPEN mode， and drop the lost index tablespace from the database.

    C

    Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.

    D

     Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.


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

  • 第20题：

    单选题
    You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）
    A

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

    B

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE

    C

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

    D

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING


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

  • 第21题：

    单选题
    One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database？（）
    A

     drop and re-create the read-only tablespaces

    B

     rename the read-only data files to their correct file names

    C

     change the tablespace status from read/write to read-only

    D

     re-create the read-only tablespace because it is automatically removed


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

  • 第22题：

    单选题
    You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）.
    A

    add data files to the tablespace 

    B

    identify the segments that you should shrink 

    C

    modify the storage parameters for the tablespace 

    D

    automatically shrink the segments with unused space 

    E

    check the alerts generated for the tablespace that is running low on space


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

  • 第23题：

    单选题
    Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）
    A

    You need to perform the restore and recover operations manually, because the backup was made manually. 

    B

    First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 

    C

    First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 

    D

    You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 


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

  • 第24题：

    单选题
    Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）
    A

     DROP TABLESPACE temp1；

    B

     DROP TABLESPACE temp1 INCLUDING CONTENTS；

    C

     DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；

    D

     DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；


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

相关内容