找考题网-背景图
多项选择题

Which two statements about Recovery Manager （RMAN） backups are true？ （）

A.Online redo log files can be backed up.
B.Archived redo log files are backed up.
C.Only used data blocks can be backed up as backup sets.
D.Only consistent database backups can be performed.
E.RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.

<上一题 目录 下一题>
热门试题

单项选择题ThedatabaseusersareconnectingtothePRODdatabasefromdifferentapplications，therebydegradingthedatabaseperformance.Theseniordatabaseadministratorsuspectsthelargenumberofconcurrentconnectionstobethereasonforlowperformanceandasksyoutorestrictthenumberconcurrentconnectionsperdatabaseusertoone.Whichactionwouldyoutaketoachievethisobjective？（）

A.set the SESSIONS to 1 in the parameter file
B.grant SINGLE SESSION privilege to all of the users
C.set the SESSIONS_PER_USER to 1 in the users’ profile
D.grant RESTRICTED SESSION privilege to all of the database users
E.create a role with SINGLE SESSION privilege and assign the role to the users

多项选择题WhichtwostatementsaretrueregardingaPL SQLpackagebody？（）

A.It cannot be created without a package specification.
B.It cannot invoke subprograms defined in other packages.
C.It can contain only the subprograms defined in the package specification.
D.It can be changed and recompiled without making the package specification invalid.

单项选择题Youworkinadatawarehouseenvironmentthatinvolvestheexecutionofcomplexqueries.ThecurrentcontentoftheSQLcacheholdstheidealworkloadforanalysis.Youwanttoanalyzeonlyfewmostresource-intensivestatements.Whatwouldbeyoursuggestiontoreceiverecommendationsontheefficientuseofindexesandmaterializedviewstoimprovequeryperformance？（）

A.Run the SQL Access Advisor.
B.Run the SQL Tuning Advisor （STA）.
C.Run the Automatic Workload Repository （AWR） report.
D.Run the Automatic Database Diagnostic Monitor （ADDM）.

多项选择题WhichtwodatabaseoperationscanbeperformedattheMOUNTstageofdatabasestartup？（）

A.renaming of data files
B.dropping the database user
C.renaming of control files
D.multiplexing of control files
E.configuring the database in ARCHIVELOG mode

多项选择题YourdatabaseisinNOARCHIVELOGmode.Afterwhichtwooperationsyoushouldtakethebackupofcontrolfile？（）

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