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

Oracle 1Z0-931-22 Online Questions & Answers

• Question 41:

  Which statement is true when the Autonomous Database has auto scaling enabled?

  A. Database concurrency is scaled up when needed by the workload.
  B. Increases the number of sessions available to the database.
  C. Scales the PGA and SGA size when needed for the workload.
  D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.
  D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

• Question 42:

  When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

  A. Under Core Infrastructure then Compute then Autonomous Exadata
  B. Under Solutionsand Platform then Platform Services then Autonomous Exadata
  C. Under Database then Autonomous Transaction Processing then Autonomous Exadata
  D. Under Core Infrastructure then Autonomous Exadata
  C. Under Database then Autonomous Transaction Processing then Autonomous Exadata

  ---

  https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory. Even though the UI has changed recently, this documentation has the user go to Menu-> Database

• Question 43:

  Which two actions are available to perform when an Autonomous Database is stopped?

  A. Start
  B. Update Network Access
  C. Change administrator password
  D. UpdateLicense Type
  A. Start
  D. UpdateLicense Type

• Question 44:

  Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

  A. Data Pump Export File
  B. Avro
  C. Parquet
  D. Text
  E. JSON
  F. Microsoft SQL Server (.mdf)
  F. Microsoft SQL Server (.mdf)

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/format- options.html#GUID-08C44CDA-7C81-481A-BA0A-F7346473B703

  mdf format is for MS SQL server database file

• Question 45:

  

  Which statement is true when connecting OCI Marketplace image to shared autonomous database?

  A. Compute Image and Shared ADB must be in same VCN and Subnet
  B. ADB must be configured with NSG
  C. ADB must be configured with Private endpoints
  D. Cannot connect OCI Market image to shared ADB
  A. Compute Image and Shared ADB must be in same VCN and Subnet

• Question 46:

  Which two are correct actions to take in order to Download the Autonomous Database Credentials?

  A. Click on the Autonomous Data Warehouse in the menu,click a database name, then Choose DB Connection button, then Download the Wallet.
  B. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
  C. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
  D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
  E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
  A. Click on the Autonomous Data Warehouse in the menu,click a database name, then Choose DB Connection button, then Download the Wallet.
  E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect- download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1

• Question 47:

  You are the admin user of an Autonomous Database (ADB) instance. A new business analysthas joined the team and would like to explore ADB tables using SQL Developer Web. What steps do you need to take?

  A. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
  B. Create a database user with the default privileges.
  C. Create a database user with connect, resource, and object privileges.
  D. Create an IDCS user. Create a database user with connect, resource, and object privileges.
  A. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect- database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586

• Question 48:

  Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

  A. Parallelism
  B. Storage
  C. Concurency
  D. Memory
  E. Sessions
  B. Storage

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A- 84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

  

• Question 49:

  Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database.

  A. 120
  B. 60
  C. 15
  D. 7
  A. 120

  ---

  Backup Retention If you choose to enable automatic backups, you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, or 60 days. The system automatically deletes your incremental backups at the end of your chosen retention period.

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

• Question 50:

  Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?

  A. Oracle Cloud Infrastructure Object Storage Classic
  B. Oracle Cloud Infrastructure Object Storage
  C. Google Cloud Storage
  D. Amazon S3
  E. Azure Blob Storage
  A. Oracle Cloud Infrastructure Object Storage Classic
  B. Oracle Cloud Infrastructure Object Storage