Oracle 1Z0-066 Exam Questions - 2018 Updated 1Z0-066 Dumps

1. 1Z0-066 Exam Questions (Oracle Database 12c: Data Guard Administrator Exam) Offered By Pass4leads.com Settled by Oracle Certified Professionals Why Choose Pass4Leads => 100% Updated Practice Material => Settled By Oracle Certified Professionals => 90 Days Free Updates => PDF Practice Questions => Online Practice Test Software => No Need Any Installation => 90 Days Free Updates => 100% Money Back Guarantee

2. Version: 8.0 Question 1 Which two statements are true for Data Guard environments with mult-tenant databases? A. DB_UNIQUE_NAME must be specifed diferentll for each pluggable database within a mult-tenant standbl database. B. Each pluggable database within a mult-tenant phlsical standbl database has a minimum of one associated Oracle Net service name. C. Each pluggable database within a mult-tenant phlsical standbl has one MRP background process running during redo appll. D. A pluggable database within a mult-tenant standbl database can have a diferent open mode than the container database E. A pluggable database within a mult-tenant standbl database can have a diferent database role than the container database. Aoswern A, D Question 2 Your Data Guard environment has two remote phlsical standbl databases Client applicatons use the local naming method to connect to the primarl database instance. You want applicatons to automatcalll connect to the new primarl database instance in case of a switchover or a failover Which will fulfll this requirement? A. Create a database service on each standbl database that is started automatcalll bl a trigger, when the database rote is PRIMARY, modifl the connecton descripton used bl client applicatons to include all the standbl hosts and connect to the database instance using that service name. B. Create a database service on the primarl database that is started automatcalll bl a trigger, when the database role is PRIMARY, modifl the connecton descriptors used bl client applicatons to include all the standbl hosts and connect to the database instance using that service name. C. Set the INSTANCE_NAME parameter identcalll on all databases; modifl the connecton descriptor on client applicatons to include all the standbl hosts and connect to the database instance using that service name. D. Set the DB_NAME and DB_UNIQUE_NAME identcal on all databases, modifl the connecton descriptors on client applicatons to include all the standbl hosts and connect to the database using that service name. Aoswern A Question 3 Examine the Data Guard confguratono

3. DGMGRL > show confguraton; Confguraton-Animals Protecton Mode MaxPerformance Databases dogs-Primarl database sheep-Snapshot standbl database cats-Snapshot standbl database Fast-Start Failovero DISABLED Confguraton Statuso SUCCESS You receive an error while atemptng to raise the protecton mode to Maximum Availabilitlo DGMGDRL> edit confguraton set protecton mode as max availabilitl; Error ORA-16627 operaton disallowed since no standbl databases would remain to support protecton mode Failed. Identfl two statements that lou can execute, either one of which will enable successful raising of the protecton mode to Maximum Availabilitl. A. DGMGRL> convert database sheep to phlsical standbl; B. DGMGRL> convert database cats to phlsical standbl; C. DGMGRL> edit database dogs set propertl LogXptMode= fastslnc; D. DGMGRL> edit database sheep set propertl LogXptMode= fastslnc; E. DGMGRL> edit database cats set propertl LogXptMode= slnc; Aoswern B, E Question 4 You administer a Data Guard environment with a primarl and two phlsical standbl databases. One of the phlsical standbl databases is used for reportng and is on the same host as the primarl database. The other phlsical standbl database is remote, used for disaster recoverl and REDO is routed to it via a far slnc instance. Backups are ofoaded to the remote phlsical standbl. Which three are true concerning the management of archive logs in this Data Guard confguraton? A. Archive logs on the primarl database mal be deleted once thel are applied on all standbl databases. B. Archive logs on the primarl database mal be deleted once thel are shipped on all standbl databases. C. The deleton policl for archive logs on the remote phlsical standbl should be set so that archived logs are deleted once thel backed up at least once on the remote phlsical standbl database. D. The deleton policl for archive logs on the remote phlsical standbl should be set so that archived logs are deleted once thel are applied on all standbl databases. E. Archive logs on the primarl database mal be deleted once thel are archived localll to disk. Aoswern A, D, E Question 5 Which two are prerequisites for confguring fashback database for Oracle 12c databases, in a Data Guard environment?

4. A. a fash recoverl area must be confgured B. The database must be in MOUNT state. C. The database must be in ARCHIVELOG mode. D. A far slnc instance must be confgured to fash back a standbl when the primarl has been fashed back. E. The Data Guard Broker must be used. Aoswern A, C Question 6 You are required to change the Data Guard Confguraton protecton mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control Which two are true about this change? A. If the primarl database cannot write its redo to at least one slnchronized standbl database, then the protecton level remains unchanged. B. The primarl database instance will remain up and running, if it cannot write redo to at least one slnchronized standbl database. C. Transactons will not commit untl all redo data needed to recover those transactons are writen to the online redo log, and to the standbl redo log on at least one slnchronizes standbl database. D. Fast start failover can be enabled when making the chance. E. Real tme appll will be automatcalll turned on. Aoswern BC Question 7 Which four database parameters might be afected bl or infuence the creaton of standbl databases? A. DB_NAME B. ARCHIVE_LAG_TARGET C. COMPATIBLE D. DB_FILE_NAME_CONVERT E. DB_UNIQUE_NAME F. FAL_SERVER G. STANDBY_ARCH1VE_DEST Aoswern A, D, E, F Question 8 Your Data Guard environment has one phlsical standbl database using Real-Time Querl. Two sentences have been created bl these SQL statementso create sequence a global; create sequence b session;

5. Neither sequence has been used since being created Session 1 connects to the primarl database instance and issues these two SQL statementso SELECT a.nextval FROM DUAL; SELECT b nextval FROM DUAL; Then session 2 connects to the phlsical standbl database instance and issues the same SQL statements. What output will be seen for session 2? A. Opton A B. Opton B C. Opton C D. Opton D Aoswern C Question 9 You must propose an Oracle Data Guard confguraton tor a database supportng an OLTP workload that meets these permanent requirementso 1. Data loss is not permited. 2. Read-onll applicatons should not connect to the primarl database instance. Additonalll, there are these requirements, onll one of which is ever done at anl one tmeo 3. It should be possible to appll and test designated patches with a minimum amount of downtme. 4. Upgrading to a new database release should be performed with the least possible amount of downtme. 5. New applicaton sofware releases should be tested against an exact up-to-date replica of the producton database. You propose a primarl database with one phlsical standbl database confgured in Maximum Protecton mode. Which requirements do lou meet?

6. A. 2,3, 4, and 5 B. 1,2, 3,4, and 5 C. 1 and 2 D. onll requirement 5 E. onll requirement 1 Aoswern C Question 10 You must confgure an Oracle Data Guard environment consistng ofo 1. A primarl database 2 Three Phlsical Standbl Databases You must meet these requirementso A designated phlsical standbl database should become the primarl database automatcalll whenever the primarl database falls The chosen protecton mode should provide the highest level of protecton possible without violatng the other requirement Which redo transport mode and protecton mode would lou confgure to meet these requirements? A. SYNC NOAFFRIM and Maximum Protecton B. SYNC NOAFFIRM and Maximum Availabilitl C. ASYNC and Maximum Performance D. SYNC AFFIRM and Maximum Availabilitl E. SYNC AFFIRM and Maximum Protecton Aoswern D