InternShips Interviews General

1What is a Database Management System (DBMS)?

A Database Management System (DBMS) is a software system that allows users to create, store, retrieve, update, and manage data in a database. It provides a way to organize and manage large amounts of data efficiently and effectively.

2What is a relational database?

A relational database is a type of database that organizes data into one or more tables, where each table consists of a set of rows and columns. The tables are related to each other based on common fields, and this allows the data to be stored and retrieved in a structured way.

3What is SQL?

SQL (Structured Query Language) is a programming language that is used to interact with a relational database. It allows users to create, modify, and query databases, as well as manage the data stored in them.

4What is a primary key in a database?

A primary key is a unique identifier for each row in a table. It is used to ensure that each row is unique and can be accessed quickly and efficiently. The primary key is usually defined as a single column or a combination of columns that uniquely identify each row in the table.

5What is a foreign key in a database?

A foreign key is a column or set of columns in a table that refers to the primary key of another table. It is used to establish a relationship between two tables and ensures that data is consistent between them. A foreign key constraint is used to enforce referential integrity between the two tables.

6What is normalization in a database?

Normalization is the process of organizing data in a database to reduce redundancy and dependency. It involves breaking down large tables into smaller, more manageable tables and creating relationships between them. The goal of normalization is to eliminate data anomalies, improve data consistency, and improve database performance.

7What is a stored procedure in MySQL?

A stored procedure is a set of SQL statements that are stored in the database and can be executed on demand. It is like a precompiled program that can be called from within another program or script. Stored procedures can be used to perform complex database operations, automate common tasks, and improve database performance.

8What is a trigger in MySQL?

A trigger is a special type of stored procedure that is automatically executed in response to certain database events, such as insert, update, or delete operations on a table. Triggers can be used to enforce business rules, maintain data integrity, and perform complex database operations.

9What is a view in MySQL?

A view is a virtual table that is created by combining data from one or more tables in the database. It does not actually store data itself but provides a way to query and manipulate data as if it were a table. Views can be used to simplify complex queries, restrict access to sensitive data, and provide a consistent view of data to different users.

10What is a transaction in MySQL?

A transaction is a sequence of database operations that are treated as a single, indivisible unit of work. A transaction ensures that all the operations are completed successfully or none of them are performed at all. This helps to maintain data consistency and integrity in the database. A transaction can be committed, which means that the changes are saved to the database, or rolled back, which means that the changes are undone and the database is restored to its previous state.

1What is the difference between HTTP and HTTPS?

HTTP (Hypertext Transfer Protocol) is a protocol used for transmitting data over the internet. HTTPS (Hypertext Transfer Protocol Secure) is a secure version of HTTP that encrypts data to protect it from interception by third parties.

2What is a cookie?

A cookie is a small text file that is stored on a user's computer by a website. It is used to store information about the user's preferences, login status, and other data that can be used to personalize the user experience.

3What is a session?

A session is a way to maintain information about a user's interaction with a website. It is created when a user logs in and is destroyed when the user logs out or the session expires. Sessions are often used to store information such as the user's shopping cart contents, preferences, and login status.