2018 Jan Oracle Official New Released 1z0-497
100% Free Download! 100% Pass Guaranteed!

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?

  1. The buffer must be written to flash cache.

  2. A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.

  3. The modified data block must be moved from the LRU list to the write queue.

  4. The database must advance the checkpoint.

Answer: B

Question No: 32

Which three statements about replication options are true?

  1. The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.

  2. Oracle Streams is deprecated in Oracle Database 12c Release 1.

  3. Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.

  4. Oracle Database Advanced Queuing is independent of Oracle Streams.

  5. 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?

  1. 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.

  2. Mike and Tim need to individually take backups of their respective PDBs, because CDB- level backup does not include PDB data dictionary objects.

  3. Mike and Tim do not need to worry, because recovery of individual PDBs is possible.

  4. Recovery of individual PDBs is not possible at all.

Answer: C Explanation:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_pitr/pdb_pitr. html


Question No: 34

Which two statements about Database Express are true?

  1. It uses internal infrastructure components, such as XDB and SQL*Net.

  2. It can perform actions outside the database.

  3. It has background tasks and processes that periodically collect information via FTP.

  4. It has two new features: Performance Hub and Composite Active Reports.

  5. It is not supported on Standard Edition (SE) and Express Edition (XE).

Answer: A,D

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?

  1. It starts the second listener without affecting current sessions.

  2. It starts the second listener and terminates all current sessions.

  3. It gives an error because multiple listeners cannot run simultaneously.

  4. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.

Answer: A

Reference: https://blogs.oracle.com/rtsai/entry/how_to_configure_multiple_oracle

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?

  1. 615 MB

  2. 2.5 GB

  3. 4 GB

  4. 12 GB

  5. 22 GB

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?

  1. It can be continued.

  2. It resizes the swap space automatically when you proceed further.

  3. It can be continued, but the instance cannot be started without increasing swap space.

  4. It shows a message saying one or more prerequisite checks have failed and the installation aborts.

Answer: A

Reference: https://bugs.kde.org/show_bug.cgi?id=111460

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?

  1. You copy all the PDBSSEEDdata files from the production CDB into the development CDB and execute this on the development CDB;


    by password;

  2. You alter the salesprd source database to open in read-only mode, and start cloning the source database:


    SQLgt; CREATE PLUGGABLE DATABASE salesdev FROM salesprd;

  3. 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;

  4. 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;;

Answer: C,D

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

    db_file_multiblock_read_count integer


    ddl_lock_timeout integer


    Distributed_lock_timeout integer


    dml_locks integer 748

    lock_sga boolean FALSE

    enab1e_dd1_1ogging boolean


    resumable_timeout integer


    A user logs in to the hrschema and issues the following commands:


    (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?

    1. The second user#39;s session immediately produces a quot;resource busyquot; error.

    2. The second user#39;s command executes successfully.

    3. The second user#39;s session waits for a time before producing a quot;resource busyquot; error.

    4. A deadlock is created.

    Answer: C

    Question No: 40

    Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?

    1. It requires the database to be open.

    2. It analyzes the performance of specified objects.

    3. It implements all recommendations automatically.

    4. It recommends solutions and quantifies expected benefits.

    5. It retains snapshots in the SYSAUX tablespace until the database is restarted.

    6. It analyzes the snapshots stored in the Automatic Workload Repository (AWR).

    Answer: A,D,F

    Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14211/diagnsis.htm

    100% Free Download!
    Download Free Demo:1z0-497 Demo PDF
    100% Pass Guaranteed!
    Download 2018 EnsurePass 1z0-497 Full Exam PDF and VCE

    EnsurePass 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

    2018 EnsurePass IT Certification PDF and VCE