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

Oracle 1Z0-931-25 Online Questions & Answers

• Question 31:

  Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

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

• Question 32:

  Which three options are available to access data in an Autonomous JSON Database?

  A. NoSQL statements using Simple Oracle Document Access (SODA) drivers
  B. Regular Oracle SQL statements using a connection through the listener
  C. REST API calls to the database (not enabled by default)
  D. Oracle Cloud Infrastructure console using the JSON Online Developer tool
  E. Oracle JSON Developer tool downloaded from Oracle Technology Network (OTN)
  A. NoSQL statements using Simple Oracle Document Access (SODA) drivers
  C. REST API calls to the database (not enabled by default)
  D. Oracle Cloud Infrastructure console using the JSON Online Developer tool

• Question 33:

  Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

  A. Transaction Count, Running Statements, Sessions
  B. CPU Utilization, Storage Utilization
  C. IOPS, Storage used by tablespace, Apply and Transport Lag
  D. Query Latency, User Calls, Execute Count
  C. IOPS, Storage used by tablespace, Apply and Transport Lag

• Question 34:

  Which statement is true about OCPUs and storage when you choose to scale your AutonomousDatabase?

  A. OCPUs and storage can be scaled independently
  B. Use auto scaling to increase storage
  C. Increasing OCPUs will automatically increase storage
  D. OCPUs and storage must remain in sync
  A. OCPUs and storage can be scaled independently

• Question 35:

  Which can be used to ensure that your Autonomous Database is accessible only from a given set of IPs?

  A. Security List
  B. IP Vault
  C. Access Control List
  D. IPSec List
  C. Access Control List

• Question 36:

  Which three event types are supported for Autonomous Database?

  A. Maintenance Begin
  B. Change Autoscaling Configuration Compartment
  C. Change Compartment Begin
  D. Update IORM Begin
  E. Terminate End
  A. Maintenance Begin
  C. Change Compartment Begin
  E. Terminate End

• Question 37:

  Which statement is NOT correct when the Autonomous Database is stopped?

  A. Tools are no longer able to connect to a stopped instance.
  B. In-flight transactions and queries are stopped.
  C. User with DWROLE can still access the database.
  D. CPU billing is halted.
  C. User with DWROLE can still access the database.

• Question 38:

  Which index type is designed to index catalog information?

  A. CONTEXT
  B. CTXCAT
  C. CTXRULE
  D. CONSTRAINS
  B. CTXCAT

• Question 39:

  Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?

  A. Catalog
  B. Data Load
  C. JSON
  D. Data Insight
  A. Catalog

• Question 40:

  You want to enable automatic indexing in a database, but any new auto indexes should be created as invisible indexes, so that they cannot be used in SQL statements. Which command will you use?

  A. EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','IMPLEMENT')
  B. EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF')
  C. EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY')
  D. EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','INVISIBLE')
  C. EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY')