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

Oracle 1Z0-931-25 Online Questions & Answers

• Question 51:

  Which four levels of access can be defined in policies? (Choose four.)

  A. Create
  B. Read
  C. Manage
  D. Inspect
  E. Use
  B. Read
  C. Manage
  D. Inspect
  E. Use

• Question 52:

  Which statement is correct about the Service Console in an Autonomous Database?

  A. You can use the Service Console to enable or disable auto-scaling of an Autonomous Database.
  B. You can use the Service Console to manage runaway SQL statements on an Autonomous Database.
  C. You can use the Service Console to create manual backups of an Autonomous Database.
  D. You can use the Service Console to move an Autonomous Database between compartments.
  B. You can use the Service Console to manage runaway SQL statements on an Autonomous Database.

• Question 53:

  How do you change the tablespace quota for user MTHEO on an Autonomous Database on Shared Infrastructure?

  A. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username => 'MTHEO', tablespace_quota => 'UNLIMITED');
  B. Execute ALTER USER MTHEO QUOTA UNLIMITED ON TABLESPACE DATA;
  C. Execute ALTER TABLESPACE DATA SET QUOTA = 10G;
  D. Execute ALTER DATABASE FOR USER MTHEO TABLESPACE DATA QUOTA = 10G;
  B. Execute ALTER USER MTHEO QUOTA UNLIMITED ON TABLESPACE DATA;

• Question 54:

  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 on the OLTP database or in a separate data mart. The DBA Manager does not want to add any more 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. ATP using 'tpurgent' and 'high' TNS services to separate connection types
  B. Since the application needs to be highly available, it should be deployed on a Kubernetes Cluster
  C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis
  D. ADW since operational reporting is a higher priority in this scenario
  A. ATP using 'tpurgent' and 'high' TNS services to separate connection types

• Question 55:

  Which statement is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure?

  A. An ACL can be set up for an IP Address or a virtual cloud network but not both at the same time
  B. When you restore a database, the existing ACLs are not overwritten by the restore.
  C. ACLs can only be used with private endpoints
  D. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure
  B. When you restore a database, the existing ACLs are not overwritten by the restore.

• Question 56:

  Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer? (Choose the best answer.)

  A. ADBDEV
  B. DWROLE
  C. ADMIN
  D. ADWC
  B. DWROLE

• Question 57:

  Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment?

  A. Moving an Autonomous Database instance does not include its automatic backups.
  B. You do not require 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.
  D. Moving the compartment of the Autonomous Database also moves the Autonomous Container Database and Autonomous Exadata Infrastructure.
  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 58:

  A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment. What should they do to remove this bottleneck?

  A. Remove any non-JSON data from the database.
  B. Ask Support to migrate their setup to a node without noisy neighbors.
  C. Increase the number of OCPUs allocated to the database.
  D. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
  C. Increase the number of OCPUs allocated to the database.

• Question 59:

  In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use to control OCPU utilization?

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

• Question 60:

  What is the correct way to list all files in the default data pump directory?

  A. By executing SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
  B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW)
  C. By executing SELECT * FROM UTL_FILE.LIST('DATA_PUMP_DIR');
  D. Log onto ADW server and issue ls -al on the command line
  A. By executing SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');