Free Practice Questions for Oracle 1z0-1195-25 Exam

In a simple cloud management model (e.g., Autonomous Database), "Manage database servers and VM hosts" (A) is not the customer’s responsibility; Oracle handles infrastructure management.Customers "Subscribe to database servers" (B), manage "Everything inside of the database" (C) like data and schemas, and "Control access to customer VMs" (D) where applicable. Oracle’s shared responsibility model delegates server and host management to the provider.

The "Oracle Autonomous Database" (B) offers the highest degree of security and governance with a self-service experience. It includes automated security features (e.g., TDE, network encryption), self-patching, and fine-grained access controls, all managed by Oracle, while allowing users to provision and manage databases independently. "Exadata Cloud Service" (A) provides high performance but requires more manual oversight. "Oracle Database Cloud Service" (C) offers flexibility but less automation, and "Oracle MySQL Database Service" (D) lacks the same level of autonomous security. Oracle’s documentation positions Autonomous Database as the pinnacle of secure, self-service deployment.

For an "Autonomous Database," the DBA can "Open the database in OCI Console and increase the number of OCPU. No downtime required" (C). Autonomous Database supports dynamic scaling of OCPUs online, with no service interruption, leveraging its self-managing capabilities. Options A and B involve unnecessary downtime, and D adds an unneeded user restriction. Oracle’s documentation confirms zero-downtime OCPU scaling as a key feature.

The "Autonomous JSON Database" supports NoSQL-style document access through "SODA" (Simple Oracle Document Access) APIs (B). SODA provides a simple, intuitive interface for developers to interact with JSON documents stored in the database using operations like insert, query, and update, without requiring SQL knowledge. Options A ("OASD"), C ("DOSA"), and D ("OSDA") are not recognized API sets in Oracle’s documentation. SODA is explicitly documented as the standard NoSQL API for Autonomous JSON Database, aligning with Oracle’s converged database strategy to support multiple data models.

Oracle’s "Converged Database" supports multiple data types/models, including "Spatial" (B) for geospatial data, "Graph" (D) for relationship analytics, and "Relational" (E) for traditional structured data. "Events" (A) is not a distinct data model but a use case, and "Terraform" (C) is an infrastructure tool, not a data type. Oracle’s documentation lists Spatial, Graph, and Relational among others (e.g., JSON, XML) as core converged capabilities.

An example of an in-database option in Oracle Automated Machine Learning (AutoML) is "Oracle Machine Learning for Python (OML4PY) APIs" (C). OML4Py enables Python-based machine learning directly within the database, leveraging in-database algorithms for performance and security. "REST Interface" (A) is an access method, "Cognitive text" (B) is a feature, not an algorithm type, and "Tuning of hyperparameter" (D) is a process, not a specific option. Oracle’s documentation highlights OML4Py as a key in-database ML tool.

From the OCI Console for an "Oracle Autonomous Database," you can "Scale up/down CPU" (A) to adjust compute resources dynamically and "Increase Storage allocated for Database" (D) to expand capacity, both with no downtime. "Increase Network Bandwidth" (B) is not a console-adjustable parameter (managed by Oracle), and "Scale up/down Memory" (C) is not independentlyconfigurable (tied to CPU scaling). Oracle’s documentation confirms CPU and storage scaling as user-controlled actions.

The "built-in SQL Worksheet and Notebook" (e.g., in Autonomous Database’s Database Actions) have two true statements: "No need to install a client query tool" (C), as it’s web-based and accessible via browser, and "Quickly start running queries with built-in web-based notebooks" (D), enabling immediate SQL execution. "Based on Apache Tomcat" (A) is not specified in documentation, and "Need to install client query tool for the PL/SQL" (B) is false due to its integrated nature. Oracle’s documentation confirms these web-based features.