Oracle 19c Introduction
Oracle Corporation released the latest version of the Oracle Database, Oracle 19c, in February 2019. It is the long-term support release, which means that Oracle will provide support for this version for an extended period of time.
Features of Oracle 19c
Some of the key features and improvements in Oracle 19c include:
- Automatic Indexing: This feature enables the database to automatically create and manage indexes to improve query performance.
- Real Application Clusters (RAC) Improvements: Oracle 19c includes several improvements to RAC, such as faster database restarts and better performance for workloads that require high concurrency.
- Machine Learning: Oracle 19c includes several new machine learning algorithms and functions that can be used for data mining and predictive analytics.
- Security Enhancements: Oracle 19c includes several new security features, including the ability to encrypt sensitive data in memory, improved auditing, and better management of user privileges.
- Multitenant Improvements: Oracle 19c includes several improvements to multitenant databases, including the ability to run PDBs in read-only mode, faster database cloning, and more efficient resource management.
1. What is Oracle 19c?
Oracle Database 19c is the latest version of the Oracle Database. It is the long-term support release of the Oracle Database 12c family of products, offering extended support through 2027 and premier support through 2023.
2. In the context of a database upgrade to Oracle 19c, can you explain any specific new features?
Upgrading to Oracle 19c allows using a few new features.
- Automatic Indexing – This feature uses machine learning algorithms to create and tune indexes automatically, saving time and effort for database administrators.
- Real-Time Statistics – Real-Time Statistics feature provides more accurate and up-to-date statistics for the optimizer to improve the query performance.
- SQL Quarantine – This feature is useful for preventing execution of poorly performing SQL statements and to protect the system from performance issues.
- JSON enhancements – Oracle 19c provides several enhancements for JSON processing, including new SQL/JSON functions, more efficient indexing, and support for JSON documents with multiple rows.
- Enhanced Sharding – The Sharding feature in Oracle 19c provides support for automatic data re-balancing, simplified management of shard catalogs, and improved monitoring and diagnostics.
- Hybrid Partitioned Tables – This feature allows partitioning of a table across both a regular disk-based tablespace and an In-Memory Column Store, providing the benefits of both technologies.
3. What are the advantages of using Oracle Enterprise Manager?
Oracle Enterprise Manager provides a comprehensive and centralized solution for managing Oracle databases, middleware, and applications.
It offers a complete set of tools for managing and monitoring all aspects of your IT infrastructure, including:
- Provisioning and patching
- Configuration management
- Performance monitoring
- Capacity planning
- Security and compliance
- Backup and recovery
Oracle Enterprise Manager also provides a self-service portal for users, so they can request and provision new resources,
4. Is it possible to upgrade an existing 11gR2 or 12c non-container database (CDB) to Oracle 19c? If yes, how?
Yes, it is possible to upgrade an existing 11gR2 or 12c non-container database (CDB) to Oracle 19c.
You can do this by using the Oracle Database Upgrade Assistant (DBUA).
5. What are some key features of Autonomous Database Cloud Service?
Some key features of Autonomous Database Cloud Service include:
- The ability to automatically provision and manage Oracle databases in the cloud
- The ability to elastically scale compute and storage resources as needed
- The ability to patch and upgrade databases automatically
- The ability to monitor and manage databases using the Oracle Cloud Infrastructure Console
6. What is a pluggable database?
The container database contains a database that is known as a pluggable database. While sharing certain resources with the container database, the pluggable database can also be configured and administered independently. This allows for greater flexibility and scalability when managing multiple databases.
7. Does Oracle 19c support using multiple PDBs on the same server?
Yes, Oracle 19c does support using multiple PDBs on the same server.
This allows for greater flexibility and scalability when deploying Oracle databases.
8. In what situations would you use a container database architecture for your production databases?
Container database architectures are becoming increasingly popular for production databases, as they offer a number of advantages.
One key advantage is that they allow for much easier management of multiple databases, as all of the databases can be managed from a single console.
This can save a lot of time and effort, particularly for larger organizations with many databases. Additionally, container databases can offer better performance and scalability than traditional database architectures.
9. Can you explain what SQL Plan Management is and why we need it?
SQL Plan Management is a feature in Oracle 19c that allows the database to automatically manage SQL execution plans.
This can help improve performance by ensuring that the optimizer always has access to the most up-to-date execution plans.
SQL Plan Management can also help to prevent plan regressions by automatically reverting to a previous plan if a new one is found to be sub-optimal.
10. What are the main benefits provided by Oracle Machine Learning?
Oracle Machine Learning provides a number of benefits, including the ability to automatically generate models from data, the ability to deploy models in a production environment, and the ability to monitor and manage models. Additionally, Oracle Machine Learning provides a number of tools that make it easier to work with data, including data preparation, feature selection, and model evaluation.
11. What’s the difference between Oracle Advanced Security Option and Oracle Data Redaction?
Oracle Advanced Security Option provides a comprehensive set of tools for securing data in transit and at rest, including encryption, data masking, and access control. Oracle Data Redaction, on the other hand, is a feature that allows you to selectively redact sensitive data from your database, making it unreadable to unauthorized users.
12. How do you ensure data security when storing sensitive information in a database like Oracle 19c?
When storing sensitive information in a database like Oracle 19c, you need to ensure that the data is encrypted. You can do this by using a tool like Oracle Advanced Security. This will encrypt the data both at rest and in transit, making it much more difficult for unauthorized individuals to access it.
13. What is the best way to secure passwords stored in Oracle 19c?
The best way to secure passwords stored in Oracle 19c is to use the Oracle Password Vault. The Password Vault is a secure, centralized repository for storing and managing passwords. It provides a single point of control for managing passwords, and it ensures that all passwords are stored in a secure, encrypted format.
14. Do you think there will ever be a situation where a business won’t need a data warehouse?
I don’t think so. Data warehouses will always be necessary to store and analyze large amounts of data.
15. What is the importance of the Oracle wallet feature?
The Oracle wallet feature is important because it allows for the secure storage of sensitive information, such as passwords, within the database. This means that the information is less likely to be compromised if the database is breached.
16. What is Oracle Real Application Clusters? Why should we use it?
Oracle Real Application Clusters (RAC) is a software feature that allows Oracle databases to be deployed on a cluster of servers. This provides high availability and scalability for Oracle databases. Using RAC, you can improve the performance of Oracle databases, provide failover protection in the event of a server failure, and monitor the status of your existing resources.
17. Is there anything special about upgrading from Oracle 12c to 19c as opposed to other versions?
Yes, there are a few things to keep in mind when upgrading to Oracle 19c. First, the Oracle 19c database is only compatible with Oracle Linux 7.3 or higher.
Second, the Oracle 19c database is only compatible with the Oracle 19c client. Finally, when upgrading from Oracle 12c to 19c, you will need to export your data from the 12c database, then import it into the 19c database.
18. How can you prevent unauthorized users from accessing sensitive information in Oracle 19c?
You can prevent unauthorized users from accessing sensitive information in Oracle 19c by using the Data Redaction feature. You can also specify which users should have access to the redacted data.
19. What’s your opinion on Oracle Exadata? When it is used?
You can use Oracle Exadata, a powerful tool, to improve the performance of Oracle databases. You should use Oracle Exadata in situations where you expect the database to experience high demand or when the database is particularly large.
20. What are the differences between Oracle Exadata and Amazon Web Services RDS?
Oracle Exadata is a cloud-based platform that provides customers with a complete Oracle database solution. While Amazon Web Services RDS is a cloud-based platform that provides customers with a relational database service. Oracle Exadata also provides customers with a complete set of tools for managing and monitoring their Oracle database, while Amazon Web Services RDS only provides a limited set of tools for managing and monitoring their relational database.
Read Related Topics
Top 10 Oracle RAC (Real Application Cluster) And Performance Tuning Interview Questions Answers
