Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but the concern is that department A will be able to see data from department B.
Which architecture would you suggest to solve this deployment issue?
Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used by department B. This approach ensures that each department can securely operate within their allocated resources without the risk of data visibility between departments. ASM-Scoped Security specifically helps in restricting access at the storage level, providing a higher degree of separation and security between the two departments.
There are many different ways to load data into database tables.
Which method does Oracle strongly recommend?
Oracle strongly recommends using Oracle Data Pump for data loading into database tables. It is a high-speed mechanism for transferring data and metadata, offering a variety of utilities for data export and import. Data Pump is specifically designed for efficiently handling large amounts of data, making it an ideal choice for loading data into Oracle databases.
Identify three customer options for hosting the Platinum Services Advanced Support Gateway. (Choose three.)
The Platinum Services Advanced Support Gateway can be hosted in several ways. Customers can purchase the recommended x86 64-bit gateway hardware from Oracle, install it in an Oracle Virtual Machine with the required hardware, or provide their own individual x86 64-bit gateway hardware. These options offer flexibility in terms of hardware deployment and compatibility with the required specifications.
Which two statements are true about metrics in the DBMCLI utility? (Choose two.)
DBMCLI can be used to report on Exadata storage server metrics, which means that this tool has capabilities to interact and provide information about Exadata metrics. Metrics in DBMCLI are categorized into four types: cumulative, instantaneous, rate, or transition, indicating the nature of how the data is collected and reported. DBMCLI reported metrics' structuring into these types helps in detailed monitoring and analysis of the system's performance.
You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O sayings as a result of the storage indexes.
Which two statements are true? (Choose two.)
Based on the provided information, the option indicating that no queries were run against this table with the same predicate since the database was started is valid. This is because the value for 'cell physical IO bytes saved by storage index' is 0, suggesting no prior usage. Additionally, the option indicating that the storage index data is not in the Cell Server’s region index memory structures yet due to the predicate not being used is also valid. This aligns with the absence of saved IO bytes by the storage index, further reinforcing that the predicate has not been utilized.