Free Oracle 1z1-497 Exam Dumps Questions & Answers

Which two statements are true about listeners?

• A.  Listeners use only the TCP/IP protocol.
• B.  Multiple database instances can be registered with a single listener,
• C.  Multiple listener processes can run simultaneously on a host.
• D.  Only one database instance can be registered with a single listener at any time.
• E.  Listener-related errors can be traced only at the administrative level.

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

• A.  SYSBACKUP
• B.  SYSRMAN
• C.  SYSBKPRMAN
• D.  SYSBKP

Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?

• A.  operating system or storage device / driver failure
• B.  dropped database object
• C.  changing configuration parameters, upgrading, or patching Oracle software
• D.  table definition changes
• E.  adding table partitioning
• F.  migrating to cluster architecture
• G.  addition or removal of nodes, memory, or disks
• H.  file deletion
• I.  runaway processes that consume system resources
• J.  database or application deadlocks

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

• A.  Patching individual PDBs requires the same amount of time as patching individual databases.
• B.  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.
• C.  You can consolidate shared database memory by combining multiple PDBs in a single CD
• D.  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.
• E.  Consolidating separate databases into a single CDB requires the same amount of storage allocation.

Identify two types of solutions in which you would need to use Active Data Guard and Golden Gate together.

• A.  a solution that provides zero-data-loss protection at any distance without impacting database performance
• B.  a solution for disaster protection and database rolling upgrades for a mission-critical OLTP database, where you also want to extract data from a data guard primary database for ETL update o' an enterprise data warehouse
• C.  a solution requiring minimal planned downtime and risk, using standby first patching, database rolling upgrades, and select platform migrations
• D.  a solution that helps with integrated automatic database and client failover between source and target, where you also need to establish advanced replication (such as multi master and bidirectional replication and data transformations)