Database Interview Questions

  • Admin
  • 25th Jan, 2023

Database Interview Questions

1. Db2

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.

2. Dbms


3. Stored Procedures

4. Mysql

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.

5. Mssql

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.

6. Mongodb

MongoDB is a type of NoSQL database that has JSON based document-oriented storage along with auto-sharding facility. It is written in C++, Go, JavaScript, and Python programming language and was developed by MongoDB Inc. Some of the widespread applications of MongoDb include Mobile and Social infrastructure, User Data management. Content management and delivery, Data Hub, Big Data.

7. Neo4j

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.

8. Nosql

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.

9. Oracle

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.

10. Orientdb

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.

11. Pl/sql

12. Postgresql

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server and is also available for Linux, FreeBSD, OpenBSD, and Windows. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, analytics, and other applications.

13. Sqlite

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.

14. Ravendb

RavenDB is the Operational and Transactional Enterprise NoSQL Document database. In this open-source software, document storage forms the primary database model whereas Graph DBMS forms the secondary database model. RavenDB was first released in 2010 and was developed by Hibernating Rhinos. It is written in C# and is supported by various platforms like Linux, macOS, Raspberry Pi, and Windows and the most current release was in May 2019. RavenDB supports various programming languages like .Net, C#, Go, Java, JavaScript (Node.js), Python, and Ruby.

For transactions, RavenDB follows the ACID property and Cluster-wide transactions. The latest RavenDB 4.0 is fully transactional and has high performance.

15. Couchdb

Apache CouchDB document-oriented NoSQL database which stores, transfers, and processes its data, through various formats and protocols. It deals with JSON format for storing data, uses JavaScript as the query language, and HTTP as the API. CouchDB was first released in 2005 and the latest version, Apache CouchDB 2.3.1, was released in March 2019. This document-oriented database is cross-platform compatible and is written in Erlang, C++, and JavaScript.

16. Weblogic

17. Mariadb

18. Cassandra

19. Pouchdb

20. Rdbms

21. Sql Server

22. Oracle Dba

23. Firebird

24. Toad