[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-497 Dumps with VCE and PDF Download 51-60

Ensurepass.com : Ensure you pass the IT Exams 2018 Jan Oracle Official New Released 1z0-497
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-497.html

Oracle Database 12c Essentials

Question No: 51

Which two statements about multitenant architecture are true?

  1. It ensures full backward compatibility with non-CDBs.

  2. It fully operates with RAC.

  3. It is integrated with Enterprise Manager, but not with the Resource Manager.

  4. It allows central management and administration of single databases.

Answer: A,D

Explanation: http://oracle-base.com/articles/12c/multitenant-resource-manager-cdb-and- pdb-12cr1.php

https://docs.oracle.com/database/121/RACAD/admcon.htm#RACAD8961 https://docs.oracle.com/database/121/BRADV/rcmrepai.htm#BRADV89725

Question No: 52

Examine the commands:

SQLgt; CONNECT sys@CDBl AS SYSDBA

$QLgt;STARTUP MOUNT

SQLgt; ALTER DATABASE cdbl MOUNT;

Which four options represent what happens when these commands are executed?

  1. The instance is started.

  2. The CDB control files are opened for the instance.

  3. The root is mounted.

  4. The root is opened.

  5. The PDBs are mounted.

  6. The PDBs are mounted, and the seed is opened in READ ONLY mode.

  7. The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.

Answer: A,B,C,E

Question No: 53

Ensurepass 2018 PDF and VCE

Which two statements about this policy are true?

  1. It replaces the first four digits of the value from the SALARY column with the number 9.

  2. It replaces the first digit of the value from the SALARY column with the number 4.

  3. It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.

  4. It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.

  5. It uses the full data redaction method.

  6. It uses the random redaction method.

Answer: A,C Explanation:

http://docs.oracle.com/database/121/ASOAG/redaction_config.htm#ASOAG10552 http://docs.oracle.com/database/121/ASOAG/redaction_config.htm#ASOAG817

Question No: 54

You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?

  1. You can drop the PDB only if it is closed.

  2. You can drop the seed PDB, but you cannot create any other PDB within the CDB.

  3. You can drop the PDB and keep the data files to be reused by another PDB.

  4. When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.

Answer: A,C Explanation:

https://docs.oracle.com/database/121/SQLRF/statements_8028.htm#SQLRF55699

Question No: 55

Your customer is looking for a solution that meets these four needs:

1 – Replicate data from source to target for reporting purposes. 2 -Replicate data from one source to multiple targets.

  1. – Replicate data between two databases for instant failover.

  2. – Replicate data from multiple sources to a single target for a data warehouse. Which GoldenGate-supported topology would you recommended?

  1. Uni-directional for 1 Peer-to-peer for 2

    Bi-directional for 3

    Consolidation for 4

  2. Peer-to-peer for 1 Broadcast for 2

    Bi-directional for 3

    Consolidation for 4

  3. Uni-directional for 1 Broadcast for 2

    Bi-directional for 3

    Consolidation for 4

  4. Peer-to-peer for 1 Consolidation for 2 Broadcast for 3 Cascading for 4

Answer: C

Question No: 56

Which two statements are true about transactions in Oracle Database 12c?

  1. Multiple transactions can use the same undo segment.

  2. A transaction is assigned an undo segment when it is started.

  3. Multiple transactions cannot share the same extent in an undo tablespace.

  4. If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.

Answer: A,B

Question No: 57

After a statement is issued, a transaction ends. (select three)

  1. COMMIT

  2. ROLLBACK

  3. SAVEPOINT

  4. SELECT

  5. CREATE

Answer: A,B,E

Explanation: A transaction ends when any of the following actions occurs:

  • (AB) A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause.

  • (E) A user runs a DDL command such as CREATE, DROP, RENAME, or ALTER. Etc.

  • Reference: Oracle Database Concepts, 12c, End of a Transaction

    Question No: 58

    Which two statements about switchover and failover are true?

    1. A snapshot standby can be the target of a switchover or fast-start failover operation.

    2. Neither a switchover nor a failover is possible to a far sync instance.

    3. For fast-start failover, you must preselect the target standby database that will be used.

    4. You can activate a standby database to test whether it is being updated correctly.

    Answer: B,C

    Reference: http://www.oracle.com/technetwork/database/availability/farsync-2267608.pdf

    Question No: 59

    Which three events signal a database writer (DWR) to write buffers to disk?

    1. The database advances a checkpoint.

    2. A client process commits a transaction.

    3. The redo log buffer becomes full.

    4. A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

    5. A tablespace is changed to read-only status.

    6. The database is shut down in immediate mode.

    Answer: A,D,F

    Explanation: When tablespace is changed to read only status it will issue a Partial checkpoint. During db shutdown a checkpoint is also issued. DWR writes when there is a checkpoint.

    Question No: 60

    Which three operations can the PUBLIC user with the SYSOPER privilege perform?

    1. STARTUP

    2. SHUTDOWN

    3. CREATE DATABASE

    4. DROP DATABASE

    5. ALTER DATABASE RECOVER

    Answer: A,B,E

    Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28310/dba006.htm#ADMIN11049

    100% Ensurepass Free Download!
    Download Free Demo:1z0-497 Demo PDF
    100% Ensurepass Free Guaranteed!
    1z0-497 Dumps

    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

    Add a Comment

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.