SIMULATION
A. Option A B. Option B C. Option C D. Option D E. Option E
A. Option A B. Option B C. Option C D. Option D E. Option E
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…
You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside In PDB1, but not in the root? A. shared UNDO and default database temporary tablespace B. Oracle-supplied…
Which two statements are true when you execute an invoker’s rights procedure? A. The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege. B. Invoking users can control who can access…
Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility? A. db_name B. maxdatafiles C. control_files D. instance_name
Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables? A. the CDB as the ROOT user B. the CDB as the CDBADMIN user C. the PDB…
Which statement about a server parameter file (SPFILE) is false? A. An SPFILE is a binary file that cannot be edited by using a text editor. B. You can create an SPFILE from an existing text initialization parameter file or…
Which statement about the Queryable Patch inventory feature is false? A. It is used to retrieve installed patch information from a SQL prompt. B. It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent…
Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c? a – Shut down the database. b – Restart the database. c – Copy an…
Your database is open and the listener is running. The DBA stops the listener by using the command: LSNRCTL> STOP What happens to the sessions that are currently connected to the database instance? A. They can perform only queries. B.…