Examine the commands:SQL> ALTER SESSION SET RECYCLBIN = ON;Session altered.SQL> DROP TABLE emp; --(First EMP table)Total dropped.SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );Table created.You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:SQL> DROP TABLE emp; -- (Second EMP table)Table dropped.SQL> FLASHBACK TABLE emp TO BEFORE DROP;Which statement is true about the FLASHBACK command?
Which three statements are true about the keystore storage framework for transparent data encryption?
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following: i.Long-running queries are not affected. ii.No extra space is used. iii.Data manipulation language (DML) operations on the table succeed at all times throughout the process. iv.Unused space is reclaimed both above and below the high water mark.Which alter TABLE option would you recommend?
You have a production Oracle 12c database running on a host.You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.The steps in random order:1.Create directory structures similar to the production database on all new machines.2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.3.Create a database clone template for the database.4.Run the Database Configuration Assistant (DBCA) to create the database.5.Run OUI in graphical mode on each machine.6.Run OUI in silent mode using the OUI response file.Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.
For which two requirements would you use the Database Resource Manager?
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:SQL> CREATE USER c##a_admin -IDENTIFIED BY password -DEFAULT TABLESPACE users -QUOTA I00M ON users -TEMPORARY TABLESPACE temp;Which statement is true about the execution of the command?
