Which three statements are true about the SQL*Loader utility?
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.Which two actions would you take for tape streaming to happen during the backup?
You are administering a multitenant container database (CDB) cdb1.Examine the command and its output:SQL>show parameterfile -NAMETYPEVALUE ------------------------------------------------------------------------ db_create_file_deststring db_file_name_convertstring db_filesinteger200You verify that sufficient disk space is available and that no file currently exists in the /u0l/app/oracle/oradata/ cdb1/salesdb' location.You plan to create a new pluggable database (PDB) by using the command:SQL>CREATEPLUGGABLEDATABASESALESPDBADMINUSERsalesadmIDENTIFIED 3Y passwordROLES=(dba)DEFAULTTABLESPACEsales -DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbfSIZE 250M AUTOEXTEND ONFILE_NAME_CONVERT=(/u01/app/oracle/oradata/cdb1/pdbseed/','/u01/app/oracle/oradata/cdb1/salesdb/')STORAGE(MAXSIZE2G)PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';Which statement is true?
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).The following are the possible steps to accomplish this task:1. Place all the user-defined tablespace in read-only mode on the source database.2. Upgrade the source database to a 12c version.3. Create a new PDB in the target container database.4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.5. Copy the associated data files and export the dump file to the desired location in the target database.6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.Identify the correct order of the required steps.
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.What is the easiest way to perform capacity planning for consolidation?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
