Oracle Autonomous Database Cloud 2024 Professional (1z0-931-24) Free Questions - Part 5
Question No : 61) 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?
A. Oracle Data Safe only supports Autonomous Databases.
B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
C. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
Question No : 62) What are three methods to load data into the Autonomous Database?
A. Oracle GoldenGate
B. Transportable Tablespace
C. RMAN Restore
D. Oracle Data Pump
E. SQL*Loader
Question No : 63) Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?
A. Oracle Cloud Infrastructure Object Storage Classic
B. Oracle Cloud Infrastructure Object Storage
C. Google Cloud Storage
D. Amazon S3
E. Azure Blob Storage
Question No : 64) Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU 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?
A. For databases on dedicated Exadata infrastructure, the maximum 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.
B. The base number of OCPU cores allocated to a database is not guaranteed.
C. 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.
D. Auto scaling is enabled by default and can be enabled or disabled at any time.
Question No : 65) Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is stopped. Which statement is true?
A. The standby database is terminated.
B. The standby database is also stopped.
C. Switchover is automatically initiated.
D. Failover is automatically initiated.
Question No : 66) In Graph Studio which you can use to create a graph?
A. A graph license key
B. Tables in an Autonomous Database instance
C. NoSQL configuration
D. Graph analytics algorithms
E. Graph created by a special tool downloaded from Oracle.com
Question No : 67) 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 Endpoint networking.
E. Oracle APEX can be accessed only from the Developer menu in the Service Console.
Question No : 68) Which statement is correct about the Service console in an Autonomous Database?
A. You can use Service console to enable or disable auto scaling of Autonomous DB
B. You can use Service console to manage runaway SQL statements on Autonomous DB
C. You can use Service console to move Autonomous DB between compartments
D. You can use Service console to create manual backups of Autonomous database
Question No : 69) Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints
A. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints
B. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.
C. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
D. You can configure Private Endpoints for an Always Free Autonomous Database
Question No : 70) You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web. What steps do you need to take?
A. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
B. Create a database user with the default privileges.
C. Create a database user with connect, resource, and object privileges.
D. Create an IDCS user. Create a database user with connect, resource, and object privileges.
Question No : 71) How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
A. Execute alter database for user MTHEO tablespace DATA quota = 10G;
B. Execute alter user MTHEO quota unlimited on tablespace DATA;
C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
D. Execute alter tablespace DATA set quota = 10G;
Question No : 72) 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?
A. 900
B. 1800
C. 2700
D. 1500
Question No : 73) Which statement is FALSE for Oracle Data Safe? (Choose the best answer.)
A. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations
B. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user
C. Oracle Data Safe only supports Autonomous Databases
D. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary
Question No : 74) Which two methods can you use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure
A. service console
B. SQL Developer
C. the DBMS_CLOUD_ADMIN package
D. SQL *Plus
Question No : 75) Which two statements are true about Data Insights?
A. You can retrieve previously executed Data Insights searches.
B. Data Insights is available with on-premises deployments of Oracle Database.
C. Data Insights is an additional priced option.
D. You can search for Data Insights against a base table or business model.
1z0-931-24 Answers