单项选择题

A.The table is partitionedB.The table name is wrong.C.I……

You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：
ERROR at Line 1：
ORA-10635： Invalid segment or tablespace type
What could be the reason？（）

A.The table is partitioned
B.The table name is wrong.
C.It is an index-Organized table （IOT）
D.The table is stored in locally managedtablespace.
E.The table is stored in atablespacewhere segment space is managed manually.

<上一题目录下一题>

热门试题

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.YourdatabaseisinNOARCHIVELOGmodeandyouwanttoperformabackup.Whichtypeofbackupwouldbeappropriateinthiscase？（）

A.Hot backup
B.Online backup
C.consistent backup
D.incremental backup
E.inconsistent backup

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youenabledtracingwhilecreatingalistenertoyourdatabase.Whatadditionalinformationisavailabletoyouwhenyouenabletracing？（）

A.Information about each Oracle Net connection.
B.Information about each entry in theLinstener.orafile
C.Information about the changed done in the database
D.Information about the different listeners in your system
E.Information about all thenondatabasefiles required to operate the database

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.YouwanttobenotifiedwhenthenumberofdiskI Oincreasesby10%ofwhatitwasyesterday.Youcreateabaselinemetricforyesterday’sdiskI Operformance.Howdoyouusethebaselinemetricstoachieveyourobjective？（）

A.Save the baseline in the database
B.Save the baseline in the Database Control Home Page
C.Create a procedure to read and apply the baseline to disk I/O metrics
D.Apply the baseline to the disk I/O metrics in the Mange Metrics page
E.Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd

单项选择题You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）

A.The advisory memory has been turned off.
B.The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
C.The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
D.The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
E.The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

单项选择题Exhibit You work as a database administrator for Supportcenter.cn. While creating a new user or changing the password for existing users， the password must adhere to the restrictions specified in the exhibit. Which option would you use to achieve this objective？（）

A.Use a trigger to validate the password
B.Use a user defined PL/SQL block to validate the password
C.Use a profile to include the password verify function to validate the password
D.Use Oracle’s default password verification procedure to validate the password
E.Use a procedure name in the CREATE USER command to validate the password