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

Oracle 1Z0-931-21 Online Questions & Answers

• Question 1:

  While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

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

• Question 2:

  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 3:

  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 4:

  The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

  A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
  B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
  C. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
  D. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
  C. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

  ---

  Explanation: https://docs.oracle.com/en/cloud/paas/autonomous- database/atpfg/components.html#GUID-268B36E1-87D8-4649-A370-226E2AE3FC5C

• Question 5:

  In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?

  A. Oracle Machine Learning notebook
  B. Compartment quotas
  C. Resource Manager settings
  D. SQL Developer Web Console
  B. Compartment quotas

  ---

  https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm

  

• Question 6:

  Which two statements are true about accessing Autonomous Database Tools?

  A. Access to Database Actions is available for all users of Autonomous Database.
  B. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
  C. SQL Developer Web is available exclusively on the Autonomous Database.
  D. Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpointnetworking.
  E. Oracle APEX can be accessed only from the Developer menu in the Service Console.
  D. Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpointnetworking.
  E. Oracle APEX can be accessed only from the Developer menu in the Service Console.

• Question 7:

  You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:

  Autonomous Transaction Processing License Included Shared Infrastructure

  Which parameter would you NOT use?

  A. db-workload
  B. is-dedicated
  C. db-type
  D. license-model
  B. is-dedicated

  ---

  https://docs.oracle.com/en-us/iaas/tools/oci- cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html

• Question 8:

  You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.

  What statement describes the step to provide the developer a newworkspace in APEX?

  A. Create an IDCS user with the APEX role.
  B. Access the APEX Administration Services and create the workspace for the developer.
  C. Create a new developer account.
  D. Create a database user with the APEX role.
  B. Access the APEX Administration Services and create the workspace for the developer.

  ---

  https://docs.oracle.com/en/database/oracle/application- express/19.1/htmig/creating-workspace-and-adding-Oracle-AE-users.html#GUID- 1040F145-452A-49D4-BCF6-A80851AFFA74 Create a New Instance Administrator Login to the INTERNAL workspace as the ADMIN user, or another existing admin user. Click the "Create User" link on the right-hand menu. For anew admin user enter mandatory items and the following. Workspace : INTERNAL Default Schema : APEX_180200 {or whatever the highest version is} User is an administrator: Yes Account Availability : Unlocked Password and Confirmation Password. Require Changeof Password on First Use : Yes Click the "Create User" button.

  https://oracle-base.com/articles/misc/apex-tips-basic-apex-management

• Question 9:

  Whichstatement is FALSE about Oracle Data Safe?

  A. It supports only Autonomous Databases.
  B. It helps you assess the security of your cloud database configurations by analyzing database configurations.
  C. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.
  D. It evaluates user types, how users are authenticated, and the password policies assigned to each user.
  E. It helps you evaluate risks to data, assess user security, monitor useractivity, and address data security compliance requirements.
  E. It helps you evaluate risks to data, assess user security, monitor useractivity, and address data security compliance requirements.

• Question 10:

  Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

  A. Backup and recovery must bedone using Recovery Manager(RMAN).
  B. Select the snapshot of the backup.
  C. Select the archived redo logs.
  D. Select the backup from which restore needs to be done.
  E. Specify the point in time (timestamp) to restore.
  D. Select the backup from which restore needs to be done.
  E. Specify the point in time (timestamp) to restore.

  ---

  In theRestore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup. https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkup- recover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C