Database Interview Questions
- 17th Apr, 2021
- 767 Followers
Latest Interview Questions
Pratice HR Questions
Database Interview Questions
DB2 is a relational database product from IBM which brings a family of data management tools including a server. Though started with supporting only relational models, DB2 now has extended its support to object-relational features and non-relational structures like JSON and XML.
MySQL is a relational database management software used extensively all over the world for small and big businesses. MySQL is capable of handling huge data bulk and hence is efficiently used for managing databases of various applications.
MsSQL is a relational database management system whose main function is to store and retrieve required data from databases. It is developed by Microsoft, MsSQL is a highly efficient database server which can fulfill its aim in a single computer or across multiple computers connected through the internet. All operations on SQL Server are communicated through Tabular Data Stream. While Tabular Data Stream operates on the application layer, SQL connects to the external interface through the protocol layer. SQL Server supports different data types like Integer, Decimal, Float, Character, Varchar, Binary, Text, etc. MsSQL is written in C and C++ languages.
Neo4j is a NoSQL graph database developed on Java Technology and can be accessed by other software written in other languages through Cypher query language. This open-source software is under GPL3 licensing and has features like ACID property support, highly scalable and reliable, provides a built-in Neo4j browser to its users to create and query graph data.
NoSQL is a non-relational database that does not need a fixed scheme and his highly scalable. Some of the features of NoSQL are Simple design, Horizontal scaling to clusters, Fine control over availability. NoSQL supports data in Key-value stored, Tabular, and Document-based format.
Oracle is an American multinational company that is one of the most popular sellers in the enterprise IT market. In 1979, Oracle became the first company to commercialize a relational database and still maintains its lead in the market. The headquarters of Oracle is located in Redwood Shores of California. Though Oracle has a wide range of products, the most popular is the Oracle database. Oracle database is a multi-model database management system based on SQL.
OrientDB is the first multi-model database that supports graph, document, key/value, and object models. The relationships in this database are managed by the graph. This database is written in Java and also contains various features of a traditional database. OrientDB fully supports ACID properties and atomic operations. OrientDB uses storage engines called LOCAL and PLOCAL. The data types supported by OrientDB are Boolean, Integer, Short, Long, Float, Double-time, Double, etc.
SQLite is a relational database system present in the C library and is embedded into the end program. SQLite was designed by D.Richard Hipp and follows mostly the PostgreSQL syntactically and also abides by the ACID properties. However, SQLite does not guarantee domain integrity and the SQL syntax is weakly and dynamically typed. SQLite is one of the widely used database engines with widespread use in browsers, operating systems, and embedded systems. SQLite is one of the top choices for embedded database software which aims for local/client storage in application software. SQLite allows concurrent access to the same database by different threads.
For transactions, RavenDB follows the ACID property and Cluster-wide transaction. The latest RavenDB 4.0 is fully transactional and has high performance.