多项选择题
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
相关考题
-
多项选择题
Auserwantstoconnecttothedatabaseinstancefromanapplicationthatisrunningonaremotemachine.WhichtoolsshouldtheDBAusetoestablishtherequiredconfigurationtoensurethattheuserisabletoconnecttothedatabaseinstance?()
A.Data Pump
B.Oracle Net Manager
C.Oracle Enterprise Manager
D.Oracle Universal Installer (OUI)
E.Database Configuration Assistant (DBCA) -
单项选择题
YoudefineanalerttoberaisedwhentheUSERStablespaceusagehasreached80%ofthetotalspace.Whichareawouldyoureferto,inordertoconfirmthatthealerthasbeenraisedduetheevent?()
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 -
多项选择题
YourequiretheOracleservertomanagetheundosegmentsandspaceamongvariousactivesessionsautomatically.Youcreatedanundotablespace,UNDO_TBS1,inyourdatabase.Whichtwoadditionalstepswouldyouperformtoachievethis?()
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.
