206、

206.Which two statements are true regarding listeners? (Choose two.) A. Listeners use only the TCP/IP protocol.  B. Multiple listener processes can run simultaneously on a host. C. Multiple database instances can be registered with a single listener. D. The listener-related errors can be traced only at the administrative level. E. Only one database instance can be registered with a single listener at any time.

Answer: BC

 

207、

207.Which three statements are correct about temporary tables? (Choose three.) A. Indexes and views can be created on temporary tables. B. Both the data and the structure of temporary tables can be exported. C. Temporary tables are always created in a user's temporary tablespace. D. The data inserted into a temporary table in a session is available to other sessions. E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.

Answer: ACE

 

208、

208.Which of these is true about undo tablespace? A. Undo tablespace is a temporary tablespace B. Undo tablespace has only one datafile C. Undo tablespace has a datafile which is reused in cyclic manner

Answer: A

 

209、

209.Your database is in shutdown state. What will happend if you issue next command: SQL> startup A. instance will started B. instance started and DB is mounted C. instance started, DB opened and finally mounted D. instance started, DB mounted and finally opened

Answer: D

 

210、

210.In which of the scenario will the DBA perform recovery? (Choose all that apply.) A. The alert log file is corrupted B. A tablespace is accidentally dropped C. One of the redo log members is corrupted D. A database user terminates the session abnormally E. The hard disk on which the data files is stored is corrupted

Answer: BE