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

Oracle 1Z0-931-22 Online Questions & Answers

• Question 101:

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

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

• Question 102:

  An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB. Other than changing the shared user password, what can the admin do to protect the instance?

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

  ---

  

• Question 103:

  Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

  A. Exadata
  B. Active Data Guard
  C. RAC, but only when scaling beyond 16 OCPUs
  D. Transparent Data Encryption
  E. Multitenant
  C. RAC, but only when scaling beyond 16 OCPUs
  E. Multitenant

  ---

  Refer to https://www.oracle.com/autonomous-database/autonomous-data- warehouse/pricing/

  If you run Oracle Database EnterpriseEdition and the required options listed below, then your BYOL requirements are as follows:

  For 1-16 OCPUs of a single Oracle Autonomous Data Warehouse instance:

  For each supported Processor license of Oracle Database Enterprise Edition plus Options:

  Multitenant, you may activate up to 2 OCPUs of the BYOL Cloud Service. For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate 1 OCPU of the BYOL Cloud

  Service. For 17 OCPUs or more of a single Oracle Autonomous Data Warehouse:

  For each supported Processor license of Oracle Database Enterprise Edition plus Options:

  Multitenant and Real Application Clusters, you may activate up to 2 OCPUs of the BYOL Cloud Service.

  For every 25 supportedNamed User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate 1 OCPU of the BYOL Cloud Service.

  https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html "Docustomers need Exadata licenses to benefit from BYOL?"

• Question 104:

  During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

  A. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
  B. the Client Credentials wallet which is used to connect to the Autonomous Database
  C. the 'High Availability Container Database' in which the Autonomous instance should run
  D. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
  E. the Listener endpoint where the Autonomous Database should register on
  C. the 'High Availability Container Database' in which the Autonomous instance should run

  ---

  https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adb_dedicated_creating.htm

• Question 105:

  Which two options are available to restore an Oracle Autonomous Database?

  A. Select the backup from which restore needs to be done.
  B. Specify the point in time (timestamp) to restore.
  C. Select the snapshot of the backup.
  D. Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.
  E. Specify the archived custom image.
  A. Select the backup from which restore needs to be done.
  B. Specify the point in time (timestamp) to restore.

• Question 106:

  A BusinessAnalyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst. When restoring/cloning the ADB, you must select a backup which is atleast___hours/minutes old.

  A. 24hrs
  B. 2 hrs
  C. 5 min
  D. 1 day
  A. 24hrs

• Question 107:

  Which three of the following data sources are available when using the Data Load page on Database Actions?

  A. Files in Oracle Cloud Storage
  B. Backup files in block storage
  C. Local Files
  D. Files in AWS S3 Storage
  E. REST endpoints
  A. Files in Oracle Cloud Storage
  C. Local Files
  D. Files in AWS S3 Storage

• Question 108:

  Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)

  A. Oracle Cloud Infrastructure Object Storage
  B. Google Cloud Storage
  C. Amazon S3
  D. Azure Blob Storage
  E. Oracle Cloud Infrastructure Object Storage Classic
  A. Oracle Cloud Infrastructure Object Storage
  E. Oracle Cloud Infrastructure Object Storage Classic

  ---

  https://docs.oracle.com/en/cloud/paas/atp-cloud/atpud/load-data-using-oracle-data- pump.html#GUID025C4566-1BDB-4EF2-BFB7-0CBA8C47EA5D Data Pump Import lets you import datafrom Data Pump files residing on the Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic . You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to Autonomous Database. https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/#articletitle https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/index.html#ADBBK- GUID-37922C56-0412-45CD-B10C-2088A000113F https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data- pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data- pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF

• Question 109:

  Whenyou are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?

  A. 2 hours
  B. 30 minutes
  C. 1 hours
  D. 24 hours
  A. 2 hours

  ---

  Clone Sources You can use a running database to create a clone. For databases running on shared Exadata infrastructure, you can also use a backup as the source of your clone. When using a backup, you can select a listed backup to clone from, or create a point-in-time clone. Point-in-time clones contain all data up to a specified timestamp. The specified timestamp must be in the past. NoteWhen you create a clone from a backup, you must select a backup that is at least two hours old. https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbcloning.htm

• Question 110:

  Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

  A. Network Security Group
  B. Security List
  C. VCN
  D. Route Table
  E. Subnet
  A. Network Security Group
  C. VCN
  E. Subnet

  ---

  To provision an Autonomous Database with a private endpoint, you must have the following resources already created:

  A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure. Cannot be changed after provisioning. A private subnet within your VCN configured with default DHCP options. Cannot be changed

  after provisioning.

  At least 1network security group (NSG) within your VCN for the Autonomous Database. Can be changed or edited after provisioning.

  https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbsprivateaccess.htm