A.It transfers statistics from memory to disk at regular intervals.
B.It coordinates the rebalance activity for disk groups when ASM is used.
C.It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.
D.It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
您可能感兴趣的试卷
你可能感兴趣的试题
A.It can be increased up to the value of the SGA_MAX_SIZE parameter.
B.Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.
C.Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.
D.Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
A.Recover from failures in the RAC environment.
B.Diagnose and repair a data file corruption online.
C.Diagnose and repair a data file corruption offline.
D.Diagnose and repair failures on a standby database
A.Committing a transaction
B.Flashing back a transaction
C.Recovering a failed transaction
D.Running a read-consistent query
E.Changing a tablespace status from READ ONLY to READ WRITE
You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.
What will be the implications onthe archiving and the location of archive redo log files（）
A.Archiving will be disabled because the destination for the redo log files is missing.
B.The database instance will shut down and the error details will be logged in the alert log file.
C.Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.
D.Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.
A.Shared SQL Area will be allocated in the shared pool.
B.Shared SQL Area will be allocated when a session starts.
C.Shared SQL Area will be allocated in the large pool always.
D.The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.
E.Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F.The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client
whileconnecting to the database instance from a remote machine（）
A.Host naming method
B.Local naming method
C.External naming method
D.Directory naming method
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；
Which two statements are true about theeffect of the command（）
A.No flashback is possible to bring back the ITEM table.
B.The ORDERS table is dropped along with the ITEM table.
C.The dependent referential integrity constraints in the ORDERS table are disabled.
D.The dependent referential integrity constraints in the ORDERS table are removed.
E.The table definition of the ITEM table and associated indexes are placed in the recycle bin
You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr
flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification
ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status
What would you do to overcome the error（）
A.Add the user， SYSTEM， to the schemas option.
B.Add the network_link = devdb.us.oracle.com option.
C.Change the dumpfile option to schema.dat@devdb.us.oracle.com.
D.Replace the schemas option with the network_link = devdb.us.oracle.com
E.Replace the dumpfile option with the network_link = devdb.us.oracle.com
Which two operations can be performed on an external table（）
A.Create a view on the table.
B.Create an index on the table.
C.Create a synonym on the table.
D.Add a virtual column to the table.
E.Update the table using the UPDATE statement.
F.Delete rows in the table using the DELETE command
Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users.
What could be the reason for this（）
A.To limit the User Global Area （UGA） memory allocated to a session from the SGA
B.To limit the amount of memory to be used for the dispatcher queue of a session in SGA
C.To limit the amount of memory to be used for the request pool in System Global Area （SGA）
D.To control the amount of memory allocated in SGA for the local variables for each shared server process
最新试题
You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted（）
The user HR receives the following error while inserting data into the TTK table：ERROR at line 1：ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace.Which three action would allow the user to insert data（）
Which statements are true regarding the Oracle Data Pump export and import operations（）
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command：SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command：SQL> GRANT SELECT ON scott.emp TO hr；Which statement describes the outcome of the command（）
Identify the situations in which you use the alert log file in your database to check the detail.（）
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95Which background process is responsible for issuing alerts when the threshold is crossed（）
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）
Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）