Vi editor in Linux
Its a visual editor by default installed in every linux system. The next version of vi is vim. The vi editor tool is an interactive tool as it displays changes…
Its a visual editor by default installed in every linux system. The next version of vi is vim. The vi editor tool is an interactive tool as it displays changes…
In normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table. They remain present until a VACUUM is done. Therefore it’s necessary to do VACUUM periodically, especially…
To restore a database from the default directory /backup/rman use the cmd cmd: RESTORE DATABASE; Restore Specific Tablespace: Instead of restoring the full database, you can also restore only specific tablespace…
1. View Current RMAN Configuration Before we take the backup, we have to configure certain RMAN parameters. For example, how long you want to reatain the RMAN backup, etc. To…
A database administrator’s responsibilities can include the following tasks: Installing and upgrading the Oracle Database server and application tools Allocating system storage and planning future storage requirements for the database…
Go to orcale.com Go to downloads as shown in the image and select the compataible version of the system by accepting the license and click on it to download. Provide…
Features: ->MongoDB is a No SQL database. It is an open-source, cross-platform, document-oriented database written in C++.C-> It stores data as documents, so it is known as document oriented database. -> documents…
-> SQLite is an open source, zero-configuration, self-contained, stand alone, transaction relational database engine designed to be embedded into an application. -> SQLite does not have a separate server process. It…
-> This is the world’s second most popular and widely used open source database. -> All the database names, table names and table fields name are case sensitive. -> To switch…
-> Its relational database management system used in enterprise applications. -> Its biggest competitor is Microsoft SQL Server. -> Runs on Windows,Unix,Linux and Mac Operating systems. Limitations: -> A table…