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

Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）

A.The operation would fail if tbs_1 were a read-only tablespace.
B.The operation would fail if tbs_1 were a read/write tablespace.
C.The operation would fail if tbs_1 were the default tablespace for the database.
D.If the above operation were successful， media recovery would be required to bring the tablespace online.
E.If the above operation were successful， instance recovery would be required to bring the tablespace online.

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

多项选择题The following are the details of your database：Instance name：test  Host name ： tech1.us.oracle.com IP address：145.33.230.186 Enterprise Manager Console HTTP Port number：5500  You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser.  Which two URLs would you use to access the Database Control？（）

A.http：//145.33.230.186：5500/em
B.http：//www.145.33.230.186：5500/em
C.http：//tech1.us.oracle.com：5500/em
D.http：//test.145.33.230.186：5500/em
E.http：//test.tech1.us.oracle.com：5500
F.http：//www.tech1.us.oracle.com：5500/em
G.http：//test.tech1.us.oracle.com：5500/em

单项选择题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