[Nov-2023] Pass Oracle 1z0-931-23 Exam in First Attempt Guaranteed!
Full 1z0-931-23 Practice Test and 175 unique questions with explanations waiting just for you, get it now!
NEW QUESTION # 50
Which statement is FALSE about Oracle Autonomous JSON Database?
- A. It supports NoSQL-style, document-centric application
- B. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
- C. JSON data is stored natively in the database
- D. There is a 20 GB limit on JSON collection
Answer: D
NEW QUESTION # 51
You enabled Autonomous Data Guard on Autonomous Database on Shared Infrastructure.
Which three statements are true about the standby database after a failover?
- A. Autonomous Data Guard automatically creates a new standby database
- B. The OCPU Count, Storage, Display Name, Database Name, Auto Scaling, Tags, and Licensing options have the same values as the primary
- C. A new wallet is required to connect to the standby database
- D. Oracle Machine Learning Notebooks created in the primary database are available in the standby database
- E. Autonomous Data Guard automatically reverts to the primary database when it becomes available again
Answer: A,B,D
NEW QUESTION # 52
Which three methods can be used to migrate on-premises databases to Oracle Autonomous Database (both Shared and Dedicated)?
- A. Original imp/exp tools
- B. Oracle Golden Gate
- C. Orace Zero Downtime Migration (ZDM)
- D. RMAN backup & restore
- E. Oracle Data Pump
- F. Physical migration methods, such as database cloning
Answer: B,C,E
NEW QUESTION # 53
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)
- A. Use Oracle Zero Downtime Migration (ZDM)
- B. Use Data Pump
- C. Use Recovery Manager (RMAN)
- D. Use SFTP to copy CSV files into Autonomous Database
- E. Use GoldenGate
Answer: A,B,E
Explanation:
https://www.oracle.com/sa/database/technologies/cloud-migration.html
NEW QUESTION # 54
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?
- A. Users can customize the OS stack and add additional packages
- 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 maintenance schedule.
Answer: D,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbat/index.html#articletitle
NEW QUESTION # 55
Which statement is not correct when the Autonomous Database is stopped?
- A. CPU billing is halted
- B. User with DWROLE can still access the database
- C. In-flight transactions queries are stopped
- D. Tools are no longer able to connect to a stopped instance
Answer: B
NEW QUESTION # 56
Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?
- A. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedules the container database maintenance for the following quarter
- B. 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
- C. Autonomous Exadata infrastructure maintenance takes place at least once each quarter
- D. Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching
Answer: D
NEW QUESTION # 57
You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?
- A. TPURGENT
- B. LOW
- C. MEDIUM
- D. TP
Answer: A
Explanation:
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE
NEW QUESTION # 58
What is the number of concurrent statements that can be handled by the medium database service name?
- A. 1-25 X OCPU
- B. unlimited
- C. 20 X OCPU
- D. OS
Answer: A
NEW QUESTION # 59
A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.
When restoring/cloning the ADB, you must select a backup which is atleast___ hours/minutes old.
- A. 24 hrs
- B. 5 min
- C. 1 day
- D. 2 hrs
Answer: A
NEW QUESTION # 60
Which two are correct actions to take in order to Download the Autonomous Database Credentials?
- A. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the 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. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
- E. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
Answer: B,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1
NEW QUESTION # 61
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
- A. Autonomous Data Warehouse
- B. Both services ignore hints by default
- C. Autonomous Transaction Processing
- D. Neither service ignores hints by default
Answer: A
Explanation:
NEW QUESTION # 62
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Index Storage
- B. Memory Usage
- C. Undo Management
- D. Backup Retention
- E. Data Organization
Answer: A,B
NEW QUESTION # 63
Which stage of the indexing pipeline divides text into tokens?
- A. Otokenizer
- B. LEXER
- C. FILTER
- D. SECTIONER
Answer: B
NEW QUESTION # 64
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?
- A. Fleet Administrators create, monitor and manage Autonomous Databases.
- B. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
- C. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
- D. Fleet Administrators are responsible for patching and backups of all container databases.
Answer: B
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 # 65
Which two of the following statements are correct?
- A. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.
- B. All of the capabilities of ODI Classic are available with ODI Web Edition,
- C. The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
- D. ODI Web Edition is available only on Oracle Linux.
Answer: A,D
NEW QUESTION # 66
Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?
- A. You must first manually create your database credentials using dms_cloud.create_credentia before accessing your Oracle Object Storage Bucket
- B. Data formats supported include: text, csv, json, avro and parquet
- C. Data can be loaded from a local data source
- D. Data can be loaded from a remote database using Database Links (DBLinks)
- E. Data can be uploaded from several cloud storage sources including 53, Azure, Google Cloud and Oracle Object Storage
Answer: A
NEW QUESTION # 67
Which statement is true when you provision an Autonomous Database using the cloning method?
- A. A clone database source can be from a point-in-time backup that is less than 2 hours old.
- B. After an Autonomous database is created using a clone, the network access option can be changed.
- C. A clone database source can be a running database instance.
- D. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
Answer: C
NEW QUESTION # 68
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?
- A. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.
- B. A Private Endpoint is required to connect to the Shared-Autonomous Database.
- C. The OCI compute instance does not support connecting to a Shared Autonomous Database.
- D. The OCI compute instance can be used with an Always-Free Autonomous Database account.
- E. The Autonomous Database must belong to a Network Security Group (NSG).
Answer: D
NEW QUESTION # 69
......
Get Latest 1z0-931-23 Dumps Exam Questions in here: https://actualtests.troytecdumps.com/1z0-931-23-troytec-exam-dumps.html