Oracle Database 12c Essentials
Question No: 11
Which two are client-side components of Oracle Data Guard Broker?
Oracle Enterprise Manager Cloud Control
Oracle Data Guard monitor
Oracle Data Guard command-line interface (DGMGRL)
Oracle Data Guard Broker Manager
Question No: 12
Identify two types of solutions in which you would need to use Active Data Guard and Golden Gate together.
a solution that provides zero-data-loss protection at any distance without impacting database performance
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#39; an enterprise data warehouse
a solution requiring minimal planned downtime and risk, using standby first patching, database rolling upgrades, and select platform migrations
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)
Reference: http://www.oracle.com/technetwork/database/availability/active-data-guard-wp- 12c-1896127.pdf (page 16, last two bulleted points)
Question No: 13
Which command do you use to check for block corruption by validating the database?
RMANgt; VALIDATE CHECK LOGICAL
RMANgt; VALIDATE BACKUP
RMANgt; VALIDATE CORRUPT BLOCKS
RMANgt; VALIDATE DATABASE
Explanation: since 11g the syntax got changed to RMANgt; validate [check logical] database;
DGMGRLgt; validate database verbose d1
Block Corruptions found NO NO
Question No: 14
Which statement about the Queryable Patch inventory feature is false?
It is used to retrieve installed patch information from a SQL prompt.
It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.
DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.
It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.
Explanation: * New in Oracle 12c is queryable Opatch. Oracle offers a set of tables and a PL/SQL packages to query the Oracle Inventory.Prior to Oracle 12c, it was not easy to List Oracle patches. Now from Oracle 12c and beyond, you can use the DBMS_QOPATCH package to list all patches.
* Using DBMS_QOPATCH feature, users can do: Query what patches are installed from SQL*Plus.
Write wrapper programs to create reports and do validation checks across multiple environments.
Check patches installed on Oracle RAC nodes from a single location instead of having to log onto each one in turn.
Question No: 15
Which statement about Storage Snapshot Optimization is correct?
It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database.
It enables you to use RMAN to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.
It enables you to use RMAN to take a storage snapshot of your database. The database doesn#39;t have to be in BACKUP mode. You can then use the snapshot to recover all or part of the database.
It enables you to use third-party technologies to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.
Reference: http://docs.oracle.com/cd/E16655_01/backup.121/e17630/release_changes.htm#BRADV2 76 (new features, third bullet)
Question No: 16
Which targets can be managed by using Enterprise Manager Cloud Control?
Hosts and databases
Hosts, databases, and application servers
Application servers and web applications
Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)
Databases, application servers, and web applications
Hosts, databases, application servers, web applications, OMS, and OMR
Reference: http://www.oracle.com/technetwork/oem/framework-infra/wp-em12c-security- best-practicesv2-1493383.pdf (page 3, second bulleted point, last couple of sentences)
Question No: 17
Which two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?
select patch from vSoption where opatch_data=#39; 333333#39; ;
select xmltransform(dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual
select opatch from vSpatchsets where opatch_number = #39;333333#39;;
Question No: 18
Which two statements are true about the B-tree Index?
The leaf blocks in the index are doubly linked.
The leaf node stores a bitmap for each key value.
Rows with a NULL value in key columns also have entries in the Index.
The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.
Question No: 19
YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?
S sqlplus / as sysdba SQLgt; restart;
S sqlplus / as sysdba SQLgt; startup immediate;
S rman target / RMANgt; Startup
S sqlplus / as sysdba SQLgt; startup open recover;
S srvctl start database -db SORACLE_SID
Explanation: The following command starts an instance, reads the initialization parameters from the default location, and then mounts and opens the database. (You can optionally specify a PFILE clause.)
If you know that media recovery is required, you can start an instance, mount a database to the instance, and have the recovery process automatically start by using the STARTUP command with the RECOVER clause:
STARTUP OPEN RECOVER
To start or stop your entire cluster database, that is, all of the instances and its enabled services, enter the following SRVCTL commands:
$ srvctl start database -db db_unique_name [-startoption start_options]
Question No: 20
Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?
The analyzed result is lost when the database instance is restarted.
It runs every 1 hour automatically.
It is shipped only with Oracle Enterprise Manager 12c.
It analyzes high CPU trend and identifies problems before they can threaten application performance.
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
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|