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

Oracle 1Z0-931-25 Online Questions & Answers

• Question 91:

  What is the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

  A. Only ATP manages optimizer statistics.
  B. Only ADW supports autoscaling
  C. Only ADW uses columnar compression by default.
  D. Only ATP supports automatic backups.
  C. Only ADW uses columnar compression by default.

• Question 92:

  Which subset of services is offered via OCI-CLI (Command Line Interface) for Autonomous Database (ADB) via calls made to the OCI APIs?

  A. Start, Delete, Update, Query, Stop
  B. Create, Get, List, Stop, Restore
  C. Create, Query, Update, List, Start
  D. Create, Query, List, Stop, Restore
  B. Create, Get, List, Stop, Restore

• Question 93:

  Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

  A. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
  B. The source files can reside in Oracle Object Storage, Amazon S3 Object Storage, or Azure Blob Storage.
  C. The target table will be created in Autonomous Database if it does not already exist.
  D. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
  E. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
  B. The source files can reside in Oracle Object Storage, Amazon S3 Object Storage, or Azure Blob Storage.
  E. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

• Question 94:

  Which statement is true when you provision an Autonomous Database using the cloning method?

  A. A clone database source can be a running database instance.
  B. There is only one type of cloning option available in Autonomous Database.
  C. A clone database source can be from a point-in-time backup that is less than 2 hours old.
  D. You can clone a database in a security zone to create a database that isn't in a security zone.
  A. A clone database source can be a running database instance.

• Question 95:

  Which two actions can be performed when an Autonomous Database is stopped? (Choose two.)

  A. Change administrator password
  B. Start
  C. Update License type
  D. Update Network Access
  B. Start
  C. Update License type

• Question 96:

  DBSRV1 is an Autonomous Database with the display name PRODDB. You plan to take manual backups of this database periodically. What must be the name of the bucket that will be used to store manual backups?

  A. backup_proddb
  B. BACKUP_PRODDB
  C. backup_dbsrv1
  D. BACKUP_DBSRV1
  D. BACKUP_DBSRV1

• Question 97:

  A Business Analyst joined your organization and wants to explore the database tools. Whenrestoring or cloning an Autonomous Database (ADB), you must select a backup that is at least how old?

  A. 24 hours
  B. 5 minutes
  C. 2 hours
  D. 1 day
  A. 24 hours

• Question 98:

  Which of the following two statements regarding Data Transforms are correct? (Choose two.)

  A. Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition
  B. Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows
  C. Workflows for Data Transforms are only available on the ODI Web Edition
  D. All capabilities to transform data in ODI Classic are available with ODI Web Edition
  B. Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows
  D. All capabilities to transform data in ODI Classic are available with ODI Web Edition

• Question 99:

  You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling? (Choose two.)

  A. Click Scale Up/Down and select the Auto Scaling checkbox.
  B. Shut down the instance, click Scale Up/Down and select the Auto Scaling checkbox, then restart the instance.
  C. Use a REST call to enable Auto Scaling.
  D. Use a REST call to shut down the instance, then a second REST call to enable Auto Scaling, and a REST call to restart the instance.
  A. Click Scale Up/Down and select the Auto Scaling checkbox.
  C. Use a REST call to enable Auto Scaling.

• Question 100:

  Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure? (Choose three.)

  A. RMAN
  B. Logs
  C. Enterprise Manager Cloud Control
  D. OCI Metrics
  E. Performance Hub
  C. Enterprise Manager Cloud Control
  D. OCI Metrics
  E. Performance Hub