Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-066

Oracle 1z0-066 Exam Practice Questions (P. 4)

  • Full Access (112 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #16
Which four factors can influence the rate of SQL apply on a logical standby database?
  1. A
    the size of the undo tablespace on the logical standby database
  2. B
    the number of full table scans performed by SQL apply
  3. C
    the number of coordinator processes on the standby database instance
  4. D
    the size of the shared pool
  5. E
    the number of APPLIER processes
  6. F
    the number of PREPARER processes

Correct Answer:
BDEF
B: If a table still does not have any unique index specified on the logical standby database, this may cause UPDATE statements to do full table scans on the logical standby database. You can remedy that by adding a unique index on the a column on the logical standby database.
E: SQL Apply uses a collection of background processes to apply changes from the primary database to the logical standby database.
During apply processing:
* The ANALYZER process identifies dependencies between different transactions.
* The COORDINATOR process (LSP) assigns transactions to different appliers and coordinates among them to ensure that dependencies between transactions are honored.
* The APPLIER processes applies transactions to the logical standby database under the supervision of the coordinator process.
F: The PREPARER process is used during the log mining process, which is part of the SQL apply process.
D: The Shared Pool is used by the preparar and Builder proccesses.

Figure: SQL Apply Processing -

Incorrect Answers:
C: There is only one coordinator process.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ls.htm

Question #17
Which two are true about database roles in an Oracle Data Guard Configuration?
  1. A
    A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
  2. B
    A Logical Standby Database can be converted to a Snapshot Standby Database.
  3. C
    A Logical Standby Database can cascade redo to a terminal destination.
  4. D
    A Snapshot Standby Database can be a fast-start failover target.
  5. E
    A Physical Standby Database can be converted into a Logical Standby Database.

Correct Answer:
BE
B: A snapshot standby database can be converted back into a physical standby database at any time.
E: You create a logical standby database by first creating a physical standby database and then transitioning it to a logical standby database.
Incorrect Answers:
A: Oracle Database supports the installation of database software upgrades, and the application of patch sets, in a rolling fashionwith near zero database downtimeby using Data Guard SQL Apply and logical standby databases.
C: A cascaded redo transport destination (also known as a terminal destination) receives primary database redo indirectly from a standby database rather than directly from a primary database. Only physical standby databases can cascade redo.
D: A snapshot standby cannot be the target of a switchover or fast-start failover operation.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e41134/create_ls.htm#SBYDB4732 https://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ps.htm#SBYDB00580

Question #18
There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database.
The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12.
Identify two changes, each of which would allow you to increase the number of APPLIER processes.
  1. A
    Increase the PROCESSES initialization parameter
  2. B
    Increase the value for the MAX_SERVERS SQL apply parameter.
  3. C
    Decrease the number of archiver processes on the standby database.
  4. D
    Increase the PARALLEL_MAX_SERVER initialization parameter
  5. E
    Decrease the number of PREPARER processes
  6. F
    Increase the RECOVERY_PARALLELISM initialization parameter

Correct Answer:
BE
There are three parameters that can be modified to control the number of processes allocated to SQL Apply: MAX_SERVERS, APPLY_SERVERS, and
PREPARE_SERVERS. The following relationships must always hold true:
APPLY_SERVERS + PREPARE_SERVERS = MAX_SERVERS - 3
This is because SQL Apply always allocates one process for the READER, BUILDER, and ANALYZER roles.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ls.htm

Question #19
Which three statements are true about snapshot standby databases?
  1. A
    Snapshot standby databases may be used for rolling release upgrades.
  2. B
    If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
  3. C
    Flashback logs are used to convert a snapshot standby database back into a physical standby database.
  4. D
    A snapshot standby database can have Real-Time Query enabled.
  5. E
    A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Correct Answer:
CE
C: Flashback Database is similar to conventional point-in-time recovery in its effects. It enables you to return a database to its state at a time in the recent past.
Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery area. You can only use Flashback Database if flashback logs are available. Flashback Database is used to convert a snapshot standby database back into a physical standby database.
E: When we convert the physical standby database to snapshot standby database a guaranteed restore point is created. This guaranteed restore point is used to flashback a snapshot standby database to its original state.
Incorrect Answers:
A: Oracle Database supports the installation of database software upgrades, and the application of patch sets, in a rolling fashionwith near zero database downtimeby using Data Guard SQL Apply and logical standby databases.
References:

https://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ps.htm#SBYDB4803 http://satya-dba.blogspot.se/2012/06/snapshot-standby-databases-oracle.html

Question #20
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?
  1. A
    If the CACHE option is set then the size of the cache must be at least 100.
  2. B
    Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary.
  3. C
    Their usage will always have a performance impact on the primary database.
  4. D
    Their usage may have a performance impact on the physical standby database if the CACHE size is too small
  5. E
    They must have the NOORDER and CACHE options set.

Correct Answer:
BDE
B: the terminal standby should have a LOG_ARCHIVE_DEST_n parameter defined that points back to the primary.
D: Because the standby's requests for a range of sequences involve a round-trip to the primary, be sure to specify a large enough value for the CACHE keyword when you create a sequence that will be used on an Oracle Active Data Guard standby. Otherwise, performance could suffer.
E: In an Oracle Active Data Guard environment, sequences created by the primary database with the default CACHE and NOORDER options can be accessed from standby databases as well.
References:
https://docs.oracle.com/database/121/SBYDB/manage_ps.htm#SBYDB5164

Previous Questions Next Questions

All Pages