How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）A、Include an SPFILE parameter in each instance-specified initialization file.B、Create an SPFILE copy on each client fr

第1题：

Which statement is true regarding Dynamic Service Registration？（）

• A、Dynamic service registration requires configuration in the listener .ora file.
• B、Dynamic service registration can be used only with an Oracle9/instance.
• C、Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.
• D、The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.

第2题：

Which three statements regarding the server parameter file （SPFILE） are true（）

• A、An SPFILE is a binary file.
• B、An SPFILE cannot reside on a client.
• C、An SPFILE cannot contain static parameters.
• D、An SPFILE can store changes persistently across instance restarts.
• E、An SPFILE can be read by the database server， but it is not written to by the server.
• F、An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database.

第3题：

第4题：

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）

• A、Use Oracle Managed Files (OMF).
• B、Specify the SEED FILE_NAME_CONVERT clause.
• C、Specify the PDB_FILE_NAME_CONVERT initialization parameter.
• D、Specify the DB_FILE_NAMECONVERT initialization parameter.
• E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

第5题：

You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

• A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
• C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

第6题：

You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

• A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
• B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
• C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
• D、 Increase the value of the SGA_TARGET initialization parameter.

第7题：

You are managing an Oracle Database 11g database with the ASM storage. The database is having 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.

第8题：

第9题：

What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）

• A、It can contain parameters with distinct values for each distance.
• B、It can contain only parameters with identical values for each instance.
• C、It must contain an IFILE parameter for each instance’s individual parameter file.
• D、It must be located in the default location for the primary instance’s parameter file.

第10题：

Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH；  What would be the outcome of this command（）

• A、The command succeeds only if Automatic Memory Management is not enabled.
• B、The command succeeds， but you need to restart the database for changes to take effect.
• C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.
• D、The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.