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

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

相似考题

1.You create a Web application for your company‘s intranet. You want to enable users to customize their versions of the intranet home page. You create sections of content as Web Parts. You need to ensure that users can customize content at any time.Which two code segments should you use?（）A.B.C.D.

2. Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、The retention period to support flashbackB、The expected length of the longest-running queryC、The number of undo tablespaces in the databaseD、The size of the Flash Recovery Area for the database instance

3.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、identify the segments that you should shrinkB、modify the storage parameters for the tablespaceC、automatically shrink the segments with unused spaceD、check the alerts generated for the tablespace that is running low on space

4.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. identify the segments that you should shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low on space

更多“单选题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 parame”相关问题

  • 第1题：

    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

  • 第2题：

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

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

    正确答案:A,B

  • 第3题：

    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）

    • A、 SQL Tuning Advisor
    • B、 SQL Access Advisor
    • C、 Undo Advisor
    • D、 Segment Advisor

    正确答案:D

  • 第4题：

    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

    • A、The database will open, and the tablespace automatically comes out of the backup mode
    • B、The database will be mounted, and recovery must be performed on the USERS tablespace.
    • C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
    • D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

    正确答案:C

  • 第5题：

    Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）

    • A、 Disable SQL tracing for the APPS tablespace.
    • B、 Disable logging attributes for the APPS tablespace.
    • C、 Modify the tablespace to be a dictionary-managed tablespace.
    • D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
    • E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.

    正确答案:E

  • 第6题：

    单选题
    You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）
    A

    Segment Advisor 

    B

    SQL Tuning Advisor 

    C

    SQL Access Advisor 

    D

    Segment Resource Estimation 

    E

    Automatic Database Diagnostic Monitor (ADDM)


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

  • 第7题：

    多选题
    Identify three situations in which you would NOT be able to drop a tablespace. （）
    A

    when the tablespace is online

    B

    when the tablespace has segments with data in it

    C

    when the tablespace is a default permanent tablespace for the database

    D

    when the tablespace contains a table that is currently being used by transactions

    E

    when the tablespace contains undo data that is needed to rollback an uncommitted transaction


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

  • 第8题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    The retention period to support flashback

    B

    The expected length of the longest-running query

    C

    The number of undo tablespaces in the database

    D

    The size of the Flash Recovery Area for the database instance


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

  • 第9题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online


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

  • 第10题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online


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

  • 第11题：

    单选题
    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）
    A

     SQL Tuning Advisor

    B

     SQL Access Advisor

    C

     Undo Advisor

    D

     Segment Advisor


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

  • 第12题：

    单选题
    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）
    A

    The database will open, and the tablespace automatically comes out of the backup mode.

    B

    The database will be mounted, and recovery must be performed on the USERS tablespace.

    C

    The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

    D

    The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.


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

  • 第13题：

    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

    • A、 the RMAN LIST command
    • B、 the DBNEWID utility
    • C、 the RMAN REPORT command
    • D、 the RMAN BLOCKRECOVER command
    • E、 the RMAN CROSSCHECK command
    • F、 the ANALYZE command

    正确答案:F

  • 第14题：

    Due to media failure you lost one of the data files belonging to the USERS tablespace， and the tablespace is not available to use. Which statement regarding the status of the database is true？（）

    • A、The database remains open.
    • B、The database gets dismounted.
    • C、The database becomes read only.
    • D、The database instance gets aborted.
    • E、The database gets shut down automatically.
    • F、The status of the database depends on the status of the USERS tablespace.

    正确答案:A

  • 第15题：

    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

    • A、The tablespace has two data files.
    • B、An error is reported and tablespace creation fails.
    • C、Data files are created with names generated by the instance.
    • D、The tablespace can be extended without specifying the data file.
    • E、Data files belonging to the USERS tablespace cannot be renamed.

    正确答案:C,D

  • 第16题：

    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）

    • A、Shut down the database, restore the two data files and then start up the database. 
    • B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 
    • C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 
    • D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.

    正确答案:C

  • 第17题：

    单选题
    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
    A

    Shut down the database, restore the two data files and then start up the database. 

    B

    Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 

    C

    Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 

    D

    Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.


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

  • 第18题：

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

     identify the segments that you should shrink

    B

     modify the storage parameters for the tablespace

    C

     automatically shrink the segments with unused space

    D

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


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

  • 第19题：

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

    identify the segments that you should shrink

    B

    modify the storage parameters for the tablespace

    C

    automatically shrink the segments with unused space

    D

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


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

  • 第20题：

    单选题
    While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）
    A

    the CREATE TABLE .. command

    B

    sorting of the SYSTEM tablespace’s data

    C

    sorting of data required by recursive SQL statements

    D

    the CREATE TABLE .. ORGANIZATION EXTERNAL .. command

    E

    sorting of data if the users have not been allocated temporary tablespace explicitly

    F

    sorting of data if the users have been allocated temporary tablespace explicitly


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

  • 第21题：

    单选题
    To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）
    A

     The database will open，and the tablespace automatically comes out of the backup mode.

    B

     The database will be mounted，and recovery must be performed on the USERS tablespace.

    C

     The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.

    D

     The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.


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

  • 第22题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    The retention period to support flashback

    B

    The expected length of the longest-running query

    C

    The number of undo tablespaces in the database

    D

    The size of the Flash Recovery Area for the database instance


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

  • 第23题：

    单选题
    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
    A

    the DBNEWID utility

    B

    the ANALYZE command

    C

    the RMAN LIST command

    D

    the RMAN REPORT command

    E

    the RMAN CROSSCHECK command

    F

    the RMAN BLOCKRECOVER command


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

相关内容