Oracle 1Z0-931-24 Real Exam Questions and Answers FREE
Exam Dumps 1Z0-931-24 Practice Free Latest Oracle Practice Tests
NEW QUESTION # 93
Which three are Oracle-recommended best practices for Autonomous Database alarms?
- A. Create a single alarm for each metric
- B. Select the correct alarm interval for your metric
- C. Suppress alarms during investigations
- D. Tune your alarms routinely
- E. Create multiple alarm metrics
- F. Use a single interval for all alarms
Answer: A,B,C
NEW QUESTION # 94
Which statement is true regarding database client credentials file required to connect to your Autonomous Database?
- A. Place the credential files on a share drive that all users can use to connect to the database.
- B. The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.
- C. Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.
- D. When you share the credential files with authorized users, mail the wallet password and the file in the same email.
Answer: C
Explanation:
Connection to Autonomous DB uses certificate authentication and Secure Sockets Layer (SSL). This ensures that there is no unauthorized access to Autonomous DB and that communications between the client and server are fully encrypted and cannot be intercepted or altered.
Certification authentication uses an encrypted key stored in a wallet on both the client (where the application is running) and the server (where your database service on the Autonomous DB is running). The key on the client must match the key on the server to make a connection There's credentials zip file available for download once ADB is created, the zip file contains a collection of files, that needed to connect to your Autonomous DB. All communications between the client and the server are encrypted Wallet files, along with the Database user ID and password provide access to data in your Autonomous Transaction Processing database. Store wallet files in a secure location. Share wallet files only with authorized users. If wallet files are transmitted in a way that might be accessed by unauthorized users (for example, over public email), transmit the wallet password separately and securely.
For better security, Oracle recommends using restricted permissions on wallet files. This means setting the file permissions to 600 on Linux/Unix.
Similar restrictions can be achieved on Windows by letting the file owner have Read and Write permissions while all other users have no permissions.
https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/adbconnecting.htm
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1
NEW QUESTION # 95
What is the number of concurrent statements that can be handled by the medium database service name?
- A. OS
- B. 20 X OCPU
- C. unlimited
- D. 1-25 X OCPU
Answer: D
NEW QUESTION # 96
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)
- A. Data Pump creates the tablespaces used by your Autonomous Database.
- B. Data Pump is platform independent - it can migrate Oracle Databases running on any platform.
- C. Data Pump is faster to migrate database than using RMAN.
- D. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
Answer: B,D
Explanation:
The default data and temporary tablespaces for the database are configured automatically. Adding, removing, or modifying tablespaces is not allowed.
Oracle Data Pump offers very fast bulk data and metadata movement between Oracle databases and Autonomous Database .
Data Pump Import lets you import data from Data Pump files residing on Oracle Cloud Infrastructure Object Storage, Microsoft Azure, AWS S3, 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
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/load-data-data-pump.html#GUID-297FE3E6-A823-4F98-AD50-959ED96E6969
NEW QUESTION # 97
Which three options do NOT change when enabling auto scaling?
- A. Amount of storage
- B. Level of concurrency
- C. I/O resources
- D. Parallelism settings
- E. Number of OCPUS displayed in the console
Answer: A,B,D
NEW QUESTION # 98
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter database for user MTHEO tablespace DATA quota = 10G;
- B. Execute alter user MTHEO quota unlimited on tablespace DATA;
- C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- D. Execute alter tablespace DATA set quota = 10G;
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
NEW QUESTION # 99
Which option is not available to access data in an Autonomous JSON Database?
- A. REST API calls to the database
- B. Regular Oracle SQL statements using a connection string to the database
- C. Oracle Cloud Infrastructure console using the JSON Developer tool
Answer: B
NEW QUESTION # 100
What is the correct way to list all files in the default data pump directory?
- A. By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;
- B. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
- C. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
- D. Log onto ADW server and issue is -al on the command line.
Answer: B
Explanation:
To list all files in the default data pump directory, you can use the DBMS_CLOUD.LIST_FILES procedure with the directory name as the parameter. SeeListing Files in a Directoryfor more details.
NEW QUESTION # 101
Which four file formats are supported when loading data from Cloud Storage?
- A. AVRO
- B. CSV
- C. Parquet
- D. DDL
- E. JSON
- F. DOC
Answer: A,B,C,E
NEW QUESTION # 102
Your company has a .NET application and wants to deploy it on Autonomous Database (ADB). What software is used to connect to ADB from the .NET application?
- A. Java
- B. Oracle Data Access Components for Windows
- C. SQL*Plus
- D. You cannot use .NET with ADB.
Answer: B
Explanation:
Oracle Data Access Components (ODAC) for Windows is a collection of software components that provide data access to Oracle databases from .NET applications.ODAC includes Oracle Data Provider for .NET (ODP.NET), which is the driver that connects to Autonomous Database from .NET applications2.ODP.NET supports both .NET Framework and .NET Core applications3.ODP.NET can be used with Visual Studio and Visual Studio Code to develop and deploy .NET applications for Autonomous Database45.
Connect Microsoft .NET, Visual Studio Code, and Visual Studio with a Wallet (mTLS) - Oracle Help Center, section "Oracle Data Provider for .NET (ODP.NET)".
Connect Microsoft .NET, Visual Studio Code, and Visual Studio Without a Wallet - Oracle Help Center, section "Oracle Data Provider for .NET (ODP.NET)".
Oracle Data Access Components Downloads - Oracle.
NuGet Gallery | Packages matching Tags:"odp.net".
NEW QUESTION # 103
Which three scaling options are available in Oracle Autonomous Database on Shared Infrastructure?
- A. Manual offline scaling of Storage and OCPU
- B. Manual online scaling of Storage
- C. Automatic online scaling of Storage
- D. Manual online scaling of OCPU
- E. Automatic online scaling of OCPU
Answer: A,C,E
NEW QUESTION # 104
What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?
- A. DWROLE
- B. ADWC
- C. ADBDEV
- D. ADMIN
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-EC14B465B873
NEW QUESTION # 105
Which is NOT needed to manage Oracle Autonomous Database with REST APIS?
- A. Tenancy's OCID
- B. Fingerprint of the public key
- C. Database ADMIN password
- D. User's OCID
Answer: D
NEW QUESTION # 106
Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?
- A. OCI Metrics
- B. Performance Hub
- C. Logs
- D. Enterprise Manager Cloud Control
- E. RMAN
Answer: A,B,D
NEW QUESTION # 107
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 # 108
For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?
- A. ORDS_ADMIN.ENABLE_SCHEMA
- B. ORDS_ADMIN.GRANT_SCHEMA
- C. SQLDEV_ADMIN.GRANT_SCHEMA
- D. ORDS_PRIV.ENABLE_SCHEMA
Answer: A
Explanation:
As an alternative, the ADMIN can provide Web Access for a user, REST enable a user, with SQL commands. As the ADMIN user run the following code:
BEGIN
ORDS_ADMIN.ENABLE_SCHEMA(
.
.
);
COMMIT;
END;
/
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/sql-developer-web.html#GUID-4B404CE3-C832-4089-B37A-ADE1036C7EEA
NEW QUESTION # 109
When exporting a notebook, what type of file is created?
- A. XML
- B. TXT
- C. SQL
- D. ASCII
- E. JSON
Answer: E
Explanation:
Export a Notebook
You can export a notebook as a .json (JavaScript Object Notation) file, and later import it in to the same or a different environment.
To export a notebook:
- In the Notebooks page, click the notebook that you want to export. The notebook opens in the notebook editor.
- In the top panel of the notebook editor, click export. The notebook is saved to your local folder as a .json file.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-notebooks-data-analysis-and-data-visualization.html#GUID-009B9073-4B45-4505-8DAD-F1F04FD3E160
NEW QUESTION # 110
......
Verified 1Z0-931-24 Exam Dumps Q&As - Provide 1Z0-931-24 with Correct Answers: https://www.dumpexams.com/1Z0-931-24-real-answers.html
1Z0-931-24 Exam Questions | Real 1Z0-931-24 Practice Dumps: https://drive.google.com/open?id=1AyGTXyj0755NKNd-FXuJLMJwm7Qy3rPA