考题
多选题You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()AUser session dataBStack spaceCPrivate SQL areaDLocation of the runtime area for DML and DDL StatementsELocation of a part of the runtime area for SELECT statements
考题
多选题Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()ABind Variable PeekingBSQL Plan BaselinesCAdaptive Cursor SharingDBind variable used in a SQL statementELiterals in a SQL statement
考题
多选题Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?()AA DBA can check specific tables with the DMUBThe database to be migrated must be opened read-only.CThe release of the database to be converted can be any release since 9.2.0.8.DThe DMU can report columns that are too long in the converted characterset.EThe DMU can report columns that are not represented in the converted characterset.
考题
多选题Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?()AThe size of the shared pool is too small.BCursors are not being shared.CA large number COMMITS are being performed.DThere are frequent logons and logoffs.EThe buffers are being read into the buffer cache, but some other session is changing the buffers.
考题
多选题In which two scenarios do you use SQL* Loader to load data?()ATransform the data while it is being loaded into the database.BUse transparent parallel processing without having to split the external data first.CLoad data into multiple tables during the same load statement.DGenerate unique sequential key values in specified columns.
考题
多选题Which three statements are true concerning unplugging a pluggable database (PDB)?()AThe PDB must be open in read only mode.BThe PDB must be dosed.CThe unplugged PDB becomes a non-cdb.DThe unplugged PDB can be plugged into the same multitenant container database (CDB)EThe unplugged PDB can be plugged into another cdb.FThe PDB data files are automatically removed from disk.