Questions and Answers PDF 102 /170 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?
Questions and Answers PDF 104 /170 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?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
