Pass Your Oracle 1z0-931-23 Exam with Correct 183 Questions and Answers
Latest [Jul 25, 2024] 2024 Realistic Verified 1z0-931-23 Dumps
Oracle 1z0-931-23 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION # 95
You see a clock icon in the Status column on the SQL Monitoring tab of Performance Hub. What does it indicate?
- A. The SQL statement completed its execution.
- B. The SQL statement did not complete due to an error.
- C. The SQL statement is executing.
- D. The SQL statement is queued.
Answer: D
Explanation:
The clock icon indicates that the SQL statement is waiting for resources to execute. This can happen when the database is busy or when the statement has a lower priority than other statements. Reference:
Monitor Databases with Autonomous Database Metrics - Oracle Help Center, section "View Autonomous Database Metrics for a Database", subsection "View SQL Monitoring Details".
Using Oracle Autonomous Database Serverless, section "Monitor Performance", subsection "SQL Monitoring".
NEW QUESTION # 96
Which are the two restrictions for an Always Free Autonomous Database?
- A. supports only ATP as a workload type
- B. maximum of one OCPU per Database
- C. Oracle Application Express (APEX) not included
- D. maximum of two Always Free Databases per OCI tenancy
Answer: B,D
NEW QUESTION # 97
Which two actions are available to perform when an Autonomous Database is stopped?
- A. Update Network Access
- B. Start
- C. Update License Type
- D. Change administrator password
Answer: B,C
NEW QUESTION # 98
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
Answer: B
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 # 99
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 evaluates user types, how users are authenticated, and the password policies assigned to each user.
- B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
- 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.
Answer: C
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 # 100
Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?
- A. Month of the Quarter, Week of the Month, Day of the Week, Start Hour
- B. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
- C. Month of the Year, Week of the Month, Day of the Week, Start Hour
- D. Week of the Quarter, Day of the Week, Start Hour
Answer: A
Explanation:
NEW QUESTION # 101
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
- A. It is enabled by default.
- B. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
- C. The indexing feature is implemented as an automatic task that runs at a fixed interval.
- D. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
- E. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
Answer: A
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 # 102
When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?
- A. scan hybrid partition tables
- B. prun column in parquet files
- C. Scan partition tables
- D. prun columns in csv files
Answer: C
NEW QUESTION # 103
You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling?
- A. Use a REST call to enable Auto Scaling
- B. Click Scale Up/Down and select the Auto Scaling checkbox
- C. Use a REST call to shut down the instance, then a second REST call to enable Auto Scaling, and a REST all to restart the instance
- D. Shut down the instance, click Scale Up/Down and select the Auto Scaling checkbox, then restart the instance
Answer: A,B
NEW QUESTION # 104
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. 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. The base number of OCPU cores allocated to a database is not guaranteed.
- D. Auto scaling is enabled by default and can be enabled or disabled at any time.
Answer: C
NEW QUESTION # 105
Which three scaling options are available in Oracle Autonomous Database on Shared Infrastructure?
- A. Manual online scaling of Storage
- B. Manual offline scaling of Storage and OCPU
- C. Manual online scaling of OCPU
- D. Automatic online scaling of Storage
- E. Automatic online scaling of OCPU
Answer: B,D,E
NEW QUESTION # 106
Which statement is FALSE regarding database links?
- A. You can connect to a remote database from an Autonomous Database by using a database line
- B. You can connect to an Autonomous Database from a remote database using a database link
- C. You can create a database link from one Autonomous Database to another Autonomous Database instance
- D. You can call PL/SQL procedures and functions by using a database link
Answer: D
NEW QUESTION # 107
Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?
- A. Month of the Quarter, Week of the Month, Day of the Week, Start Hour
- B. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
- C. Month of the Year, Week of the Month, Day of the Week, Start Hour
- D. Week of the Quarter, Day of the Week, Start Hour
Answer: A
NEW QUESTION # 108
Which two statements apply to the Autonomous Database service on Dedicated Infrastructure?
- A. You can set a maintenance window for an Autonomous Exadata Infrastructure
- B. You, as the customer, are responsible for all patching operations
- C. Patching occurs on the first Sunday of each quarter
- D. You can set a maintenance window for each individual Autonomous Container Database
Answer: A,D
NEW QUESTION # 109
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. Connecting to the Cloud Infrastructure Command console via SSH wallet.
- C. It cannot be done.
- 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 # 110
Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?
- A. Oracle Audit Vault, Oracle Key Vault
- B. Oracle Cloud Infrastructure Vault, Oracle Database Vault
- C. Oracle Database Vault, Oracle Key Vault
- D. Oracle Key Vault, Oracle Cloud Infrastructure Vault
Answer: B
NEW QUESTION # 111
Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?
- A. Data can be loaded from a remote database using Database Links (DBLinks)
- B. Data can be uploaded from several cloud storage sources including 53, Azure, Google Cloud and Oracle Object Storage
- C. Data formats supported include: text, csv, json, avro and parquet
- D. Data can be loaded from a local data source
- E. You must first manually create your database credentials using dms_cloud.create_credentia before accessing your Oracle Object Storage Bucket
Answer: E
NEW QUESTION # 112
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
- A. Data
- B. Schemas
- C. Reports
- D. Tablespaces
Answer: A,B
Explanation:
When using Data Pump to migrate your Oracle database to Autonomous Database, you can import data and schemas from Data Pump files. You cannot import tablespaces or reports. See Export Your Existing Oracle Database to Import into Autonomous Database for more details.
NEW QUESTION # 113
......
Get 2024 Updated Free Oracle 1z0-931-23 Exam Questions and Answer: https://examcollection.prep4king.com/1z0-931-23-latest-questions.html
