单项选择题
You work as a database administrator for Certkiller .com. 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 ortablespacetype 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.
相关考题
-
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.YourdatabaseisinNOARCHIVELOGmodeandyouwanttoperformabackup.Whichtypeofbackupwouldbeappropriateinthiscase？（）
A.Hot backup
B.Online backup
C.consistent backup
D.incremental backup
E.inconsistent backup -
单项选择题
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）
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 -
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.IntheCertkillerPRODUCTIONdatabaseyouhavegrantedRESUMABLEsystemprivilegetotheCONNECTrole.Resumablespaceoperationhasbeenenabledforallusersession.YouwantusersNOTtobeawareofanykindofspace-relatedproblemswhileperformingtransactions.Instead，youwanttheproblemtoberesolvedbyadatabasetriggerautomatically.Whichcombinationoftriggeringtimeandeventwouldyouusetoachievethisobjective？（）
A.AFTER CREATE
B.AFTER SUSPEND
C.BEFORE CREATE
D.AFTER TRUNCATE
E.BEFORE SUSPEND
F.AFTER INSERT OR DELETE OR DELETE
G.BEFORE INSERT OR DELETE OR DELETE
