1Z0-931-25

3. When cloning from a backup, what is the earliest timestamp of the backup allowed?. 30 minutes. 24 hours. 2 hours. 1 hour.

1. What are the two supported infrastructure options for deploying an Autonomous Database?. Dedicated Exadata Infrastructure. Any Oracle Engineered System. VM on Oracle Cloud Infrastructure. Serverless Exadata Infrastructure. Bare-metal on Oracle Cloud Infrastructure.

2. Which three tasks are automatically performed by Oracle Autonomous Database?. Patching the database. Cloning the database. Backing up the database. Masking sensitive data. Encrypting data.

4. Which three options are supported when migrating to Autonomous Database (ADB)?. RMAN Cross-Platform backup and restore. GoidenGate on-premises mstallation. Deta Guard Physical Standby. Data Pump export/import. GoldenGate Cloud service. PDB unplug/plug operation.

5. Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of OCPL cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use. Which statement is FALSE regarding the auto scaling feature?. The base nurober of ECPU cores allocated to a databuse is not guranteed. Auto scaling is enabled by default and can be enabled or disabled at any time. For databases on dedicated Exadata infrastructure, the euximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.

6. During the provisioning of an Autonomous Database on dedicated hardware, what should the database administrator select to determine where the Autonomous Database is created on the dedicated infrastructure?. The container database in which the Autonomous instance should run. The Listener endpoint where the Autonomous Database should register on. The Client Credentials wallet, which is used to connect to the Autonomous Database. The compartment of the dedicated infrastructure because each compartment only runs one dedicated environment.

7. Who, and in which order, provisions dedicated Exadata Infrastructure resources?. The database administrator provisions the Autonomous Container DB and the Autonomous DB. Then, the fleet administrator provisions the Autonomous Exadata Infrastructure. The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB. Then, the database administrator provisions the Autonomous DB. The fleet administrator provisions the Autonomous Exadata Infrastructure. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB. The database administrator provisions the Autonomous Exadata Infrastructure. Then, the fleet administrator provisions the Autonomous Container DB and then the Autonomous DB.

8. After you created an Autonomous Container Database on dedicated infrastructure, which patch type is offered to be applied during maintenance?. Prior Release Update Revision (PRUR). Quarterly Bundle Patch (QBP). Release Update (RU). Prior Release Update (PRU).

9. Which two objects are imported when using Data Pump to migrate your Oracle database to Autonomous Database?. Schemas. Reports. Tablespaces. Data.

10. Which can be scaled independently of the number of ECPUs in an Autonomous Database?. Concurrency. Storage. Memory. Parallelism. Sessions.

11. Which are the two restrictions for an Always Free Autonomous Database?. maximum of one ECPU per Database. Oracle Application Express (APEX) not included. maximum of two Always Free Databases per OCI tenancy. supports only ATP as a workload type.

12. Which two statements are true regarding active transactions when scaling ECPUs in an Autonomous Database?. Active transactions continue running unaffected. Scaling can happen while there are active transactions in the database. Active transactions in Autonomous Data Warehouse are paused. Active transactions are paused. Active transactions are terminated and rolled back.

13. Which three statements are correct when an Autonomous Database on Serverless is stopped?. CPU billing is halted. In-flight transactions and queries are stopped. User with DWROLE can still access the database. CPU billing continues. Tools are no longer able to connect to a stopped instance.

14. 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?. JSON. Data Load. Catalog. Data Insights.

16. What are three characteristics of Data Lake data captured in Object Storage?. high concurrency. schema on read. mixed data types. high transaction performance. multiple subject areas.

17. Which two statements are true about Oracle Cloud Infrastructure (OCI)?. Because availability domains do not share infrastructure, such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region. Regions are dependent on other regions and must be located within five thousand kilometers of each other. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region. A single fault domain can be associated with multiple regions and availability domains.

15. Which two of the following data sources are available when using the Data Load page on Database Actions. Files in Oracle Cloud Storage. Backup files in block storage. Local Files. REST endpoints.

18. Which two license types does a customer need to benefit from Bring Your Own License (BYOL) when leveraging on-premises Enterprise Database licenses in Oracle Autonomous Database?. Active Data Guard. Transparent Data Encryption (TDE). Real Application Clusters (RAC), but only when scaling beyond 16 OCPUS. Exadata. Multitenant.

19. Which vaults are used for storing customer-managed encryption keys for Autonomous Database?. Oracle Audit Vault, Oracle Key Vault. Oracle Cloud Infrastructure Vault, Oracle Database Vault. Oracle Key Vault, Oracle Cloud Infrastructure Vault. Oracle Database Vault, Oracle Key Vault.

20. 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?. The source is set to the address range you want to allow to connect to your database. The IP Protocol is set to TCP. The destination port range is set to 1522. A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance.

21. Which two statements are true about Data Insights?. Data Insights is an additional priced option. Data Insights is available with on-premises deployments of Oracle Database. You can retrieve previously executed Data Insights searches. You can search for Data Insights against a base table or business model.

22. Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?. You must first manually create your database credentials using dbms_cloud.create_credential before accessing your Oracle Object Storage Bucket. Data formats supported include: text, csv, json, avro and parquet. Data can be uploaded from several cloud storage sources including S3, Azure, Google Cloud and Oracle Object Storage. Data can be loaded from a local data source. Data can be loaded from a remote database using Database Links (DBLinks).

23. Which API is NOT available for developing with spatial on ADB?. Gremlin. Python. Java. PL/SQL. REST.

24. You have a requirement to create an Autonomous Transaction Processing database that can support up to 300 concurrent statements per ECPU as well as parallelism. Which service would you connect to?. TPURGENT. LOW. City. MEDIUM.

25. As a database architect, you are tasked with configuring a high concurrency, production OLTP (online transaction processing) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which connection service is appropriate for such a workload?. MEDIUM. TP. TPURGENT. HIGH.

26. Which three advanced options can you enable or disable while creating a business model?. Business Object Security Feature. Autonomous Aggregate Cache. Analytic View Base Table Query Transformation. Analytic View Transparency Views. Display Private Tables.

27. What process is used to generate latitude/longitude information from addresses?. GeoRaster. GeoCoder. GeoLocation. GeoDefine.

28. You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling?. Shut down the instance, click Scale Up/Down and select the Auto Scaling checkbox, then restart the instance. Use a REST call to enable Auto Scaling. Click Scale Up/Down and select the Auto Scaling checkbox. Use a REST call to shut down the instance, then a second REST call to enable Auto Scaling, and a REST call to restart the instance.

29. Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure.

30. What are the two differentiators of Oracle Autonomous Database on Dedicated Infrastructure?. Users are offered greater control and isolation starting at the Exadata Cloud Infrastructure level. Users have OS access to the database machine. Users can customize the OS stack and add additional packages. Users have more control over the maintenance schedule. Users have sys privileges in the database.

31. Which two options are available for restoring an Autonomous Database?. Specifying the point in time (timestamp) to restore. Specifying the archived custom image. Using Recovery Manager (RMAN) to connect to Autonomous Database and back it up. Selecting the snapshot of the backup. Selecting the backup from which restore needs to be done.

32. Which two Oracle Cloud Infrastructure (OCI) resources do you need to create before initiating a manual backup of Oracle Autonomous Database?. Backup Job. Storage Gateway. Object Storage Bucket. Auth Token. Service Gateway.

33. Which statement is correct about management operations on Autonomous Database on Serverless?. You cannot configure the scheduling for your Autonomous Databases on Serverless. You can skip a scheduled maintenance run. For Autonomous Databases on Serverless, you can skip maintenance runs for up to two consecutive quarters if needed. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Serverless. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.

34. Which is NOT required to connect to Autonomous Database from SQL Developer?. Service name. Wallet file. Database name. Username and password.

35. Which subset of services is offered via OCI-CLI (command line interface) for Autonomous Database (ADB) via calls made to the OCI APIs?. Create, Get, List, Stop, Restore. Start, Delete, Update, Query, Stop. Create, Query, Update, List, Start. Create, Query, List, Stop, Restore.

36. Which statement is FALSE regarding database links?. You can connect to an Autonomous Database from a remote database using a database link. You can connect to a remote database from an Autonomous Database by using a database link. You can call PL/SQL procedures and functions by using a database link. You can create a database link from one Autonomous Database to another Autonomous Database instance.

37. Which option should you use to create a graph with Graph Studio?. A graph license key. Graph analytics algorithms. Tables in an Autonomous Database instance. NoSQL configuration. Graph created by a special tool downloaded from oracle.com.

38. Which is a feature of a graph query language?. Scripting language. Object-oriented language. Run key-value queries. Ability to specify patterns.

39. 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?. Delete the user who left. Shut down and restart the instance. Delete the database. Rotate the instance wallet and share the new wallet with the remaining users.

40. Which file is NOT a component of the client credentials wallet used to connect to an Oracle Autonomous Database?. truststore.jks. protocol.ora. sqlnet.ora. keystore.jks. ewallet.p12. cwallet.sso.

41. Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?. Memory Usage. Undo Management. Data Organization. Backup Retention.

42. Which set of Oracle Cloud Infrastructure (OCI) metrics is available only for Autonomous Database on Dedicated Infrastructure?. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag. Transaction Count, Sessions, Running Statements. Query Latency, User Calls, Execute Count. CPU Utilization, Storage Utilization.

43. You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END". Create a notification alert using DBMS_SNMP package.

44. Which three are Oracle-recommended best practices for Autonomous Database alarms?. Create a single alarm for each metric. Use a single interval for all alarms. Suppress alarms during investigations. Tune your alarms routinely. Select the correct alarm interval for your metric. Create multiple alarm metrics.

45. Which three event types are supported for Autonomous Database?. Change Compartment Begin. Terminate End. Change Autoscaling Configuration Compartment. Maintenance Begin. Update IORM Begin.

46. 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?. Increase the number of ECPUs allocated to the database. Remove any non-JSON data from the database. Change the disk throughput settings in the console. Increase the number of Database Writer processes.

47. What predefined user is created when provisioning an Autonomous Database (ADB) instance to which you connect to create other users and grant roles?. SYS. DWDEV. ADMIN. SCOTT.

48. Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer?. DWROLE. ADMIN. ADBDEV. ADWC.

49. You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX. What statement describes the step to provide the developer a new workspace in APEX?. Create an IDCS user with the APEX role. Create a new developer account. Create a database user with the APEX role. Access the APEX Administration Services and create the workspace for the developer.

50. You are the admin user of an Autonomous Database instance. A new business analyst has joined the team and would like to explore the Autonomous Database tables using Autonomous Database's Data Tools. Which step should you to perform to enable the new team member?. Create a database user with the default privileges. Create a database user with connect, resource, and object privileges. Create a REST-enabled database user (with connect and object privileges) and grant the DWROLE role. Create an IDCS user. Create a database user with connect, resource, and object privileges.

51.Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?. RMAN. OCI Metrics. Enterprise Manager Cloud Control. Logs. Performance Hub.

52.Which native data type is used to store spatial information?. GEO_JSON. SDO_RELATE. SDO_GEOMETRY. SDO_LOCATION.

53. Which three methods can be used to migrate on-premises databases to Oracle Autonomous Database (both Serverless and Dedicated)?. Oracle GoldenGate. RMAN backup & restore. Original imp/exp tools. Physical migration methods, such as database cloning. Oracle Data Pump. Oracle Zero Downtime Migration (ZDM).

54. Which two security features are enabled by default by the Autonomous Database?. Transparent Data Encryption (TDE). Read-only access to OS Audit logs. One SYSDBA account. Encrypted Database Links. SQL *Net Encryption.

55. What infrastructure does the Autonomous Database run on?. Exadata on Oracle Cloud Infrastructure. Any Oracle Engineered system. VM on Oracle Cloud Infrastructure. Bare-metal on Oracle Cloud Infrastructure.

56. You moved an Autonomous Database from compartment C01 to C02. Which two statements are true?. Any policy defined on C02 will be immediately applied to the database. You need to shut down the database in C01 before you can move it to C02. An Autonomous Data Guard for the database is created in C01 post successful migration to C02. The Automatic Backups are moved to C02, as well.

57. Which DHMS_WORKLOAD_REPOSITORY subprogram procedure can be used to modify the default eight day retention period for Autonomous Database performance data?. UPDATE_OBJECT_INFO. CREATE BASELINE_TEMPLATE. MODIFY SNAPSHOT_SETTINGS. MODIFY_BASELINE_WINDOW_SIZE.

58. You see a clock icon in the Status column on the SQL Monitoring tab of Performance Hub. What does it indicate?. The SQL statement completed its execution. The SQL statement is executing. The SQL statement did not complete due to an error. The SQL statement is queued.

59. Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?. You can change your container database maintenance window or reschedule a single container database maintenarice run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter. Autonomous Exadata infrastructure maintenance takes place at least once each quarter. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedules the container database maintenance for the following quarter. Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching.

60. When an administrator rotates the instance wallet for an Autonomous Database on Serverless, what happens to the regional wallets used with that instance?. They are also rotated. They revert to pending. They become invalid. They continue to work.

61. Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?. Maximum Continuity. Maximum Performance. Maximum Protection. Maximum Availability.

62. Which REST verb is used to create an Autonomous Database service by using REST APIs?. a "PUT" REST call. an "INSERT" REST call. a "POST" REST call. a "GET" REST call.

63. Which command should you issue to enable application continuity on Oracle Autonomous Database Serverless?. alter system set application_continuity-truc. alter session set application_continuity-truc. exec dbms_cloud_admin.enable_app_cont("<service_name>");. alter database set application_continuity=true.

64. Which subset of services is offered via OCI-CLI (command line interface) for Autonomous Database (ADB) via calls made to the OCI APIs?. Create, Query, Update, List, Start. Create, Query, List, Stop, Restore. Create, Get, List, Stop, Restore. Start, Delete, Update, Query, Stop.

65. What two actions can you do when a refreshable clone passes the refresh time limit?. You can manually refresh the clone. You can extend the refresh time limit. You can use the instance as a read only database. You can disconnect from the source to make the database a read/write database.

66. Which two actions can be performed when an Autonomous Database is stopped?. Start. Update Network Access. Change Administrator Password. Update License Type.

67.Which tab in the Data Load Explore tool shows the size of the table and the number of rows and columns?. Measures tab. Data Sources tab. Hierarchies tab. Statistics tab.

68. Your customer wants to permanently disable scheduled maintenance on the Autonomous Database on Dedicated Infrastructure to keep their current database version(s). How can they achieve this?. You cannot permanently disable scheduled automatic maintenance. Change the Automatic Maintenance Schedule to "Specify a Schedule" but do not select any month, week, or day. Change the Automatic Maintenance Schedule to "No Preference.". Change the Automatic Maintenance Schedule to "None".

69. While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?. 7 days. 120 days. 60 days. 15 days.

70. Which statement is FALSE about setting up compartment quotas?. Quotas in a compartment cannot be managed unless you belong to a group that has the correct permissions. Quotas set on a parent compartment override quotas set on child compartments. Compartment quotas use policies that allow allocation of resources with a high level of flexibility. Compartment quotas cannot be set on the root compartment.

71. Which two are ways Oracle Database can optimally access data in Object Storage?. Scan avoidance using partitioned external tables. Optimized data archive using partitioned external tables. Scan avoidance using columnar pruning for.csv files. Optimized data archive using hybrid partitioned tables.

72.Which three methods can be used to migrate your existing Oracle database to Autonomous Database?. Using Recovery Manager (RMAN). Using GoldenGate. Using Oracle Zero Downtime Migration (ZDM). Using SFTP to copy CSV files into an Autonomous Database. Using Data Pump.

73. Which three options do NOT change when enabling to scaling?. I/O resources. Amount of storage. Number of OCPUs displayed in the console. Level of concurrency. Parallelism settings.

74. Which three Oracle Cloud Infrastructure (OCT) resources do you need to configure before provisioning your Autonomous Database with private endpoint?. Route Table. Subnet. Network Security Group (NSG). VCN. Security List.

75. Which three statements are true about changing license options in Oracle Autonomous Database?. You can update your Bring Your Own License (BYOL) to License Included after the Database has been created. You cannot update your BYOL to License Included after the Database has been created. You can update the License Included option to BYOL after the Database has been created. You can upgrade from an Always Free Autonomous Database account to a paid account any time. You cannot update the License Included option to BYOL after the Database has been created.

76. Which statement is FALSE about Oracle Text?. It requires an Oracle Text license for Autonomous Database. It uses standard SQL queries. It provides indexing, word and theme searches. It is suited to search document collections.

77. Where do you find the URL for Database Actions?. in Oracle Cloud Infrastructure Object Storage. in the database with a SQL query. in the Database Users card under Database Actions. on the SQL Developer Client Connection tab.

78. Where do you find the url to access APEX Administration Services on your Autonomous Database (ADB) instance?. in the database with a sql query. SQL Developer. in the ADB documentation. on the Tools tab and Service Console of the ADB instance.

79. Which four file formats are supported when loading data from Cloud Storage?. JSON. Parquet. AVRO. CSV. DOC. DDL.

80. What needs to be done after rotating the regional level Autonomous Database on Serverless wallet for your tenancy?. Download the new instance or regional wallet, and reconnect. Nothing; database users are not impacted. Apply the key to your database backups for the wallet. Users of the instance must disconnect and reconnect, and change their passwords.

81. Which is NOT needed to NOT needed to manage Oracle Autonomous Database with REST APIs?. Tenancy's OCD. User's OCID. Fingerprint of the public key. Database ADMIN password.

82. You need to create a new database b database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements: Autonomous Transaction Processing . License Included . Serverless Infrastructure Which parameter would you NOT use?. license-model. is-dedicated. db-type. db-workload.

83. Which two statements are true about using an Oracle Autonomous Database with private endpoints?. Private endpoints can be configured when you clone an Autonomous Database Serverless that was initially created with public endpoints. An Autonomous Database with private endpoints can be accessed from the public Internet by adding your IP address to an Access Control List (ACL). A Network Security Group (NSG) is required within your virtual cloud network before you can provision a Serverless Autonomous Database to use private endpoints. You can configure private endpoints for an Always Free Autonomous Database.

84. Which stage of the indexing pipeline divides text into tokens?. LEXER. TOKENIZER. SECTIONER. FILTER.

85. Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?. LOW. TPPERFORMANT. TPURGENT. MEDIUM. HIGH.

86. What are four methods to load data into an Autonomous Database?. Oracle Data Pump. Database Actions. Transportable Tablespace. Oracle GoldenGate. SQL*Loader. RMAN Restore.