Oracle 1Z0-931-21 Dumps - 100% Cover Real Exam Questions (Updated 114 Questions)
Real 1Z0-931-21 dumps - Real Oracle dumps PDF
Oracle 1Z0-931-21 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
NEW QUESTION 64
Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?
- A. 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.
- B. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
- C. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
- D. 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.
Answer: D
Explanation:
Exadata infrastructure maintenance takes place at least once each quarter and is mandatory.
If a scheduled container database maintenance run cannot take place (because of changes made to infrastructure maintenance scheduling or other reasons) , Oracle will automatically reschedule the container database maintenance for the following quarter.
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.
Exadata infrastructure maintenance patches the Exadata infrastructure (including patching of the Exadata grid infrastructure code and operating systems updates), and DO NOT include database patching.
NEW QUESTION 65
Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?
- A. 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.
- B. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
- C. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
- D. 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.
Answer: D
NEW QUESTION 66
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?
- A. In a separate key vault external to the Exadata Infrastructure
- B. inside the Autonomous Database wallet
- C. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted
- D. inside the backups of the container database
Answer: A
NEW QUESTION 67
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?
- A. Sessions
- B. Memory
- C. Concurency
- D. Parallelism
- E. Storage
Answer: E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:
NEW QUESTION 68
Which two statements are true about accessing Autonomous Database Tools?
- A. Oracle APEX can be accessed only from the Developer menu in the Service Console.
- B. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
- C. 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.
- D. SQL Developer Web is available exclusively on the Autonomous Database.
- E. Access to Database Actions is available for all users of Autonomous Database.
Answer: A,C
NEW QUESTION 69
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.
Answer: D
Explanation:
The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.
https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using-oci-curl Examples of using Autonomous Database managing by REST API
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/LabGuide900ConfigureOCI-CLI.md
NEW QUESTION 70
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 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 helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
- D. Oracle Data Safe only supports Autonomous Databases.
Answer: D
Explanation:
https://www.oracle.com/database/technologies/security/data-safe.html
https://www.oracle.com/a/tech/docs/dbsec/data-safe/faq-security-data-safe.pdf Data Safe works with the following Oracle Databases Oracle on-Premises Databases Oracle Cloud Databases
− Autonomous Database on Shared Exadata Infrastructure
− Autonomous Database on Dedicated Exadata Infrastructure
− Exadata DB systems
− Database Cloud Service on Virtual Machine
− Database Cloud Service on Bare Metal
− Oracle Database on Compute
NEW QUESTION 71
Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)
- A. Oracle Cloud Infrastructure Object Storage Classic
- B. Azure Blob Storage
- C. Oracle Cloud Infrastructure Object Storage
- D. Google Cloud Storage
- E. Amazon S3
Answer: A,C
Explanation:
Reference:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpud/load-data-using-oracle-data-pump.html#GUID-
025C4566-1BDB-4EF2-BFB7-0CBA8C47EA5D
Data Pump Import lets you import data from Data Pump files residing on the Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.
You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to Autonomous Database.
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/index.html#ADBBK-GUID-37922C56-0412-45CD-B10C-2088A000113F
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
NEW QUESTION 72
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: E
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION 73
While creating a business model what advanced options you can enable or disable? (Choose three)
- A. Business Object Security Feature
- B. Analytic View Transparency View
- C. Analytic View Base Table Query Transformation
- D. Display private tables
- E. Autonomous Aggregate Cache
Answer: B,C,E
Explanation:
NEW QUESTION 74
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
- A. All resource management rules are cloned.
- B. All OML notebooks are cloned.
- C. Current settings for ACLs are cloned.
- D. All underlying data for OML notebooks is cloned.
- E. Clone can be in a different region.
Answer: A,B
NEW QUESTION 75
Which statement is correct about managing and monitoring of Autonomous Database?
- A. You can use Service console to create manual backups of Autonomous database.
- B. You can use Service console to enable or disable auto scaling of Autonomous DB.
- C. You can use Service console to move Autonomous DB between compartments.
- D. You can use Service console to manage runaway SQL statements on Autonomous DB.
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-sql-statements.html#GUID-4861BA7F-F9FA-4909-8DC0-4F46AFF80706
NEW QUESTION 76
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. Create a database link from source database to the ADB environment and clone the PDB.
- B. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
- C. Unplug to an xml file so database files and xml file can be uploaded to object storage.
- D. Unplug into a pdb archive which can be uploaded to object storage.
Answer: B
Explanation:
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.
NEW QUESTION 77
When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?
- A. 2 hours
- B. 1 hours
- C. 24 hours
- D. 30 minutes
Answer: A
Explanation:
Clone Sources
You can use a running database to create a clone. For databases running on shared Exadata infrastructure, you can also use a backup as the source of your clone. When using a backup, you can select a listed backup to clone from, or create a point-in-time clone. Point-in-time clones contain all data up to a specified timestamp. The specified timestamp must be in the past.
Note When you create a clone from a backup, you must select a backup that is at least two hours old.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbcloning.htm
NEW QUESTION 78
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 Administrator defines and gains access to the ADMIN administrative user account for the database.
- C. Fleet Administrators create, monitor and manage Autonomous Databases.
- D. Fleet Administrators are responsible for patching and backups of all container databases.
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbah/index.html#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/index.html
NEW QUESTION 79
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?
- A. Database Vault
- B. Customer Managed Keys
- C. Audit Vault
- D. Data Redaction
- E. Transparent Data Encryption
Answer: A,B,E
Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3
NEW QUESTION 80
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 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 helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
- D. Oracle Data Safe only supports Autonomous Databases.
Answer: D
NEW QUESTION 81
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.
Other than changing the shared user password, what can the admin do to protect the instance?
- A. Rotate the instance wallet and share the new wallet with the remaining users.
- B. Shutdown and restart the instance.
- C. Delete the user.
- D. Trust the user who left to not access the database.
Answer: A
Explanation:
NEW QUESTION 82
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?
- A. Users have SYS privileges in the database.
- B. Users have OS access to the database machine.
- C. Users can customize the OS stack and add additional packages
- D. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
- E. Users can customize the maintenance schedule.
Answer: A,D
NEW QUESTION 83
Which statement is FALSE about Oracle Data Safe?
- A. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.
- B. It supports only Autonomous Databases.
- C. It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements.
- D. It evaluates user types, how users are authenticated, and the password policies assigned to each user.
- E. It helps you assess the security of your cloud database configurations by analyzing database configurations.
Answer: C
NEW QUESTION 84
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
- A. Backup and recovery must be done using Recovery Manager(RMAN).
- B. Select the snapshot of the backup.
- C. Specify the point in time (timestamp) to restore.
- D. Select the archived redo logs.
- E. Select the backup from which restore needs to be done.
Answer: C,E
Explanation:
In the Restore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkup-recover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C
NEW QUESTION 85
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
- A. Query Latency, User Calls, Execute Count
- B. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
- C. CPU Utilization, Storage Utilization
- D. Transaction Count, Sessions, Running Statements
Answer: C
NEW QUESTION 86
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. OCI CLI
- B. OS command line from the database server.
- C. Admin page of the Cloud Service Console
- D. SQLDeveloper
Answer: A
NEW QUESTION 87
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?
- A. Release Update (RU)
- B. Prior Release Update (PRU)
- C. Prior Release Update Revision (PRUR)
- D. Quarterly Bundle Patch (QBP)
Answer: A
Explanation:
On the Edit Automatic Maintenance card, select Release Update (RU) or Release Update Revision (RUR) from the Maintenance type list.
Note:
Currently, the Release Update Revision (RUR) maintenance type is not a selectable option. When release update revisions become available for Autonomous Database, this option will become selectable.
NEW QUESTION 88
......
Realistic Exams-boost 1Z0-931-21 Dumps PDF - 100% Passing Guarantee: https://www.exams-boost.com/1Z0-931-21-valid-materials.html
Free Oracle 1Z0-931-21 Exam Questions and Answer: https://drive.google.com/open?id=1j69wjWhMjCi0hZbwe9YPXHeSYNBc5UYn