Which two are prerequisites for setting up Flashback Data Archive?
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1.You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.NAMETYPEVALUE --------------------------------------------- ------------------- ------------------------------------------------ audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststringWhat is the location of the ADR base?
You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1PDB.Examine the list of possible steps required to perform the task:1.Create a PDB named emp_pdb1.2.Export the hr_pdb1 PDB by using the full clause.3.Open the emp_pdb1 PDB.4.Mount the emp_pdb1 PDB.5.Synchronize the emp_pdb1 PDB in restricted mode.6.Copy the dump file to the Data Pump directory.7.Create a Data Pump directory in the emp_pdb1 PDB.8.Import data into emp_pdb1 with the full and remap clauses.9.Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.Identify the required steps in the correct order.
You wish to create jobs to satisfy these requirements:1. Automatically bulk load data from a flat file.2.Rebuild indexes on the SALES table after completion of the bulk load.How would you create these jobs?
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.You create a common role c##role1 with the create table and select any table privileges.You then execute the commands:SQL> GRANTc##role1 TOcMadmin CONTAINER=ALL;SQL>CONNsys/oracle@HR_PDB assysdbaSQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;Which two statements are true?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
