Oracle 1Z0-1044 問題集

質問 1：
Which option represents valid functionalities/step in SQL Developer that is used for migrating on-premises databases to OCI DB Systems?
A. Create DDL Statements + MERGE statements to modify the imported data
B. Create Data Pump Dumpfiles that can be imported normally using that tool at destination
C. Create DDL Statements + SQL *Loader control and data files
D. Create Data Pump Dumpflles + SQL *Loader control and data files
正解：D

質問 2：
You have exported some table data using SQL Developer in INSERT format.
Which two are valid next steps in your migration to OCI?
A. Transfer the export file to the OCI DB system using SCP and execute it using Data Pump.
B. Transfer the export file to the OCI DB system using FTP and execute it using SQL *Plus.
C. Create a connection to the OCI DB using SQL Developer and run the SQL script using the tool.
D. Transfer the export file to the OCI DB system using SCP and execute it using SQL *Plus.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which predefined user is created when an ADB instance is created that you connect to in order to create other users and grant roles?
A. ADMIN
B. SCOTT
C. SYS
D. ADBDBA
正解：A

質問 4：
Autonomous Data warehouse and Autonomous Transaction Processing use the same Oracle Database.
Which statement is true about the workloads?
A. Autonomous Transaction Processing workloads are optimized for data warehouse, data marts, and data lakes.
B. Autonomous Data Warehouse leverages columnar data format.
C. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
D. Autonomous Data Warehouse workloads are optimi zed for mixed workloads.
正解：A,C

質問 5：
You want to set up an on-premises network connectivity to OCI. Which component Is NOT part of this configuration?
A. Routing Tables
B. Dynamic Routing Gateway
C. IPSec VPN Tunnel
D. VCN and Subnets
E. FastConnect Service
F. Service Gateway
G. Customer-premises equipment
正解：F

質問 6：
You have already created Exadata DB System with Oracle Grid Infrastructure 12c Release 1. You want to upgrade Orade Grid Infrastructure to Oracle 12c Release 2 of the Exadata Cloud Service.
Which two statements are true about ensuring a successful upgrade?
A. You cannot later use the self-service web interfaces to upgrade a version 12. 2 Database Deployment.
B. You must manually upgrade to Oracle Grid Infrastructure 12c R2
C. Your must manually upgrade to Oracle Grid lnfrastructure 12c R2 and use self-service web interface acces to create version 12.2 Database Deployment.
D. You can use the self-service web interfaces to upgrade a version 12.2 Database Deployment.
正解：C

質問 7：
Examine the steps:
1. Log in to OTN and download Oracle Database Backup Module.
2. Get the subscription for Oracle Database Backup Service.
3. Configure RMAN Settings.
4. Gather the values for the parameters required to run the installer.
5. Install Oracle Database Backup Module.
6. Perform backup of the database to the cloud.
7. Perform recovery whenever required.
Identify the steps, in correct order, to configure Oracle Database Backup Module.
A. 1,2,3,4,5,6,7
B. 2, 1,4, 5, 3, 6, 7
C. 2,1,3,4,5,6,7
D. 1,2,4,5,3,6,7
E. 2,1,4,5,3,6,7
正解：D

質問 8：
Which statement is true about using Autonomous Data Warehouse as a Data Mart?
A. Data marts are only populated by loading programs called ETL (extract, transform, and load).
B. Only an IT department can create a data mart.
C. Someone in the Line of Business can load a data mart with data from spreadsheets.
D. The Autonomous Data Warehouse cannot be used as a data mart.
正解：A