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

Oracle 1Z0-931-22 Online Questions & Answers

• Question 81:

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

  When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

  A. Data
  B. Schemas
  C. Tablespaces
  D. Reports
  A. Data
  B. Schemas

• Question 83:

  Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

  A. User's OCID
  B. Tenancy's OCID
  C. Database ADMIN password
  D. Fingerprint of the public key
  C. Database ADMIN password

• Question 84:

  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

  

• Question 85:

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

  A. On the Autonomous Database Console.
  B. SSH keys are not required in Oracle Cloud Infrastructure.
  C. SSH keyscannot be added from console. They have to be added using REST APIs only.
  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".

  ---

  - In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user's name to view the details.

  -Click Add Public Key.

  -Paste the key's value into the window and click Add.

  

• Question 86:

  Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

  A. Autonomous Transaction Processing only
  B. ATP and ADW
  C. Autonomous Data Warehouse only
  D. Hybrid Columnar compression
  B. ATP and ADW

• Question 87:

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

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

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

  ---

  

• Question 89:

  Which statement is FALSE about Oracle Autonomous JSON Database?

  A. JSON data is stored natively in the database
  B. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
  C. It supports NoSQL-style, document-centric application
  D. There is a 20 GB limit on JSON collection
  D. There is a 20 GB limit on JSON collection

  ---

  

• Question 90:

  

  In which four ways can Oracle Database optimally access data in Object Storage?

  A. optimized data archive using partitioned external tables
  B. optimized data archive using hybrid partitioned tables
  C. scan avoidance using block skipping when reading parquet and ore files
  D. scan avoidance using columnar pruning for columnar stores like parquet and orc
  E. scan avoidance using partitioned external tables
  F. scan avoidance using columnar pruning for .csv files
  A. optimized data archive using partitioned external tables
  B. optimized data archive using hybrid partitioned tables
  D. scan avoidance using columnar pruning for columnar stores like parquet and orc
  E. scan avoidance using partitioned external tables