Download the Latest 1z0-931-22 Dumps - 2022 1z0-931-22 Exam Questions
Latest Oracle 1z0-931-22 Certification Practice Test Questions
NEW QUESTION 31
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?
- A. Parallelism
- B. Memory
- C. Storage
- D. Concurency
- E. Sessions
Answer: C
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 32
When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?
- A. 2 hours
- B. 24 hours
- C. 30 minutes
- D. 1 hours
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 33
Which two are correct actions to take in order to Download the Autonomous Database Credentials?
- A. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
- B. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
- C. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
- D. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
- E. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
Answer: C,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1
NEW QUESTION 34
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 in tenancy.
- C. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'
- D. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm
NEW QUESTION 35
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. Access the APEX Administration Services and create the workspace for the developer.
- C. Create an IDCS user with the APEX role.
- D. Create a new developer account.
Answer: B
Explanation:
https://docs.oracle.com/en/database/oracle/application-express/19.1/htmig/creating-workspace-and-adding-Oracle-AE-users.html#GUID-1040F145-452A-49D4-BCF6-A80851AFFA74 Create a New Instance Administrator Login to the INTERNAL workspace as the ADMIN user, or another existing admin user.
Click the "Create User" link on the right-hand menu.
For a new admin user enter mandatory items and the following.
Workspace : INTERNAL
Default Schema : APEX_180200 {or whatever the highest version is}
User is an administrator: Yes
Account Availability : Unlocked
Password and Confirmation Password.
Require Change of Password on First Use : Yes
Click the "Create User" button.
https://oracle-base.com/articles/misc/apex-tips-basic-apex-management
NEW QUESTION 36
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 37
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. SQL Developer Web is available exclusively on the Autonomous 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. Access to Database Actions is available for all users of Autonomous Database.
- E. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
Answer: A,C
NEW QUESTION 38
In which four ways can Oracle Database optimally access data in Object Storage?
- A. optimized data archive using partitioned external tables
- B. scan avoidance using partitioned external tables
- C. scan avoidance using block skipping when reading parquet and ore files
- D. scan avoidance using columnar pruning for .csv files
- E. optimized data archive using hybrid partitioned tables
- F. scan avoidance using columnar pruning for columnar stores like parquet and orc
Answer: A,B,E,F
NEW QUESTION 39
Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?
- A. Oracle Cloud Infrastructure Object Storage
- B. Oracle Cloud Infrastructure Object Storage Classic
- C. Azure Blob Storage
- D. Amazon S3
- E. Google Cloud Storage
Answer: A,B
NEW QUESTION 40
Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?
- A. Only ATP manages optimizer statistics.
- B. Only ADW supports autoscaling.
- C. Only ADW uses columnar compression by default.
- D. Only ATP supports automatic backups.
Answer: C
NEW QUESTION 41
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
- A. using DBMS_CLOUD_ADMIN package
- B. through SQLPIus
- C. through SQL/Developer s
- D. through the Oracle Cloud Infrastructure service console
Answer: B,C
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
"To create users in your database, connect to the database as the ADMIN user using any SQL client tool." https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-create.html#GUID-54CA837B-CD6A-4ED2-A960-5874535818CB
NEW QUESTION 42
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
- A. The indexing feature is implemented as an automatic task that runs at a fixed interval.
- B. It is enabled by default.
- C. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
- D. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
- E. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-index.html#GUID-D51A4F85-3AE5-4B7D-9B27-32CEDE8DBD79 - Auto Indexing is disabled by default in Autonomous Database
NEW QUESTION 43
Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database.
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Backup Retention
If you choose to enable automatic backups, you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, or 60 days. The system automatically deletes your incremental backups at the end of your chosen retention period.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/backingupOS.htm
NEW QUESTION 44
Which option should you use to create a graph with Graph Studio?
- A. NoSQL configuration
- B. Tables in an Autonomous Database instance
- C. Graph analytics algorithms
- D. A graph license key
- E. Graph created by a special tool downloaded from oracle.com
Answer: B
NEW QUESTION 45
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. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
- B. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
- C. ADW since operational reporting is a higher priority in this scenario.
- D. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
Answer: A
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 46
While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?
- A. 60 days
- B. 15 days
- C. 7 days
- D. 120 days
Answer: D
NEW QUESTION 47
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
- A. Data
- B. Schemas
- C. Tablespaces
- D. Reports
Answer: A,B
NEW QUESTION 48
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 Autonomous Database must be in the same VCN and Subnet as the Compute instance.
- C. The Autonomous Database must belong to a Network Security Group (NSG).
- D. The OCI compute instance does not support connecting to a Shared Autonomous Database.
- E. The OCI compute instance can be used with an Always-Free Autonomous Database account.
Answer: E
NEW QUESTION 49
When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?
- A. prun columns in csv files
- B. prun column in parquet files
- C. Scan partition tables
- D. scan hybrid partition tables
Answer: C
NEW QUESTION 50
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_CONCURRENT
- C. DBNAME_HIGH
- D. DBNAME_LOW
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION 51
Which statement is true when you provision an Autonomous Database using the cloning method?
- A. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
- B. A clone database source can be from a point-in-time backup that is less than 2 hours old.
- C. After an Autonomous database is created using a clone, the network access option can be changed.
- D. A clone database source can be a running database instance.
Answer: D
Explanation:
NEW QUESTION 52
......
Verified 1z0-931-22 Dumps Q&As - 1 Year Free & Quickly Updates: https://www.realvce.com/1z0-931-22_free-dumps.html
Get 2022 Updated Free Oracle 1z0-931-22 Exam Questions and Answer: https://drive.google.com/open?id=1kxD7OnV6mUgS4J1rcq2Jg5XQ_zPwq0YX