Your database is open and the LISTENER listener running. You stopped the wrong listener LI

res as unit, mass, or process？ Explain your choice. (Hint: You may need to review his material found in Chapter 10.) How does is production/operations technology approach affect the way products are produced？

Why we use index in database？ How many indexes is the maximum in one

table as your suggestion？

that uses user managed backups. You want to be able to perform all backups while the database remains online.Which statement about performing user-managed backups in a 24x7 environment is true？（）

A. You must have change tracking enabled in your database

B. Your database must be running in NOARCHIVELOG mode

C. To back up a tablespace, it must be in backup mode

D. To back up a tablespace, it must first be taken offline

he control file from autobackup, what is the next step that you must do to proceed with the database recovery？（）

A. Mount the database

B. Open the database in NORMAL mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option

Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this？（）

A. Database replay

B. SQL Tuning Advisor

C. SQL Access Advisor

D. SQL Performance Analyzer

E. Automatic Workload Repository compare reports

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database.The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs？（）

A. Open the database in NORMAL mode

B. Open the database in read-only mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant

A. Change in the Oracle Database version

B. Change in your network infrastructure

C. Change in the hardware configuration of the database server

D. Migration of database storage from non-ASM to ASM storage

E. Database and operating system upgrade

The best title of the passage is likely to be“ _________”.

A． The Internet An Organized Database

B． Tools for Internet Information

C． How to Use Web Directories

D． How to Update Your Database

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN ＞ BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command？（）

A. Place the root container in ARHCHIVELOG mode.

B. Take the user data tablespace offline.

C. Place the root container in the nomount stage.

D. Ensure that HR_PDB is open.

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational？（）

A. Mount the container database (CDB) and restore the control file from the control file auto backup.

B. Recover and open the CDB in NORMAL mode.

C. Mount the CDB and then recover and open the database, with the RESETLOGS option.

D. Open all the pluggable databases.

E. Recover each pluggable database.

F. Start the database instance in the nomount stage and restore the control file from control file auto backup.