Free Oracle 1Z0-931-20 Study Guides Exam Questions & Answer
1Z0-931-20 Exam Dumps, 1Z0-931-20 Practice Test Questions
Oracle 1Z0-931-20: PeopleSoft 9.2 Database cloud Essentials Certification Path
The 1Z0-931-20 Certification is a basic level certification organized by Oracle mainly focusing on the database cloud skillset. There is no prerequisite for this exam. Candidates can easily get through with the 1Z0-931-20 exam provided the candidates have proper study material. Going through the 1Z0-931-20 practice test is very important if candidates want to crack this exam. A combination of 1Z0-931-20 practice exams and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
NEW QUESTION 56
Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)
- A. Users are given OS logons or SYSDBA privileges to prevent phishing attacking.
- B. Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.
- C. Data is encrypted at rest using transparent data encryption.
- D. Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.
Answer: B,C,D
Explanation:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html
NEW QUESTION 57
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
- A. Select the backup from which restore needs to be done.
- B. Select the snapshot of the backup.
- C. Backup and recovery must be done using Recovery Manager(RMAN).
- D. Specify the point in time (timestamp) to restore.
- E. Select the archived redo logs.
Answer: A,D
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 58
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
- A. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
- B. It is enabled by default.
- C. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
- D. The indexing feature is implemented as an automatic task that runs at a fixed interval.
- E. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
Answer: D
NEW QUESTION 59
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. Quarterly Bundle Patch (QBP)
- C. Prior Release Update (PRU)
- D. Prior Release Update Revision (PRUR)
Answer: A
NEW QUESTION 60
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/Developer s
- C. using DBMS_CLOUD_ADMIN package
- D. through SQLPIus
Answer: B,D
Explanation:
https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-service
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B
NEW QUESTION 61
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Index Storage
- B. Memory Usage
- C. Undo Management
- D. Data Organization
- E. Backup Retention
Answer: A,D
NEW QUESTION 62
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?
- A. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
- B. Create at least 2 of each resource
- C. Only 1 of each is allowed to be allocated per environment.
- D. Create a separate VCN that contains only public subnets
Answer: A
NEW QUESTION 63
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- A. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
- B. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
- C. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
- D. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- E. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
Answer: A,B,D
Explanation:
DELETE_FILE Procedure
This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.
CREATE_CREDENTIAL Procedure
This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. Use stored credentials for data loading or for querying external data residing in the Cloud.
PUTJDBJECT Procedure
This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).
VALIDATE EXTERNAL TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.
To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.
This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.
VALIDATE_EXTERNAL_TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Database. The overloaded form enables you to use the operation_id parameter.
PUT_OBJECT Procedure
This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB) DELETE FILE Procedure This procedure removes the specified file from the specified directory on Autonomous Database.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.
NEW QUESTION 64
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?
- A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType =
`DW' - B. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
- C. Allow group ADB-Admins to manage autonomous-database in tenancy.
- D. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType =
'OLTP'
Answer: D
NEW QUESTION 65
Which statement is correct about the version of Java that is recommended for use with tools that use Java Database Connectivity (JDBC) connections?
- A. Java Development Kit Version 7
- B. JDBC drivers do NOT support multiple Java Developer Kit versions.
- C. JDBC .Jar files are specific to each platform.
- D. Java Development Kit Version 8 or higher
- E. It doesn't matter, but you must Install the JCE Unlimited Strength Policy Files.
Answer: C
NEW QUESTION 66
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- A. SSH keys cannot be added from console. They have to be added using REST APIs only.
- B. SSH keys are not required in Oracle Cloud Infrastructure.
- C. Navigate to Identity, select Users panel on the console and select "Add Public Key".
- D. On the Autonomous Database Console.
Answer: C
Explanation:
- In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user's name to view the details.
-Click Add Public Key.
- Paste the key's value into the window and click Add.
NEW QUESTION 67
When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?
- A. CWALLET.SSO
- B. TNSNAMES.ORA
- C. OJDBC.PROPERTIES
- D. SQLNET.ORA
Answer: A
Explanation:
Create the Autonomous Data Warehouse Connection in Oracle Analytics Cloud.
- Sign in to Oracle Analytics Cloud.
- On the Home page, click Connect to Oracle Autonomous Data Warehouse.
- In Create Connection, enter a Connection Name, for example, MyADW_connection.
- In Description, enter a brief description.
- Click Select next to Client Credentials. In File Upload, select the wallet zip file from your download location. The Client Credentials field is populated with cwallet.sso, and the Service Name field contains a value.
- Enter your Oracle Autonomous Data Warehouse Username and Password.
- From the Service list, select the service for your data, and then click Save.
https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/oac_ee_dv/create_adwc_connection/html/index.html
NEW QUESTION 68
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
- A. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
- B. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
- C. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
- D. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
- E. The target table will be created in Autonomous Database if it does not already exist.
Answer: A,C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/file-uri-formats.html#GUID-5D3E1614-ADF2-4DB5-B2B2-D5613F10E4FA
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID-9428EA51-5DDD-43C2-B1F5-CD348C156122
NEW QUESTION 69
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 Client Credentials wallet which is used to connect to the Autonomous Database
- B. the 'High Availability Container Database' in which the Autonomous instance should run
- C. the Listener endpoint where the Autonomous Database should register on
- D. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
- E. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
Answer: A
NEW QUESTION 70
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?
- A. OCPUs and storage can be scaled independently.
- B. Storage in TB cannot be larger than the number of OCPUs.
- C. Increasing OCPUs will automatically increase storage.
- D. OCPUs and storage must remain in sync.
Answer: A
Explanation:
You simply specify the number of OCPUs and the storage capacity in TB's for the database. At any time, you may scale, increase or decrease either the OCPUs or the storage capacity.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-add-resources.html#GUID-DA72422A-5A70-42FA-A363-AB269600D4B0
NEW QUESTION 71
The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?
- A. MODIFY_SNAPSHOT_SETTINGS
- B. CREATE_BASELINE_TEMPLATE
- C. UPDATE_OBJECT_INFO
- D. MODIFY_BASELINE_WINDOW_SIZE
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#GUID-4A1E8FCA-FAF1-43F5-93E0-559C0145D6C3 The retention time can be changed by modifying the Automatic Workload Repository retention setting with the PL/SQL procedure DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS. Be aware that increasing the retention time will result in more storage usage for performance data
NEW QUESTION 72
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. alter database set application_continuity=true
- B. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- C. alter session set application_continuity=true
- D. alter system set application_continuity=true
Answer: D
NEW QUESTION 73
What is the default retention period for both Automatic and Manual Autonomous Database Backups?
- A. 7 days
- B. 30 days
- C. 60 days
- D. 90 days
- E. One Year
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backup- manual.html#GUID-D95E5D6A-C470-4A68-9545-CC99D937E7D1
NEW QUESTION 74
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
- A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
- B. ADW since operational reporting is a higher priority in this scenario.
- C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
- D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
Answer: D
Explanation:
Autonomous Transaction Processing provides all of the performance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store.
As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.
NEW QUESTION 75
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?
- A. Oracle Machine Learning notebook
- B. Compartment quotas
- C. SQL Developer Web Console
- D. Resource Manager settings
Answer: D
NEW QUESTION 76
......
Latest 1Z0-931-20 Actual Free Exam Questions Updated 118 Questions: https://www.certkingdompdf.com/1Z0-931-20-latest-certkingdom-dumps.html