网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 AdvisorB SQL Access AdvisorC Undo AdvisorD Segment Advisor” 相关考题
考题
He got a/an _____ to see the world and started out with empty pockets.A: thirstB: urgeC: urgencyD: desire
考题
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
考题
View the Exhibit for some of the parameter settings. You start a session and issue the following command:SQLCREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;What is the outcome of the above command?（）A. The index is not used by the optimizer but is maintained during DML operations.B. The index is not used by the optimizer and is not maintained during DML operations.C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.
考题
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task? （）A. AB. BC. CD. D
考题
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 tablespaceB. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceC. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceD. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceE. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
考题
You are attending a meeting on Microsoft Windows Meeting Space. At the same time, you attempt to join a second meeting also hosted on Windows Meeting space. The dialog box that allows you to join the second meeting fails to open. You need to join the second meeting.What should you do?（）A.AB.BC.CD.D
考题
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 suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）A、by using triggersB、by using external tablesC、by using anonymous PL/SQL blocksD、by auditing all DML operations on the table
考题
You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）A、run a procedure to check the tablespace space usageB、define the warning threshold for the tablespace at 75% in Database ControlC、create a trigger to be executed when tablespace space usage reaches 75%D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsE、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
考题
You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）A、the alert.log fileB、the DBA_ALERTS viewC、the Database Control Home pageD、the Database Control performance pageE、the Database Control Maintenance page
考题
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 AdvisorB、 SQL Access AdvisorC、 Undo AdvisorD、 Segment Advisor
考题
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 tablespaceB、Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceC、Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceD、Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceE、Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
考题
单选题You define an alert to be raised when the USERS tablespace usage has reached 80%of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）A
the alert.log fileB
the DBA_ALERTS viewC
the Database Control Home pageD
the Database Control performance pageE
the Database Control Maintenance page
考题
单选题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)
考题
单选题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
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
考题
单选题“Space is limited, so early registration is welcome” means ______.A
space is limited, so you can’t register nowB
space is too limited for you to registerC
you’ll lose the good chance if you don’t register soonD
you’ll be given a special offer if you register now
考题
单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）A
DBMS_STATS B
DBMS_ALERT C
DBMS_SPACE D
DBMS_MONITOR E
DBMS_SERVER_ALERTF
DBMS_SPACE_ADMIN
考题
单选题View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB. Which configuration couldhave enabled the block selection of 16 KB（）A
Choosing the extent allocation type to uniformB
Choosing the Segment Space Management option to manualC
Setting autoextension on for the data file mentioned for the tablespaceD
Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
考题
单选题You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）A
by using triggersB
by using external tablesC
by using anonymous PL/SQL blocksD
by auditing all DML operations on the table
考题
单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）A
You must enable the row movement on the SCOTT.EMP table.B
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C
You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D
You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
考题
单选题During jacking operations and transit，empty void spaces in the hull of a jack up ship provide（）.A
buoyancyB
extra storage spaceC
additional tank capacityD
reduced stability
考题
单选题You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）A
run a procedure to check the tablespace space usageB
define the warning threshold for the tablespace at 75% in Database ControlC
create a trigger to be executed when tablespace space usage reaches 75%D
submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsE
define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
考题
单选题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 AdvisorB
SQL Access AdvisorC
Undo AdvisorD
Segment Advisor
考题
单选题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 space 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 space usage metrics for the APPS tablespace. What should you do？（）A
disable SQL tracing for theAPPS tablespaceB
disable logging attribute for the APPS tablespaceC
modify the tablespace to be a dictionarymanaged tablespaceD
increase the critical threshold value for the tablespace space usage metrics for the APPS tablespaceE
increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace
考题
单选题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
热门标签
最新试卷
