Question

Write an essay of at least 500 words discussing the reasons for the two new auditing roles in Oracle 12c. Why did Oracle consider them necessary? What problems do they solve? How do they benefit companies? Do not copy without providing proper attribution. This paper will be evaluated through SafeAssign. Write in essay format not in outline, bulleted, numbered or other list format. Use the five paragraph format. Each paragraph must have at least five sentences. Include 3 quotes with quotation marks and cited in-line and in a list of references. Include an interesting meaninful title. Include at least one quote from each of 3 different articles, place the words you copied (do not alter or paraphrase the words) in quotation marks and cite in-line (as all work copied from another should be handled). The quotes should be full sentences (no more, less) and should be incorporated in your discussion (they do not replace your discussion) to illustrate or emphasize your ideas. Cite your sources in a clickable reference list at the end. Do not copy without providing proper attribution (quotation marks and in-line citations). It is important that you use your own words, that you cite your sources,

Answer 1

Answer:-

Oracle Database 12c is avery high-performance, effort-class database.  As Oracle claimed that this is "the first database designed for the cloud." Oracle Database 12c also introduces five hundred new features to the database and this is particularly pluggable databases and multitenant architecture. The Oracle Database 12c release 12.0.1.2 also features the Oracle Database 12c In-Memory, an optional add-on that provides in-memory capabilities. The in-memory option makes Oracle Database 12c the first Oracle database to offer real-time analytics.Oracle released Oracle Database 12c into general availability July 1, 2013.Oracle 12c plays very crucial role in the organization and for the growth of the organization this is necessary.

Now we will see the very important new additions and enhancements introduced in the area of Database Administration, RMAN, High Availability.

Migration of an data file:-As we know the old version of oracle database and now new version is released , a data file migration or renaming in Oracle database 12c R1 no longer requires a number of steps like table space putting in read only mode, followed by data file offline action. In 12c R1, a data file can be renamed or moved online simply using the ALTER DATABASE MOVE DATAFILE SQL statement. While the data file is being transferred, the end user can perform queries, DML and DDL tasks and on the other hand data files can be migrated between storages e.g. from non-ASM to ASM and vice versa.

User privilege:-As we know that in oracle 11g R2 SYStem privilege was came to action to perform ASM specific operation and now just like that the backup and the recovery tasks specific privilege SYSBACKUP has been introduced in 12c to execute the backup and the recovery commands in Recovery Manager and so you can create a local user in the database and grant him the SYSBACKUP privilege so that he can perform any backup and recovery related task in recovery manager.

Oracle Database is commonly known as Oracle RDBMS or as Oracle is a multi-model database management system produced and marketed by Oracle Corporation.Oracle database is a database which is used for running online transaction processing and data warehousing and mixed database work loads. Now in the latest generation Oracle Database 19c, is available on-prem and on-cloud or in a hybrid-Cloud environment. 19c may also be open on Oracle Engineered Systems like exadata on-prem and on Oracle which is for public and cloud which is for private use, cloud at customer.At Open world 2017 in "San Francisco, Executive Chairman of the Board and CTO, Larry Ellison" announced the next database generation which is known by the Oracle Autonomous Database.

If we discuss about the competition in the market for the relational database system so oracle database system is competing against the commercial product like IBM  IBM's DB2 UDB and Microsoft SQL Server.Oracle and IBM tend to support the products of each other company in many middleware and application categories.In the battle of this digital marketing areas Oracle and IBM slouch to battle for the mid range database market on Unix and Linux platforms while Microsoft rule the mid range database market on Microsoft Windows platforms.