EnsurepassQUESTION 81 Which three statements are true about Oracle Data Pump export and import operations?   A. You can detach from a data pump export job and reattach later. B. Data pump uses parallel execution server processes to implement parallel import. C. Data pump import requires the import file to be in a directory owned by the oracle owner. D. The master table is the last object to be exported by the data pump. E. You can detach from a data pump import job and reattach Read more [...]
EnsurepassQUESTION 91 Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.   SQL> SELECT name, active_sessions, queue_length, Consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group; NAMEACTIVE_SESSIONS QUEUE_LENGTH CONSUMED_CPU_WAITS CPU_WAIT_TIME ---------------------------------- -------------------- -------------------- --------------------- ---------------- OLTP__ORDER__ENTRY1029690 467 OTHES__GROUPS 0 059823664089 60425 Read more [...]
EnsurepassQUESTION 101 Examine the parameters for your database instance:     Which three statements are true about the process of automatic optimization by using cardinality feedback?   A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics. B. The optimizer can re optimize a query only once using cardinality feedback. C. The optimizer enables monitoring Read more [...]
EnsurepassQUESTION 51 You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:   Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with the execution of complex BI queries scheduled at night.   Which DBCA option must you choose to create the database?   A. a General Purpose database template with default memory Read more [...]
EnsurepassQUESTION 61 You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).   The following are the possible steps to accomplish this task:   1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set Read more [...]
EnsurepassQUESTION 71 Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:   SQL > CREATE UNDO TABLESPACE undotb01 DATAFILE `u01/oracle/rddb1/undotbs01.dbf' SIZE 60M AUTOEXTEND ON;   What is the result?   A. It executes successfully and creates an UNDO tablespace in HR_PDB. B. It falls and reports an error because there can be only one undo tablespace in a CDB. C. It fails and Read more [...]
EnsurepassQUESTION 31 Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?   A. Bind Variable Peeking B. SQL Plan Baselines C. Adaptive Cursor Sharing D. Bind variable used in a SQL statement E. Literals in a SQL statement   Correct Answer: ACE Explanation: In bind variable peeking (also known as bind peeking), the optimizer looks at the value in a bind variable when the database Read more [...]
EnsurepassQUESTION 41 On your Oracle Database, you issue the following commands to create indexes:   SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);   Which two statements are true?   A. Only the ORD_CUSTOMER_IX1 index created. B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table. C. Both the indexes Read more [...]
EnsurepassQUESTION 11 To enable the Database Smart Flash Cache, you configure the following parameters:   DB_FLASH_CACHE_FILE = `/dev/flash_device_1' , `/dev/flash_device_2' DB_FLASH_CACHE_SIZE=64G   What is the result when you start up the database instance?   A. It results in an error because these parameter settings are invalid. B. One 64G flash cache file will be used. C. Two 64G flash cache files will be used. D. Two 32G flash cache files will be used.   Correct Read more [...]
EnsurepassQUESTION 21 You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.All databases of all versions use Automatic Storage Management (ASM).Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?   A. The ASM compatibility attribute controls the format of the disk group metadata. B. RDBMS compatibility together with the database version determines whether a database Instance can mount Read more [...]
EnsurepassQUESTION 1 Which action takes place when a file checkpoint occurs?   A. The checkpoint position is advanced in the checkpoint queue. B. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file. C. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files. D. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo Read more [...]