单项选择题
You find today’s performance of your production database to be the best ever.
Therefore, you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this?()
A.A
B.B
C.C
D.D
E.E
相关考题
-
多项选择题
Yourapplicationdemandsfrequentconnectionanddisconnectionfromthedatabase.YouhavethreelistenerprocessesthatarelisteningforthedatabasePROD.WhilesettinguptheconnectstringusingOracleEnterpriseManager10gDatabaseControl,whichtwooptionswouldyouselecttobalancetheconnectionloadacrossallthelistenerprocesses?()
A.Use only the first address.
B.Try one address,selected at random.
C.Try each address,in order,until one succeeds.
D.Try each address,randomly,until one succeeds. -
单项选择题
Redologfilesaremultiplexedinyourdatabase.Thediskinwhichyouhaveoneoftheredologmembersishighlyfragmented.Intheprocessofdefragmentationyoulosetheredologmember,whichisnotamemberofthecurrentgroup.Howwouldyourecoverfromthelossoftheredologmember?()
A.SMON would automatically restore the lost file.
B.You would need to restore the whole database from the last backup.
C.You would need to restore the file from the last full database backup.
D.You would need to use flashback technology to restore the lost redo log member.
E.You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
F.You would need to restore the missing log file by copying one of the remaining files from the same group. -
多项选择题
You decided to increase the value for the SHARED_SERVERS parameter by using the following command: SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=?; Which three values can be specified for the SCOPE clause?()
A.ALL
B.PFILE
C.BOTH
D.NONE
E.SPFILE
F.MEMORY
G.INSTANCE
H.DATABASE
