Free Oracle 1Z1-1044 Exam Dumps Questions & Answers

You used the "Stop" option from the Console of an Exadata Cloud Service instance.
What Impact does this have?

• A.  All the database servers and storage servers associated with the Exadata Cloud Service instance are stopped.
• B.  All the database servers associated with the Exadata Cloud Service instance are stopped.
• C.  The server is not available to any other database deployment that shares the same Exadata Cloud Service instance.
• D.  The Exadata Cloud Service Instance is stopped.

You are preparing to migrate a 12c non-CDB On-Premises DB using the "RMAN Transportable Tablespace with Data Pump method.
Which three of these step are mandatory?

• A.  You need to make sure source and destination character sets are compatible.
• B.  You have to create a DB System with same version as source DB or higher.
• C.  You must have your SSH keys ready before creating the OCI DB system.
  CJ You have to create a DB System with same version as source DB.
• D.  You must shut down the source database to take a cold backup before migration.

You are going to perform a 5-GB database migration from on-premises to OCI DB system. It includes some tables with LONG columns.
What is the best Data Pump method for this case?

• A.  There is no need to generate a dump file. You can use the NETWORK LINK method over the Internet, because that way you avoid transferring dump files.
• B.  Generate a dump file, transfer it using SCP, and import it in the destination OCI DB system .
• C.  Data Pump is not recommended in this case as the amount of data is too big.
• D.  There is no need to generate a dump file. You can use the NETWORK LINK method over an SSH tunnel, because that way you avoid transferring dump files and the data is secured too.

You want to move 10 GB of data from on-premises database to OCI DB System. The source DB has a few tables with column-level TDE encryption enabled.
What's the recommended method?

• A.  Data Pump Conventional Export/Import with password encryption
• B.  Data Pump Conventional Export/Import
• C.  Data Pump Transportable Tablespace
• D.  Data Pump Full Transportable

You decide to use the unplug/plug method to migrate a 12c non-CDB on-premises database to an 18c OCI DB Service. What is the correct sequence of steps?

• A.  Invoke DBMS_PDB.DESCRIBE in the destination , transfer XML and data files, create a destination PDB, execute noncdb_to_pdb. sql in the source, open the destinatipn PDB and invoke dbupgrade.
• B.  Perform a clean shutdown of source database, transfer the files, create a destination PDB and execute noncdb_to_pdb. sql in the destination CDB
• C.  Invoke DBMS_PDB. DESCRIBE in the source , transfer XML files and datafiles, create a destination PDB, execute noncdbto_pdb.sql in the destination, open the destination PDB and invoke dbupgrade.
• D.  Invoke DBMS_PDB.DESCRIBE in the source, create a destination PDB, execute noncdb_to_pdb.sql on the destination, and open the destination PDB.