A.Recover from failures in the RAC environment.B.Diagno……

多项选择题Which operationsrequireundodata（）

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.

多项选择题WhichtwostatementsaretrueaboutSharedSQLAreaandPrivateSQLAreas（）

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