1Z0-931-24

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

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?. db-workload. s-dedicated. db-type. license-model.

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

Which two are correct actions to take in order to Download the Autonomous Database Credentials?. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then. Click the Compute section of the menu, then choose Instance Configurations, then Download. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet. Find the Service Console for your Autonomous Database, then pick Administration, then Download.

What are three methods to load data into the Autonomous Database?. Oracle GoldenGate. Transportable Tablespace. RMAN Restore. Oracle Data Pump. SQL*Loader.

Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?. Exadata. Active Data Guard. RAC, but only when scaling beyond 16 OCPUs. Transparent Data Encryption. Multitenant.

The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure.

Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused. You can use the dbms_auto_index package to report on the automatic task and to set your preferences. It is enabled by default. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints. The indexing feature is implemented as an automatic task that runs at a fixed interval.

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?. It cannot be done. Using Database Configuration Assistant (DBCA) on the database server. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls. Connecting to the Cloud Infrastructure Command console via SSH wallet.

When enabling auto-scaling, which three options do not change?. Number of OCPUs displayed in the console. Amount of storage. I/O resources. parallelism settings. Level of concurrency.

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

Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production. How should the customer unplug their database to migrate to Autonomous Database (ADB)?. Pluggable databases cannot be migrated to ADB using plug, unplug or clone. Create a database link from source database to the ADB environment and clone the PDB. Unplug to an xml file so database files and xml file can be uploaded to object storage. Unplug into a pdb archive which can be uploaded to object storage.

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’. Allow group ADB-Admins to manage autonomous-database in tenancy. Allow group ADB-Admins to manage autonomous-database-family in tenancy. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'.

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?. The SQL statement completed its execution. The SQL statement is executing. The SQL statement is queued. The SQL statement did not complete either due to an error.

When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?. Under Core Infrastructure then Compute then Autonomous Exadata. Under Solutions and Platform then Platform Services then Autonomous Exadata. Under Database then Autonomous Transaction Processing then Autonomous Exadata. Under Core Infrastructure then Autonomous Exadata.

Which statement is NOT correct when setting up compartment quotas?. There are three types of quota policy statements which are set, unset and zero. Compartment quotas use policies that allow allocation of resources with a high level of flexibility. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending. Compartment quotas are set by Oracle.

Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments. Moving an Autonomous Database instance does not include its automatic backups. You do not need to have sufficient access permissions on the compartment that the resource is being moved to. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service. The load on the database increases from three OCPUs to nine OCPUs. What is the total number of concurrent statements that the TPURGENT service can support?. 900. 1800. 2700. 1500.

Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. Which statement is FALSE?. Oracle Data Safe only supports Autonomous Databases. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.

According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups. Which statement is true?. Create a separate VCN that contains only public subnets. Only 1 of each is allowed to be allocated per environment. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised. Create at least 2 of each resource.

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.). The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully. The target table will be created in Autonomous Database if it does not already exist.

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?. SQLDEV_ADMIN.GRANT_SCHEMA. ORDS_ADMIN.ENABLE_SCHEMA. ORDS_ADMIN.GRANT_SCHEMA. ORDS_PRIV.ENABLE_SCHEMA.

Which statement is true when you provision an Autonomous Database using the cloning method?. After an Autonomous database is created using a clone, the network access option can be changed. A clone database source can be a running database instance. A clone database source can be from a point-in-time backup that is less than 2 hours old. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

Which statement is correct about managing and monitoring of Autonomous Database?. You can use Service console to move Autonomous DB between compartments. You can use Service console to create manual backups of Autonomous database. You can use Service console to enable or disable auto scaling of Autonomous DB. You can use Service console to manage runaway SQL statements on Autonomous DB.

Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?. Data Pump Export File. Avro. Parquet. Text. JSON. Microsoft SQL Server (.mdf).

How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?. Execute alter database for user MTHEO tablespace DATA quota = 10G;. Execute alter user MTHEO quota unlimited on tablespace DATA;. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);. Execute alter tablespace DATA set quota = 10G;.

Which three security features are available in Oracle Autonomous Database Shared Infrastructure?. Transparent Data Encryption. Database Vault. Customer Managed Keys. Data Redaction. Audit Vault.

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?. On the Autonomous Database Console. SSH keys are not required in Oracle Cloud Infrastru. SSH keys cannot be added from console. They have to be added using REST APIs only. Navigate to Identity, select Users panel on the console and select "Add Public Key".

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?. Oracle Machine Learning notebook. Compartment quotas. Resource Manager settings. SQL Developer Web Console.

What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?. alter database set application_continuity=true. alter session set application_continuity=true. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;. alter system set application_continuity=true.

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.). through the Oracle Cloud Infrastructure service console. through SQL/Developer s. using DBMS_CLOUD_ADMIN package. through SQLPIus.

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.). DBNAME_MEDIUM. DBNAME_HIGH. DBNAME_CONCURRENT. DBNAME_LOW.

Which can be Scaled Independently of the number of CPUs In an Autonomous Database?. Parallelism. Storage. Concurency. Memory. Sessions.

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.). RMAN Cross-Platform backup and resto. Golden Gate on-premise installation. PDB unplug / plug operation. Datapump export / import. Dataguard Physical Standby. Golden Gate Cloud service.

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

Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.). Oracle Cloud Infrastructure Object Storage. Google Cloud Storage. Amazon S3. Azure Blob Storage. Oracle Cloud Infrastructure Object Storage Classic.

Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database. 120. 60. 15. 7.

Which statement is true when connecting OCI Marketplace image to shared autonomous database?. Compute Image and Shared ADB must be in same VCN and Subnet. ADB must be configured with NSG. ADB must be configured with Private endpoints. Cannot connect OCI Market image to shared ADB.

A Business Analyst 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. 24 hrs. 2 hrs. 5 min. 1 day.

When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?. Scan partition tables. scan hybrid partition tables. prun column in parquet files. prun columns in csv files.

Which three are use cases for Graph Studio? (Choose three.). 3-D modelling. Churn analysis. Pattern matching. Facial recognition. Clustering.

What happened with the standby database when disabling Autonomous Data Guard?. The standby database is started readwrite. The standby database is transformed in a refreshable clone. The standby database is terminated. The standby database is started read only.

Which statement is FALSE about Oracle Autonomous JSON Database?. JSON data is stored natively in the database. You can promote Autonomous JSON Database to Autonomous Transaction /Processing. It supports NoSQL-style, document-centric application. There is a 20 GB limit on JSON collection.

Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?. Oracle Cloud Infrastructure Object Storage. Google Cloud Storage. Amazon S3. Oracle Cloud Infrastructure Object Storage Classic.

Which statement is not correct when the Autonomous Database is stopped?. In-flight transactions queries are stopped. Tools are no longer able to connect to a stopped instance. User with DWROLE can still access the database. CPU billing is halted.

Which statement is correct about the Service console in an Autonomous Database?. You can use Service console to enable or disable auto scaling of Autonomous DB. You can use Service console to manage runaway SQL statements on Autonomous DB. You can use Service console to move Autonomous DB between compartments. You can use Service console to create manual backups of Autonomous database.

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?. Autonomous Transaction Processing. Autonomous Data Warehouse. Neither service ignores hints by default. Both services ignore hints by default.

Which Database Actions tool is used to get information about the entries on your Oracle Autonomous Database and to see the effect that changing an object has on other objects. Data Load. Catalog. JSON. Data Insight.

Which statement is FALSE for Oracle Data Safe? (Choose the best answer.). Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user. Oracle Data Safe only supports Autonomous Databases. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?. Week of the Quarter, Day of the Week, Start Hour. Month of the Year, Week of the Month, Day of the Week, Start Hour. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour. Month of the Quarter, Week of the Month, Day of the Week, Start Hour.

You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables?. Business Models. Data Load. SQL Developer Web. APEX.

When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?. 2 hours. 30 minutes. 1 hours. 24 hours.

In Graph Studio which you can use to create a graph?. A graph license key. Tables in an Autonomous Database instance. NoSQL configuration. Graph analytics algorithms. Graph created by a special tool downloaded from Oracle.com.

While creating a business model what advanced options you can enable or disable? (Choose three). Business Object Security Feature. Analytic View Transparency View. Autonomous Aggregate Cache. Display private tables. Analytic View Base Table Query Transformation.

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?. 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. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric.

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

Which two actions are available to perform when an Autonomous Database is stopped?. Start. Update Network Access. Change administrator password. Update License Type.

In which four ways can Oracle Database optimally access data in Object Storage?. optimized data archive using partitioned external tables. optimized data archive using hybrid partitioned tables. scan avoidance using block skipping when reading parquet and ore files. scan avoidance using columnar pruning for columnar stores like parquet and orc. scan avoidance using partitioned external tables. scan avoidance using columnar pruning for .csv files.

Which two statements are true about accessing Autonomous Database Tools?. Access to Database Actions is available for all users of Autonomous Database. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database. SQL Developer Web is available exclusively on the Autonomous Database. 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. Oracle APEX can be accessed only from the Developer menu in the Service Console.

Which two options are available to restore an Oracle Autonomous Database?. Select the backup from which restore needs to be done. Specify the point in time (timestamp) to restore. Select the snapshot of the backup. Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up. Specify the archived custom image.

Which statement is FALSE about Oracle Data Safe?. It supports only Autonomous Databases. It helps you assess the security of your cloud database configurations by analyzing database configurations. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary. It evaluates user types, how users are authenticated, and the password policies assigned to each user. It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements.

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