when multiple databases are to be registered with the listener
when DBAs need to connect remotely to start up the database instance
when users need to connect the database instance using the host naming method
when the database instance that is to be registered with the listener is configured in shared server mode
第1题:
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()
第2题:
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()
第3题:
A. Oracle Net Manager
B. Listener Control utility
C. Database Configuration Assistant
D. Oracle Net Configuration Assistant
第4题:
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?()
第5题:
In which case would you use the Flashback Database feature to perform a recovery?()
第6题:
Which command would you use to determine what database backups are currently available for restore?()
第7题:
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()
第8题:
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()
第9题:
In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()
第10题:
Which command would you use to determine what database backups are currently available for restore?()