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

Oracle 1Z0-931-25 Online Questions & Answers

• Question 121:

  Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database instance?

  A. The IP Protocol is set to TCP
  B. The destination port range is set to 1522
  C. A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance
  D. The source is set to the address range you want to allow to connect to your database
  C. A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance

• Question 122:

  Which Autonomous Database Cloud Service ignores hints in SQL statements by default?

  A. Both services ignore hints by default
  B. Neither service ignores hints by default
  C. Autonomous Data Warehouse
  D. Autonomous Transaction Processing
  C. Autonomous Data Warehouse

• Question 123:

  You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

  A. Create a rule for the Oracle Cloud Infrastructure Event for 'Autonomous Database STOP END'
  B. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
  C. Add a 'BEFORE SHUTDOWN ON DATABASE' trigger within the database
  D. Create a notification alert using DBMS_SNMP package
  A. Create a rule for the Oracle Cloud Infrastructure Event for 'Autonomous Database STOP END'

• Question 124:

  You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has 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, and object privileges
  B. Create a database user with the default privileges
  C. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer Web, and provide the user with the user-specific modified URL
  D. Create an IDCS user, create a database user with connect, resource, and object privileges
  C. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer Web, and provide the user with the user-specific modified URL

• Question 125:

  Which two statements are true about accessing the Autonomous Database Tools?

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

• Question 126:

  How many Network Security Groups (NSGs) can you configure for an Autonomous Database?

  A. 3
  B. 9
  C. 7
  D. 5
  D. 5

• Question 127:

  Which set of options can be specified when defining the preferred maintenance schedule of the Exadata Infrastructure for Autonomous Database Dedicated?

  A. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
  B. Month of the Quarter, Week of the Month, Day of the Week, Start Hour
  C. Month of the Year, Week of the Month, Day of the Week, Start Hour
  D. Week of the Quarter, Day of the Week, Start Hour
  B. Month of the Quarter, Week of the Month, Day of the Week, Start Hour

• Question 128:

  An Autonomous Database user with an instance wallet has left the company. The user had shared a database user ID with other users when accessing the Autonomous Database. Other than changing the shared user password, what can an administrator do to protect the instance?

  A. Trust the user who left not to access the database
  B. Delete the user
  C. Rotate the instance wallet and share the new wallet with the remaining users
  D. Shutdown and restart the instance
  C. Rotate the instance wallet and share the new wallet with the remaining users

• Question 129:

  Which are two available options when creating an Autonomous Database? (Choose two.)

  A. APEX Service on Dedicated Infrastructure
  B. APEX Service on Shared Infrastructure
  C. Autonomous JSON Database on Shared Infrastructure
  D. Autonomous JSON Database on Dedicated Infrastructure
  A. APEX Service on Dedicated Infrastructure
  C. Autonomous JSON Database on Shared Infrastructure

• Question 130:

  For fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

  A. Allow group adb-admins to manage autonomous-database in tenancy where target.workloadType='OLTP'
  B. Allow group adb-admins to manage autonomous-database-family in tenancy
  C. Allow group adb-admins to manage autonomous-database in tenancy where target.workloadType='DW'
  D. Allow group adb-admins to manage autonomous-database in tenancy
  B. Allow group adb-admins to manage autonomous-database-family in tenancy