多项选择题

Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）

A.adding a new user to the database
B.dropping a user from the database
C.dropping a table from the database
D.dropping a data file from a tablespace
E.adding a new tablespace to the database

点击查看答案

上一题目录下一题

相关考题

多项选择题

A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）

A.Data Pump
B.Oracle Net Manager
C.Oracle Enterprise Manager
D.Oracle Universal Installer （OUI）
E.Database Configuration Assistant （DBCA）

单项选择题

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 file
B.the DBA_ALERTS view
C.the Database Control Home page
D.the Database Control performance page
E.the Database Control Maintenance page

多项选择题

You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）

A.Set the UNDO_RETENTION parameter to 900 or more.
B.Create an initial undo segment in the undo tablespace.
C.Enable the retention guarantee for the undo tablespace.
D.Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
E.Set the UNDO_MANAGEMENT initialization parameter to AUTO.