Question 26
Examine the procedure that you plan to execute on your logical standby:
SQL> EXECUTE DBMS_LOGSTDBY.SKIP(stmt => 'DML', schema_name => 'HR', object_name => 'EMPLOYEE'); What is a prerequisite for execution of this procedure?
SQL> EXECUTE DBMS_LOGSTDBY.SKIP(stmt => 'DML', schema_name => 'HR', object_name => 'EMPLOYEE'); What is a prerequisite for execution of this procedure?
Question 27
Suppose that you manage the following databases in your environment:
* boston: Primary database with a single PDB called DEVI
* london: Physical standby database protecting the PDB called DEVI
* orcl: Stand-alone database with a single PDB called PDB1 as a remote clone source You are planning to run the following command to create a remote clone in the primary database (boston) using pdbi in orcl:
Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (london)?
* boston: Primary database with a single PDB called DEVI
* london: Physical standby database protecting the PDB called DEVI
* orcl: Stand-alone database with a single PDB called PDB1 as a remote clone source You are planning to run the following command to create a remote clone in the primary database (boston) using pdbi in orcl:
Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (london)?
Question 28
On your logical standby database, you specified these rules:
After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:
Which is TRUE regarding the execution of the UNSKIP procedure?
After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:
Which is TRUE regarding the execution of the UNSKIP procedure?
Question 29
Which TWO statements are true about Real-Time Query?
Question 30
Which TWO statements correctly describe the behavior of Automatic Block Media Recovery in a Data Guard environment, for a corrupt block in the example tablespace encountered by a session logged in as the SH user?