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: 71

Which statement regarding Oracle Active Data Guard 12c is false?

  1. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.

  2. It provides new support for DML to global temporary tables and the use of sequences in the standby database.

  3. It repairs block corruptions detected in the primary or standby database.

  4. It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.

  5. It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.

Answer: E

Question No: 72

Which three statements represent the benefits of multitenant architecture for database consolidation?

  1. You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.

  2. You can consolidate shared database memory by combining multiple PDBs in a single CDB.

  3. Patching individual PDBs requires the same amount of time as patching individual databases.

  4. Consolidating separate databases into a single CDB requires the same amount of storage allocation.

  5. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.

Answer: A,B,E

Explanation: By design, you can quickly plug a PDB into a CDB, unplug the PDB from the CDB, and then plug this PDB into a different CDB. The implementation technique for plugging and unplugging is similar to the transportable tablespace technique.

A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.

Reference: Benefits of the Multitenant Architecture for Database Consolidation URL:

http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239

Question No: 73

Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from

location A to location B. which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read-write mode, while synchronizing with the primary database.

Which two solutions would you recommend to your customer?

  1. Oracle GoldenGate

  2. Oracle Advanced Replication

  3. Oracle Active Data Guard

  4. Oracle Streams

Answer: A,C

Question No: 74

Identify three key properties of a transaction in Oracle Database 12c.

  1. durability

  2. consistency

  3. concurrency

  4. isolation

  5. scalability

  6. manageability

Answer: A,B,D

Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17633/transact.htm#CNCPT016

Question No: 75

What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?

  1. SYSBKP

  2. SYSBKPRMAN

  3. SYSRMAN

  4. SYSBACKUP

Answer: D

Reference: http://docs.oracle.com/cd/E16655_01/backup.121/e17631/release_changes.htm#RCMRF9 0521 (sys backup privilege)

Question No: 76

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

  1. You can perform complete recovery by using the command: RESTORE DATABASE

    FROM TAG”consistent_whole_backup”; RECOVER DATABASE;

  2. You can perform incomplete recovery by using the command: RESTORE DATABASE;

    FROM TAG quot;consistent_whole_backupquot;; RECOVER DATABASE NOREDO;

  3. Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.

  4. Media recovery is possible in most cases.

Answer: B,C

Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmrecov.htm#CACGEAEE

Question No: 77

A DBA informs you that an Oracle instance has started. What does this imply?

  1. Users can access the data in the database.

  2. Only SGA has been allocated for the database.

  3. Only background and user processes are running.

  4. Memory areas have been allocated and background processes have been started.

Answer: D

Question No: 78

Which two statements about Automatic Data Optimization (ADO) are true?

  1. ADO policies can automatically compress data when it qualifies.

  2. ADO policies can automatically move segments when necessary.

  3. ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

  4. You cannot compress at block level, but you can compress at segment level.

  5. You can compress at row level only for QUERY LOW.

Answer: A,B Explanation:

http://www.oracle.com/technetwork/database/options/compression/advanced-compression- wp-12c-1896128.pdf

Question No: 79

A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?

  1. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword

  2. ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements

  3. ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword

  4. D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements

Answer: A

Question No: 80

Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.

  1. less instance overhead

  2. increased storage cost

  3. minor application changes

  4. fast and easy provisioning

  5. same time needed for patching and upgrade as in the previous release

  6. isolation

Answer: A,D,F

100% Ensurepass Free Download!
Download Free Demo:1z0-497 Demo PDF
100% Ensurepass Free 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