1. Which Oracle spatial native datatype is used for vector data in Object-Relational Model? A. SDO_POSITION B. SDO_WITHIN_DISTANCE C. SDO_GEOMETRY D. SDO_DESTINATION	C. SDO_GEOMETRY
2. A company was initially using Autonomous Transaction Processing with two OCPU with TPURGENT. When the load on the database increased, the company increased OCPU to seven. What is the total number of concurrent statements which TPURGENT can support now? A. 700 B. 2700 C. 900 D. 2100	D. 2100
3. Which OCI resource is optional to configure before launching Autonomous Database with Private Endpoint? A. Subnet B. Virtual Cloud Network (VCN) C. Hostname prefix D. Network security group (NSGs)	C. Hostname prefix
4. Which event types does Autonomous Database Container support? A. Terminate Begin B. Recharge Wallet C. Create End D. Autoscaling	A. Terminate Begin C. Create End
5. Which statement is false about compartment quotas? A. Three types of compartments quotas are zero, unset and set B. My Oracle Support (MOS) sets compartment quotas C. Compartment quotas can be used to enforce spendings D. To clear quotas, unset statement should be used to remove quota for a resource	B. My Oracle Support (MOS) sets compartment quotas
6. Which statement is false about backup retention period for OCI Object Storage? A. 30 days B. 7 days C. 90 days D. 60 days	C. 90 days
7. Which tool breaks text into tokens as per your language? A. Breaker B. Tekenify C. Lexer D. Parser	C. Lexer
8. What happens to standby database when the primary database is stopped? A. Standby database will become primary database B. Standby database will be deleted C. Standby database state will show as restarting D. Standby database will also be stopped	D. Standby database will also be stopped
9. What should be the name of the bucket that will store manual backups for autonomous database named CLOUDGURUAMIT with display name as DEVDB? A. backup_cloudguruamit B. BACKUP_CLOUDGURUAMIT C. backup_devdb D. BACKUP_DEVDB	A. backup_cloudguruamit
10. Which two are correct IAM access policies for autonomous database? A. use B. alter C. create D. read	A. use D. read
11. Which three file formats are supported for DBMS_CLOUD package on Shared Exadata Infrastructure? A. Parquet B. C# C. Avro D. URI	A. Parquet C. Avro D. URI
12. Under Performance Hub in SQL Monitoring tab if you see a red cross in the status column, what does this mean? A. SQL query is still executing B. SQL query is queued C. SQL query did not complete either due to an error or due to the session getting terminated D. SQL query is successfully executed	C. SQL query did not complete either due to an error or due to the session getting terminated
13. What are the significance of Graph & Graph Database when deploying in real world model? Select THREE correct answer A. Product recommendations B. Clustering of the vertices C. Face ID in mobile phones D. Pattern Recognition	A. Product recommendations B. Clustering of the vertices D. Pattern Recognition
14. With regard to Autonomous JSON Database, which statements are correct? Select two correct answers. A. JSON Database supports applications of all programming language B. JSON Database is a document database service C. JSON Database supports only Node.js and Java D. JSON Database supports Open-Source NoSQL-style document APIs	B. JSON Database is a document database service D. JSON Database supports Open-Source NoSQL-style document APIs
15. What advantage does a customer get from BYOL when migrating on-premise database licenses to Oracle Exadata Database? Select two correct answers. A. Hardware Security Modules (HSM) B. Data Safe C. Multli-tenant Architecture D. Using beyond 16 OCPUs, RAC is required	C. Multli-tenant Architecture D. Using beyond 16 OCPUs, RAC is required
16. What step should be taken into consideration when an Autonomous Database will be accessed by given set of IP addresses? A. Vault B. Virtual Cloud Network (VCN) C. Security List D. Access Control List (ACL)	D. Access Control List (ACL)
17. Under Performance Hub in SQL Monitoring tab if you see a spinning icon in the status column, what does this mean? A. SQL query is still executing B. SQL query is queued C. SQL query did not complete either due to an error or due to the session getting terminated D. SQL query is successfully executed	A. SQL query is still executing
18. Which Oracle Package supports for working with data in Object Storage starting with Oracle Database 19c and later releases? A. DBMS_CUBE B. DBMS_HADOOP C. DBMS_CLOUD D. DBMS_DATAPUMP	C. DBMS_CLOUD
19. How is data stored in an Oracle Autonomous Data Warehouse database? A. Row Format B. Slowly Changing Dimension (SCD) C. Infrastructure As a Code D. Column Format	D. Column Format
20. Which tools can be used for data movement between Oracle databases and Autonomous Databases? Select two correct answers. A. Data Guard B. Zero Downtime Migration (ZDM) C. Data Safe D. Oracle Data Pump	B. Zero Downtime Migration (ZDM) D. Oracle Data Pump
21. A data driven company needs a tool which can help get information about the entities in the Oracle Autonomous Database and to see the effect that changing an object has on other objects. Which data tool should the company use? A. Data Transform B. Data Load C. Data Catalog D. Data Pump	C. Data Catalog
22. An e-commerce company needs to support minimum of 225 concurrent statements per OCPU as well as parallelism for its Autonomous Transaction Processing database. Which predefined service name will meet the above requirement? A. tpurgent B. tp C. medium D. low	A. tpurgent
23. In order to send messages to a subscription, what is the communication channel known as? A. Subscriber B. Notification C. Event D. Topic	D. Topic
24. Which of the below Cloud Services is supported to import data from Data Pump files? Select two correct answers. A. Microsoft Azure B. Blue Cloud C. AWS S3 D. Alibaba Cloud	A. Microsoft Azure C. AWS S3
25. Autonomous Database supports which infrastructures? Select two correct answers. A. Virtual Machine B. Bare Metal C. Shared Exadata D. Dedicated Exadata	C. Shared Exadata D. Dedicated Exadata
26. With regard to Autonomous JSON Database, which statement are TRUE? Select two correct answers. A. There is no storage limit for JSON collections B. Autonomous JSON Database service can be promoted to an Autonomous Data Warehouser service C. JSON Database don’t have any schema D. There is a storage limit of 20 GB for data including JSON document collections	A. There is no storage limit for JSON collections C. JSON Database don’t have any schema
27. A data driven company needs a tool which can help “drag-and-drop” based on ELT tool Oracle Data Integrator. Which data tool should the company use? A. Data Transform B. Data Load C. Data Catalog D. Data Pump	A. Data Transform
28. Under Performance Hub in SQL Monitoring tab if you see a clock icon in the status column, what does this mean? A. SQL query is still executing B. SQL query is queued C. SQL query did not complete either due to an error or due to the session getting terminated D. SQL query is successfully executed	B. SQL query is queued
29. Which role provides the common privileges for a data scientist or database developer to perform real-time analytics? A. DUSERROLE B. DWROLE C. DBROLE D. ADMINROLE	B. DWROLE
30. Which metrics are not used up while autoscaling an Autonomous Database instance? A. OCPU B. Parallelism C. Storage D. Concurrency	B. Parallelism D. Concurrency
31. Which statement is incorrect about Oracle Data Safe? A. User Assessment feature is supported for all database types by Oracle Data Safe B. Data Safe provides a way to mask sensitive data C. Data Safe supports only On-Premises Databases D. Data Safe lets audit user activity on your databases	C. Data Safe supports only On-Premises Databases
32. Which statement is incorrect about Autonomous Database Automatic Indexing? A. Automatic indexing automates the index management tasks B. Auto indexing is enabled by default in Autonomous Database C. Automatic indexing feature monitors the applications workload and maintains indexes automatically D. Automatic indexing runs at a fixed interval as an automatic task	B. Auto indexing is enabled by default in Autonomous Database
33. What is the maintenance schedule option available for Autonomous Container Database? A. Month of the week B. Year of the decade C. Day of New Year D. Week of the month, day of the week and time	D. Week of the month, day of the week and time
34. What are the pre-requisites to configure a private endpoint for Autonomous Database? Select two correct answers. A. At least one Network Security Group must be specified within the VCN B. At least one WAF must be configured within the VCN C. Data Guard must be configured for ADB D. VCN must be created within the region that will contain the Autonomous Database	A. At least one Network Security Group must be specified within the VCN D. VCN must be created within the region that will contain the Autonomous Database
35. What are the best practices for Oracle Autonomous Database alarms? Select two correct answers. A. Activate alarms during investigation B. Suppress alarms during investigation C. Determine invalid alarm intervals for a given metric D. Tune your alarms on regular basis	B. Suppress alarms during investigation D. Tune your alarms on regular basis
36. A company’s security admin has identified that an Autonomous database user with an instance wallet key is compromised. As an autonomous database admin, what should you do to protect the instance? A. Delete the user B. Delete the instance wallet and create a new wallet C. Delete the instance and spin up a new instance D. Rotate the instance wallet	D. Rotate the instance wallet
37. Which statements are correct about Autonomous Transaction Processing (ATP) database? Select two correct answers. A. ATP stores data in columnar format B. ATP stores data in row format C. Memory for Caching to Avoid IO D. Memory Speeds Joins and Aggregate	B. ATP stores data in row format C. Memory for Caching to Avoid IO
38. A data scientist needs to connect Python applications to Oracle Database for Logistic Regression algorithm. How can the above requirement be met? A. There is no interface to connect python applications to Oracle database B. PL/SQL C. Python SDK D. cx_Oracle interface	D. cx_Oracle interface
39. To build web and low-code applications which Autonomous Database Developer tool can be used? A. Python B. Application Express (APEX) C. SQL D. C++	B. Application Express (APEX)
40. What are the utilities that can be used for loading data into Autonomous Database? Select two correct answers. A. Oracle GoldenPump B. SQL Workbench C. Oracle Application Express (APEX) D. DBMS_CLOUD Package	C. Oracle Application Express (APEX) D. DBMS_CLOUD Package
41. Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.) A. through the Oracle Cloud Infrastructure service console B. through SQL/Developers C. using DBMS_CLOUD_ADMIN package D. through SQLPIus	B. through SQL/Developers D. through SQLPIus
42. When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.) A. DBNAME_MEDIUM B. DBNAME_HIGH C. DBNAME_CONCURRENT D. DBNAME_LOW	D. DBNAME_LOW
43. 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 keys cannot 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".
44. Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint? (Choose three.) A. Security List B. Route Table C. Subnet D. VCN E. Network Security Group	C. Subnet D. VCN E. Network Security Group
45. Which three event types are supported for Autonomous Database? (Choose three) A. Update IORM Begin B. Maintenance Begin C. Terminate End D. Change Autoscaling Configuration Compartment E. Change Compartment Begin	B. Maintenance Begin C. Terminate End E. Change Compartment Begin
46. When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean? (Choose the best answer) A. The SQL statement is executing. B. The SQL statement did not complete either due to an error. C. The SQL statement is queued. D. The SQL statement completed its execution.	C. The SQL statement is queued.
47. Which three are use cases for graph studio? A. 3-D Modelling B. Churn analysis C. Pattern matching D. Facial recognition E. Clustering	A. 3-D Modelling C. Pattern matching E. Clustering
48. When enabling auto-scaling, which two options change? (Choose two) A. Number of OCPUs displayed in the console. B. Amount of storage C. parallelism settings D. I/O resources E. Level of concurrency	A. Number of OCPUs displayed in the console. D. I/O resources
49. Which can be Scaled independently of the number of CPUs in an Autonomous Database? A. Memory B. Concurency C. Parallelism D. Storage E. Sessions	D. Storage
50. What happened with the standby database when disabling autonomous Data Guard? A. The standby database is started readwrite B. The standby database is transformed in a refreshable clone C.The standby database is terminated D.The standby database is started read only	C.The standby database is terminated
51. 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? (Choose the best answer.) A. 2700 B. 1500 C. 900 D. 1800	A. 2700
52. Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance? A. TPPERFORMANT B. TPURGENT C. LOW D. MEDIUM E. HIGH	A. TPPERFORMANT
53. 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.
54. Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure? A.Microsoft SQL Server (.mdf) B.Avro C.Data Pump Export File D.Parquet E.JSON.	A.Microsoft SQL Server (.mdf)
55. Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure? A.Google Cloud Storage B.Oracle Cloud Infrastructure Object Storage C.Oracle Cloud Infrastructure Object Storage Classic D.Amazon S3.	A.Google Cloud Storage
56. In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization? A.Compartment quotas B. Oracle Machine Learning notebook C.SQL Developer Web Console D.Resource Manager settings.	A.Compartment quotas
57. Which statement is not correct when the Autonomous Database is stopped? A.User with DWROLE can still access the database B.Tools are no longer able to connect to a stopped instance C.CPU billing is halted D.In-flight transactions queries are stopped.	A.User with DWROLE can still access the database
58. According to Oracle documentation, What is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups? A.Create a Separate VCN that contains only public subnets B. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised C.Create at least 2 of each resource D.Only 1 of each is allowed to be allocated per environment.	C.Create at least 2 of each resource
59. How do you change the tablespace quota for a user ADBUSER on Autonomous Database on Shared Infrastructure? A. Execute alter tablespace DATA set quota = 10G B.Execute alter tablespace for user ADBUSER tablespace DATA quota = 10G C.Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => ADBUSER ,tablespace_quota => UNLIMITED) D.Execute alter user ADBUSER quota unlimited on tablespace DATA.	C.Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => ADBUSER ,tablespace_quota => UNLIMITED)
60. Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database? A. A Private Endpoint is required to connect to the Shared-Autonomous Database B. The OCI compute instance does not support connecting to a Shared Autonomous Database C. The Autonomous Database must be in the same VCN and Subnet as the Compute instance D.The OCI compute instance can be used with an Always-Free Autonomous Database account.	D.The OCI compute instance can be used with an Always-Free Autonomous Database account.
61. Which two options are available to restore an Autonomous Data Warehouse? (Choose two.) A.Select the archived redo logs B. Specify the point in time (timestamp) to restore C.Backup and recovery must be done using Recovery Manager (RMAN) D.Select the backup from which restore needs to be done E.Select the snapshot of the backup.	B. Specify the point in time (timestamp) to restore D.Select the backup from which restore needs to be done
62. 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 move Autonomous DB between compartments C.You can use Service console to manage runaway SQL statements on Autonomous DB D. You can use Service console to create manual backups of Autonomous database.	C.You can use Service console to manage runaway SQL statements on Autonomous DB
63. Which Autonomous Database Cloud service ignores hints in SQL Statements by default? A.Both services ignore hints by default B.Autonomous Data Warehouse C. Autonomous Transaction Processing D.Neither service ignores hints by default.	B.Autonomous Data Warehouse
64. 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? A.Create a database user with the APEX role B.Create an IDCS user with the APEX role C.Create a new developer account D.Access the APEX Administration Services and create the workspace for the developer.	D.Access the APEX Administration Services and create the workspace for the developer.
65. Which method will NOT permit you to change the database Admin Password of an Autonomous Database on Shared Infrastructure? A.OCI CLI B.OS command line from the database server C.SQLDeveloper D.Admin page of the Cloud Service Console.	B.OS command line from the database server
66. While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads? A.Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar B.Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake C.Autonomous Data Warehouse workloads are optimized for mixed workloads D.Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.	A.Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar
67. What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? (Choose two.) A.Users can customize the maintenance schedule B.Users have SYS privileges in the database C.Users have OS access to the database machine D. It offers greater control and isolation starting at the Exadata cloud infrastructure level E. Users can customize the OS stack and add additional packages.	A.Users can customize the maintenance schedule D. It offers greater control and isolation starting at the Exadata cloud infrastructure level
68. Which Database action tool is used to get information about the entities in your Autonomous database and to see the effect that changing an object has on other objects? A. Data Insights B.Catalog C. Data Load D.JSON	B.Catalog
69. 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 an IDCS user. Create a database user with connect, resource, and object privileges B.Create a database user with the default privileges C. Create a database user with connect, resource, and object privileges D.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.	D.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.
70. Which statement is FALSE for Oracle Data Safe? (Choose the best answer.) A.Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user B. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary C.Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations D.Oracle Data Safe only supports Autonomous Databases.	D.Oracle Data Safe only supports Autonomous Databases.
71. Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose three) A. Suppress alarms during investigations B.Use a single interval for all alarms C.Select the correct alarm interval for your metric D.Create multiple alarm metrics Create a single alarm for each metric E.Routinely tune your alarms.	A. Suppress alarms during investigations C.Select the correct alarm interval for your metric E.Routinely tune your alarms.
72. Which statement is true when you provision an Autonomous Database using the cloning method? A.There is only one type of cloning option available in Autonomous Database B.A clone database source can be a running database instance C.A clone database source can be from a point-in-time backup that is less than 2 hours old D.You can clone a database in a security zone to create a database that isn't in a security zone.	B. A clone database source can be a running database instance
73. Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated? A. Week of the Quarter, Day of the Week, Start Hour B.Month of the Year, Week of the Month, Day of the Week, Start Hour C.Month of the Quarter, Week of the Month, Day of the Week, Start Hour D.Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour.	C.Month of the Quarter, Week of the Month, Day of the Week, Start Hour
74. Which statement is NOT correct when setting up compartment quotas? A.Compartment quotas use policies that allow allocation of resources with a high level of flexibility B.There are three types of quota policy statements which are set, unset and zero C.Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending D.Compartment quotas are set by Oracle.	D.Compartment quotas are set by Oracle.
75. 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? A.APEX B.Business Models C.Data Load D.SQL Developer	B.Business Models
76. An Autonomous Database (ADB) user with an instance wallet has left the company and shared 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.Delete the user B.Shutdown and restart the instance C.Rotate the instance wallet and share the new wallet with the remaining users D.Trust the user who left, not to access the database.	C.Rotate the instance wallet and share the new wallet with the remaining users
77. When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database? A.1 hours B.2 hours C. 24 hours D.30 minutes.	B.2 hours
78. Which workload type does the Autonomous Database on dedicated infrastructure service currently support? A.Hybrid Columnar compression B.Autonomous Transaction Processing only C.Autonomous Data Warehouse only D.ATP and ADW.	D.ATP and ADW.
79. In Graph Studio which you can use to create a graph? A.Graph created by a special tool downloaded from Oracle.com B.A graph license key C. NoSQL configuration D.Graph analytics algorithms E.Tables in an Autonomous Database instance.	E.Tables in an Autonomous Database instance.
80. Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? (Choose two.) A.Compression is enabled by default. .Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default B.Parallelism is not enabled by default C. You have direct access to the database node D. Oracle Database Result Cache is enabled by default for all SQL statements.	A.Compression is enabled by default. .Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default D.Oracle Database Result Cache is enabled by default for all SQL statements.
81. While creating a business model what advanced options you can enable or disable? (Choose three) A.Business Object Security Feature B.Autonomous Aggregate Cache C.Analytic View Base Table Query Transformation D.Analytic View Transparency View E.Display private tables.	B.Autonomous Aggregate Cache C.Analytic View Base Table Query Transformation D.Analytic View Transparency View
82. For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access? A.ORDS_PRIV.ENABLE_SCHEMA B.ORDS_ADMIN.ENABLE_SCHEMA C.SQLDEV_ADMIN.GRANT_SCHEMA D.ORDS_ADMIN.GRANT_SCHEMA.	B.ORDS_ADMIN.ENABLE_SCHEMA
83. You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do? A.Create a notification alert using DBMS_SNMP package B.Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END" C.Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database 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"
84. What are three methods to load data into the Autonomous Database? (Choose three.) A.Transportable Tablespace B.SQL*Loader C.Oracle Data Pump D.RMAN Restore E.Oracle GoldenGate.	B.SQL*Loader C.Oracle Data Pump E.Oracle GoldenGate.
85. Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.) A.Use SFTP to copy CSV files into Autonomous Database B.Use Recovery Manager (RMAN) C.Use Data Pump D.Use GoldenGate E.Use Oracle Zero Downtime Migration (ZDM).	C.Use Data Pump D.Use GoldenGate E.Use Oracle Zero Downtime Migration (ZDM).
86. What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure? A. exec dbms_cloud_admin.enable_app_cont(' ') B.alter database set application_continuity=true C. alter system set application_continuity=true D. alter session set application_continuity=true.	A. exec dbms_cloud_admin.enable_app_cont(' ')
87. Which statement is FALSE regarding the auto scaling feature? (Choose the best answer.) A. The base number of OCPU cores allocated to a database is not guaranteed B. 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 C. 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. D. Auto scaling is enabled by default and can be enabled or disabled at any time.	A.The base number of OCPU cores allocated to a database is not guaranteed
88. In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization? A.Compartment quotas B.Oracle Machine Learning notebook C.SQL Developer Web Console D.Resource Manager settings.	A.Compartment quotas
89. How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console? A.Using Database Configuration Assistant (DBCA) on the database server B.It cannot be done C.Connecting to the Cloud Infrastructure Command console via SSH wallet D.Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.	D.Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
90. Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure? A.Transaction Count, Sessions, Running Statements B.IOPS, Storage Space Used By Tablespace, Apply and Transport Lag C.CPU Utilization, Storage Utilization D.Query Latency, User Calls, Execute Count.	B.IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
91. A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.How does the developer connect to and interact with ADB from Python? A.SQL Developer B.The Oracle Client and the cx_Oracle interface for Python C.You can't use Python with ADB D. JAVA JDK.	B.The Oracle Client and the cx_Oracle interface for Python
92. 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 Listener endpoint where the Autonomous Database should register on B.the Client Credentials wallet which is used to connect to the Autonomous Database C.the Compartment of the Dedicated infrastructure as each compartment only runs one Dedicated environment D.the container database in which the Autonomous instance should run.	D.the container database in which the Autonomous instance should run.
93. Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s). How can they achieve this? A. Change the Automatic Maintenance Schedule to None B.Change the Automatic Maintenance Schedule to No Preference C.You cannot permanently disable scheduled Automatic Maintenance D.Change the Automatic Maintenance Schedule to specify a Schedule but do not select any month, week or day.	C.You cannot permanently disable scheduled Automatic Maintenance
94. Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure? A. inside the backups of the container database B. inside the Autonomous Database wallet C. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted D.in a separate key vault external to the Exadata Infrastructure.	D.in a separate key vault external to the Exadata Infrastructure.
95. When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported? A. Schemas B.Data C.Reports D.Tablespaces.	A. Schemas B.Data
96. Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources? A.Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure B.Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure C.Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database D. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator.	C.Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
97. What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments ? A.Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources B.Fleet Administrators create, monitor and manage Autonomous Databases C.Fleet Administrators are responsible for patching and backups of all container databases D.Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.	B.Fleet Administrators create, monitor and manage Autonomous Databases
98. Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment? A.You do not need to have sufficient access permissions on the compartment that the resource is being moved to B.Moving an Autonomous Database instance does not include its automatic backups C.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 D.Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.	C.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
99. Which two statements are true about Data Insights? A. Data Insights is available with on-premises deployments of Oracle Database B.You can retrieve previously executed Data Insights searches C.Data Insights is an additional priced option D.You can search for Data Insights against a base table or business model.	B.You can retrieve previously executed Data Insights searches D.You can search for Data Insights against a base table or business model.
100. For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned? (Choose the best answer.) A.Allow group ADB-Admins to manage autonomous-database in tenancy B.Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'DW' C. Allow group ADB-Admins to manage autonomous-database-family in tenancy D.Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'.	C. Allow group ADB-Admins to manage autonomous-database-family in tenancy
101. 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)? A.Unplug to an xml file so database files and xml file can be uploaded to object storage B.Create a database link from source database to the ADB environment and clone the PDB C.Unplug into a pdb archive which can be uploaded to object storage D.Pluggable databases cannot be migrated to ADB using plug, unplug or clone.	D.Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
102. Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse? (Choose the best answer.) A.You can control behavior at the statement level using the USE_AUTO_INDEXES or NO_USE_AUTO_INDEXES hints B.The indexing feature is implemented as an automatic task that runs at a fixed interval C.Process includes identify candidates, create invisible auto indexes, verify with implement if performance improved and delete unused D.You can use the DBMS_AUTO_INDEX package to report on the automatic task and to set your preferences E. It is enabled by default.	E. It is enabled by default.
103. Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.) A.Golden Gate on-premise installation B. Golden Gate Cloud service C. PDB unplug / plug operation D.RMAN Cross-Platform backup and restore E. Dataguard Physical Standby F.Datapump export / import.	A.Golden Gate on-premise installation B. Golden Gate Cloud service F.Datapump export / import.
104. Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.) A.Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet B.Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet C.Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials D.Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet E.Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).	B.Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet E.Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
105. Which three optimization techniques are different in autonomous data warehouse and autonomous transaction processing? A. Backup Retention B. Index Storage C.Data Organization D.Memory Usage E.Undo Management	B. Index Storage C.Data Organization D.Memory Usage
106. To who, and in which order, are dedicated Exadata Infrastructure resources provisioned ?(Choose the best answer.) A. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator > Autonomous DB B. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure C.Fleet Administrator, Autonomous Exadata Infrastructure > Database Administrator -> Autonomous Container DB -> Autonomous DB D. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB.	A. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator > Autonomous DB
107. Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.) A.The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store B. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure C.The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage D.The target table will be created in Autonomous Database if it does not already exist The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.	B. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure C.The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage
108. While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance? (Choose the best answer.) A.Prior Release Update Revision (PRUR) B.Prior Release Update (PRU) C. Quarterly Bundle Patch (QBP) D.Release Update (RU).	D.Release Update (RU).
109. Which three security features are available in Oracle Autonomous Database Shared Infrastructure? (Choose three.) A.Audit Vault B.Transparent Data Encryption C.Database Vault D.Customer Managed Key E.Data Redaction.	B.Transparent Data Encryption C.Database Vault D.Customer Managed Key

Descubre

Crear Tarjetas

Acerca de Nosotros

Explore Tarjetas

Comparta este Set de Tarjetas de Aprendizaje

Tarjetas de Aprendizaje relacionadas

1Z0-931-21 - Oracle Autonomous Database Cloud 2021 Specialist

Cómo estudiar sus tarjetas

Rango de Cartas a estudiar

109 Cartas en este set