Oracle 1Z0-931-21 Online Practice Questions and Exam Preparation

Oracle 1Z0-931-21 Online Questions & Answers

• Question 61:

  Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

  A. Use SFTP to copy CSV files into Autonomous Database
  B. Use Oracle Zero Downtime Migration (ZDM)
  C. Use Recovery Manager (RMAN)
  D. Use GoldenGate
  E. Use Data Pump
  B. Use Oracle Zero Downtime Migration (ZDM)
  D. Use GoldenGate
  E. Use Data Pump

  ---

  https://www.oracle.com/sa/database/technologies/cloud-migration.html

  

• Question 62:

  Which four file formats are supported when loading data from Cloud Storage?

  A. DOC
  B. AVRO
  C. JSON
  D. DDL
  E. Dcsv
  F. Parquet
  B. AVRO
  C. JSON
  E. Dcsv
  F. Parquet

• Question 63:

  When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

  A. The SQL statement completed its execution.
  B. The SQL statement is executing.
  C. TheSQL statement is queued.
  D. The SQL statement did not complete either due to an error.
  C. TheSQL statement is queued.

  ---

  https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm

  

• Question 64:

  Which statement is correct about managing and monitoring of Autonomous Database?

  A. You can use Service console to move Autonomous DB between compartments.
  B. You can use Service console to create manual backups of Autonomous database.
  C. You can use Service console to enable or disable auto scaling of Autonomous DB.
  D. You can use Service console to manage runaway SQL statements on Autonomous DB.
  D. You can use Service console to manage runaway SQL statements on Autonomous DB.

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/manage-sql-statements.html#GUID-4861BA7F-F9FA-4909-8DC0- 4F46AFF80706

• Question 65:

  A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run onthe OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.

  Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

  A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
  B. ADW since operational reporting is a higher priority in this scenario.
  C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
  D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
  D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

  ---

  Autonomous Transaction Processing provides all of theperformance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store.

  As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.

• Question 66:

  What happened with the standby database when disabling Autonomous Data Guard?

  A. The standby database is started readwrite
  B. The standby database is transformed in a refreshable clone
  C. The standby database is terminated
  D. Thestandby database is started read only
  C. The standby database is terminated

• Question 67:

  When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?(Choose the best answer.)

  A. DBNAME_MEDIUM
  B. DBNAME_HIGH
  C. DBNAME_CONCURRENT
  D. DBNAME_LOW
  D. DBNAME_LOW

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage- priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7 https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID- 80E464A7-8ED4-45BB-A7D6-E201DD4107B7

• Question 68:

  Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

  A. Parallelism is not enabled by default.
  B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
  C. Oracle Database Result Cache is enabled by default for all SQL statements.
  D. You have direct access tothe database node.
  B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
  C. Oracle Database Result Cache is enabled by default for all SQL statements.

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/appendix-autonomous-database-data-warehouse-workload.html#GUID- 604A08F8-8021-43CE-AA95-823045E14BD8

  

• Question 69:

  Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production. How should the customer unplug their database to migrate to Autonomous Database (ADB)?

  A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
  B. Create a database link from source databaseto the ADB environment and clone the PDB.
  C. Unplug to an xml file so database files and xml file can be uploaded to object storage.
  D. Unplug into a pdb archive which can be uploaded to object storage.
  A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.

  ---

  Since an ADB database hassome restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.

  The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB usingData Pump. To sync up the additional/incremental changes on the source database during the export/import process

  you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.

  In the current release you cannot use physical migrationmethods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.

• Question 70:

  Whenyou are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?

  A. 2 hours
  B. 30 minutes
  C. 1 hours
  D. 24 hours
  A. 2 hours

  ---

  Clone Sources You can use a running database to create a clone. For databases running on shared Exadata infrastructure, you can also use a backup as the source of your clone. When using a backup, you can select a listed backup to clone from, or create a point-in-time clone. Point-in-time clones contain all data up to a specified timestamp. The specified timestamp must be in the past. NoteWhen you create a clone from a backup, you must select a backup that is at least two hours old. https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbcloning.htm