单项选择题

A.Control fileB.Password fileC.Parameter fileD.Online r……

You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）

A.Control file
B.Password file
C.Parameter file
D.Online redo log file
E.Listener controller file
F.Server parameter file

<上一题目录下一题>

热门试题

多项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youwanttocreateyourdatabasewiththeautomaticundomanagementfeatureenable.Whichtwotasksmustyouperformtoachievethis？（）

A.Set the UNDO_RETENTION parameter to AUTO.
B.Create an initial undo segment in undotablespace.
C.Set the UNDO_RETENTION parameter to 900 or more
D.Set the initialization parameter UNDO_MANAGEMENT to AUTO
E.Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

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