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

Oracle 1Z0-931-20 Online Questions & Answers

• Question 1:

  What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? (Choose two.)

  A. Users have OS access to the database machine.
  B. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
  C. Users can customize the OS stack and add additional packages.
  D. Users have SYS privileges in the database.
  E. Users can customize the maintenance schedule.
  B. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
  D. Users have SYS privileges in the database.

• Question 2:

  What are three methods to load data into the Autonomous Database? (Choose three.)

  A. Oracle GoldenGate
  B. Oracle Data Pump
  C. RMAN Restore
  D. Transportable Tablespace
  E. SQL*Loader
  A. Oracle GoldenGate
  B. Oracle Data Pump
  E. SQL*Loader

• Question 3:

  Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? (Choose two.)

  A. You have direct access to the 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.
  D. 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.

• Question 4:

  Which two statements are true about using an Autonomous Database with Private Endpoints? (Choose two.)

  A. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
  B. You can configure Private Endpoints for an Always Free Autonomous Database.
  C. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints.
  D. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.
  C. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints.
  D. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.

• Question 5:

  Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.

  Which statement is FALSE regarding the auto scaling feature? (Choose the best answer.)

  A. The base number of OCPU cores allocated to a database is not guaranteed.
  B. Auto scaling is enabled by default and can be enabled or disabled at any time.
  C. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands.
  D. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.
  A. The base number of OCPU cores allocated to a database is not guaranteed.

• Question 6:

  Which management operation is correct about Autonomous Databases on shared Exadata infrastructure? (Choose the best answer.)

  A. You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.
  B. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
  C. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
  D. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.
  A. You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.

• Question 7:

  What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments? (Choose the best answer.)

  A. Fleet Administrators are responsible for patching and backups of all container databases.
  B. Fleet Administrators create, monitor and manage Autonomous Databases.
  C. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
  D. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
  C. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.

• Question 8:

  Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.

  Which statement is FALSE? (Choose the best answer.)

  A. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
  B. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
  C. Oracle Data Safe only supports Autonomous Databases.
  D. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
  C. Oracle Data Safe only supports Autonomous Databases.

• Question 9:

  Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment? (Choose the best answer.)

  A. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
  B. Moving an Autonomous Database instance does not include its automatic backups.
  C. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.
  D. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
  C. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.

• Question 10:

  Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls? (Choose the best answer.)

  A. SSH keys are not required in Oracle Cloud Infrastructure.
  B. SSH keys cannot be added from console. They have to be added using REST APIs only.
  C. On the Autonomous Database Console.
  D. Navigate to Identity, select Users panel on the console and select "Add Public Key".
  D. Navigate to Identity, select Users panel on the console and select "Add Public Key".