Online Access Free 1Z1-931 Practice Test

In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

• A.In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
• B.In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.
• C.In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.
• D.In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.

When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

• A.OCPUs and storage must remain in sync.
• B.Increasing OCPUs will automatically increase storage.
• C.Storage in TB cannot be larger than the number of OCPUs.
• D.OCPUs and storage can be scaled independently.

Which procedure within the DBMS_CLOUD package is used to load data?

• A.LIST_FILES
• B.LOAD_DATA
• C.COPY_DATA
• D.CREATE_EXTERNAL_TABLE
• E.PUT_OBJECT

Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

• A.Data Pump
• B.Physical migration method like database cloning
• C.RMAN backup & restore
• D.Original Import/Export tools

How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

• A.Three. They are called high, medium and low.
• B.None. There are no pre-defined service names in tnsnames.ora.
• C.Five. They are called tpurgent, tp, high, medium and low.
• D.Two. They are called ATP and ADW.