our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener？（）

STENER byissuing the following command:lsnrctl >STOPWhat happens to the sessions that are presently connected to the database Instance？（）

A. They are able to perform only queries.

B. They are not affected and continue to function normally.

C. They are terminated and the active transactions are rolled back.

D. They are not allowed to perform any operations until the listener LISTENER is started

e. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :SQL> shutdown immediate;What is the result of executing this command？（）

A. The ASM instance is shut down, but the other instances are still running.

B. It results in an error because other database instances are connected to it.

C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.

D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant

A. The user has dropped an important table that needs to be recovered.

B. The database files are corrupted when the database is open.

C. You are not able to start up the database instance because the required database files are missing.

D. The archived log files are missing for which backup is not available.

the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true？（）

A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE

B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA

C. The database instance starts, but Automatic Memory Management is disabled

D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

he DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:ALTER TABLESPACE data1 BEGIN BACKUP;While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）

A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

D. If you restart the database, the database will not be opened.

ing big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.What configuration would you effect to achieve your objective？ （）

A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.

B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.

C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.

D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

and executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL >CONNECT scott/tiger@orcl What could be the reason for this？（）

A. The listener is not running on the database node.

B. The TNS_ADMIN environment variable is set to the wrong value.

C. The orcl.oracle.com database service is not registered with the listener.

D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.

E. The listener is running on a different port.

We are pleased to be able to accommodate you ()our hands.

A、to

B、in

C、with

D、by