You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema.After a few days, you want to alter the EMPLOYEES table by executing the command:SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);Which statement is true about the execution of the command?
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?
You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:Which two statements are true?
You create a new database by using the CREATE DATABASE command in SQL *Plus, with the ENABLE PLUGGABLE DATABASE clause specified.Which statement is true about the database that is created?
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.What must you do to make the database operational in OUSERVER1?
Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:1. Make the tablespace read-only at the source database.2. Export metadata from the source database.3. Import metadata into the target database.4. Transfer the dump file and data files to the target machine.5. Convert data files by using Recovery Manager (RMAN).6. Make the tablespace read-write at the target database.Identify the required steps in the correct order.
