Oracle Database 12c Essentials
Question No: 31
You connect to a database instance and execute a DML command that changes one data block. The block is read from the buffer cache, modified, and modified, and marked as dirty. You commit the transaction. What must take place before the block can be written to disk?
The buffer must be written to flash cache.
A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.
The modified data block must be moved from the LRU list to the write queue.
The database must advance the checkpoint.
Question No: 32
Which three statements about replication options are true?
The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.
Oracle Streams is deprecated in Oracle Database 12c Release 1.
Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.
Oracle Database Advanced Queuing is independent of Oracle Streams.
The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.
Answer: B,C,E Explanation:
http://www.oracle.com/technetwork/database/multitenant/overview/index.html https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60159 http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds- 2030490.pdf
Question No: 33
John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMANgt;Backup Database. Mike and Tim may need point-in-time recovery of their PDBs. Which statement is true?
Recovery of individual PDBs is not possible, because John did not back up by using RMANgt;Backup Pluggable database pdb1 pdb2. However, complete CDB recovery is still possible.
Mike and Tim need to individually take backups of their respective PDBs, because CDB- level backup does not include PDB data dictionary objects.
Mike and Tim do not need to worry, because recovery of individual PDBs is possible.
Recovery of individual PDBs is not possible at all.
Answer: C Explanation:
Question No: 34
Which two statements about Database Express are true?
It uses internal infrastructure components, such as XDB and SQL*Net.
It can perform actions outside the database.
It has background tasks and processes that periodically collect information via FTP.
It has two new features: Performance Hub and Composite Active Reports.
It is not supported on Standard Edition (SE) and Express Edition (XE).
Reference: http://www.oracle.com/technetwork/database/manageability/emx-intro- 1970113.html
Question No: 35
There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command:
lsnrctl start listener2
What would be the outcome?
It starts the second listener without affecting current sessions.
It starts the second listener and terminates all current sessions.
It gives an error because multiple listeners cannot run simultaneously.
It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.
Question No: 36
Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?
Answer: E Explanation:
Question No: 37
You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer (OUI) shows a message that says one of the product-specific prerequisite checks has failed:
Checking available swap space requirements… Expected result: 1512MB
Actual Result: 1018MB
Check complete. The overall result of this check is: failed 芦芦 Problem: The system does not have the required swap space.
What happens to the installation in this situation?
It can be continued.
It resizes the swap space automatically when you proceed further.
It can be continued, but the instance cannot be started without increasing swap space.
It shows a message saying one or more prerequisite checks have failed and the installation aborts.
Question No: 38
Your customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd).
Which two options would accomplish this?
You copy all the PDBSSEEDdata files from the production CDB into the development CDB and execute this on the development CDB;
SQLgt; CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED
You alter the salesprd source database to open in read-only mode, and start cloning the source database:
SQLgt; ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;
SQLgt; CREATE PLUGGABLE DATABASE salesdev FROM salesprd;
You alter the salesprd source database to open in read-only mode: SQLgt; ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;
In the development CDB, you create a databaselink quot;PRDquot; that connects to the root of the source CDB, and start cloning the source PDB:
SQLgt; CREATE PLUGGABLE DATABASE salesdevFROM salesprd@prd;
Connected as the salesprd local DBA, you create an XML using:
SQLgt; ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO #39; /tmp/salesprd-xml#39; ; Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into the development CDB using:
SQLgt; CREATE PLUGGABLE DATABASE salesdev USING#39; /tmp/salesprd.xml#39;;
Explanation: A: Creating a PDB Using the Seed
You can use the CREATE PLUGGABLE DATABASE statement to create a PDB in a CDB using the files of the seed.
D: Plugging In an Unplugged PDB
To plug in an unplugged PDB, the following prerequisites must be met:
Complete the prerequisites described in quot;Preparing for PDBsquot;.
The XML file that describes the PDB must exist in a location that is accessible to the CDB.
The USING clause must specify the XML file. Etc
Question No: 39
View the current parameter settings shown in the output below. NAMETYPEVALUE
dml_locks integer 748
lock_sga boolean FALSE
A user logs in to the hrschema and issues the following commands:
SQLgt; CREATE TABLE emp
(empno NUMBER(3), enamo VARCHAR2(20),
sal NUMBER (8, 2));
SQLgt; INSERT INTO emp (empno, ename) VALUES(1, #39;JAMES#39;);
At this moment, a second user also logs in to the hrschema and issues the following command:
SQLgt; ALTER TABLE emp MODIFY salNUMBER(10, 2);
What happens in this scenario?
The second user#39;s session immediately produces a quot;resource busyquot; error.
The second user#39;s command executes successfully.
The second user#39;s session waits for a time before producing a quot;resource busyquot; error.
A deadlock is created.
Question No: 40
Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?
It requires the database to be open.
It analyzes the performance of specified objects.
It implements all recommendations automatically.
It recommends solutions and quantifies expected benefits.
It retains snapshots in the SYSAUX tablespace until the database is restarted.
It analyzes the snapshots stored in the Automatic Workload Repository (AWR).
Dumps4cert ExamCollection Testking Lowest Price Guarantee Yes No No Up-to-Dated Yes No No Real Questions Yes No No Explanation Yes No No PDF VCE Yes No No Free VCE Simulator Yes No No Instant Download Yes No No