The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?()
A. All archived redo log files backed up at least twice to tape are deleted.
B. All archived redo log files backed up at least once to tape are eligible for deletion.
C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
第1题:
A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.
B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.
C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.
D.Theapproximatetimeandthelowestsystemchangenumber(SCN)towhichyoucanflashbackyourdatabase.
第2题:
A.selectfile->Database->newandgiveitafilenameof“blank.nsf”
B.selectfile->Database->new,chooselocalastheserver,andchosetheblanktemplate
C.selectfile->Database->new,chooselocalastheserver,andchosethedefault.ntftemplate
D.selectfile->Database->new,giveitafilenameof“blank.nsf”,andchosetheblanktemplate
第3题:
A.对于UNIX,在$ORACLE_HOME/dbs
B.对于UNIX,在$ORACLE_HOME/dbs/admin
C.对于Linux,在%ORACLE_HOME%\database
D.对于Windows,在%ORACLE_HOME%\dbs
E.对于Windows,在%ORACLE_HOME%\database\admin
第4题:
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?()
A. All users except SYS
B. All users except SCOTT
C. All users except sys and SCOTT
D. All users except sys, system, and SCOTT
第5题:
Anadministratorisplanningaclusterrunningapplicationsin3separateresourcegroups.RGA-Database1RGB-WebServerRGC-Database2Database1andDatabase2mustbeonlinebeforetheWebServer.AllresourcegroupshaveaStartupPolicyofOnlineonHomeNodeOnly.Whichofthefollowingwillensurethattheresourcegroupsareprocessedinthecorrectorder?()
A.SettheSerialAcquisitionOrder
B.SettheParallelAcquisitionOrder
C.ConfigureOnlineontheSameNodeDependency
D.ConfigureOnlineonDifferentNodesDependency
第6题:
A.DB_FILES
B.DB_DATAFILES
C.DATABASE_FILES
D.LOG_FILES