Top 100 DBMS Interview Questions and Answers
Updated 10 Dec 2024
Q1. What is the difference between RDBMS and DBMS? Give examples.
RDBMS is a type of DBMS that stores data in a structured manner using tables and enforces relationships between them.
DBMS is a software system that manages databases, while RDBMS is a specific type of DBMS.
RDBMS uses a tabular structure to store data, with each table consisting of rows and columns.
RDBMS enforces the ACID properties (Atomicity, Consistency, Isolation, Durability) to ensure data integrity.
RDBMS supports SQL (Structured Query Language) for managing and manipulat...read more
Different types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is at least one match in both tables.
Left join: Returns all rows from the left table and the matched rows from the right table.
Right join: Returns all rows from the right table and the matched rows from the left table.
Full outer join: Returns rows when there is a match in one of the tables.
Design a schema for a restaurant app like Zomato.
Create tables for restaurants, users, reviews, and orders
Include columns for restaurant details like name, address, cuisine type
Include columns for user details like name, email, and password
Link reviews to restaurants and users
Link orders to restaurants and users
Consider additional tables for menu items, categories, and ratings
A transaction is a logical unit of work that consists of multiple database operations that must be executed as a single, indivisible unit.
A transaction ensures data consistency and integrity.
It follows the ACID properties: Atomicity, Consistency, Isolation, and Durability.
Transactions are used to maintain data integrity in databases.
Examples of transactions include transferring funds between bank accounts or updating inventory levels.
Q5. what is difference between ADBMS and DBMS?
ADBMS stands for Advanced Database Management System which is an extension of DBMS with additional features.
ADBMS has advanced features like data mining, data warehousing, and online analytical processing.
ADBMS is used for handling large and complex data sets.
DBMS is a basic system for managing data and is used for small and simple data sets.
DBMS does not have advanced features like ADBMS.
Examples of ADBMS are Oracle, IBM DB2, and Microsoft SQL Server.
Examples of DBMS are MyS...read more
Q6. What is dbms , Sql query
DBMS stands for Database Management System. SQL is a programming language used to manage and manipulate data in a DBMS.
DBMS is a software system that allows users to create, manage, and manipulate databases.
SQL is used to communicate with a DBMS and perform tasks such as querying, inserting, updating, and deleting data.
Examples of popular DBMS include MySQL, Oracle, and Microsoft SQL Server.
Examples of SQL queries include SELECT, INSERT, UPDATE, and DELETE statements.
Normalization in database management systems aims to reduce data redundancy, improve data integrity, and optimize database performance.
Eliminate data redundancy by breaking down data into smaller tables
Reduce update anomalies by ensuring data is stored in a logical and consistent manner
Improve data integrity by enforcing referential integrity constraints
Optimize database performance by reducing the amount of redundant data stored
Types of keys in a DBMS include primary key, foreign key, candidate key, and super key.
Primary key uniquely identifies each record in a table (e.g. employee ID)
Foreign key links two tables together (e.g. department ID in employee table)
Candidate key is a unique key that can be chosen as the primary key (e.g. email address)
Super key is a set of attributes that uniquely identifies a record (e.g. combination of first name and last name)
DBMS Jobs
Different types of indexing in DBMS include primary, secondary, clustered, non-clustered, unique, and composite indexing.
Primary indexing: Index based on the primary key of a table.
Secondary indexing: Index based on a non-primary key column.
Clustered indexing: Physically rearranges the table's rows based on the indexed column.
Non-clustered indexing: Creates a separate structure for the index.
Unique indexing: Ensures that no two rows have the same indexed value.
Composite index...read more
Aggregate functions in DBMS are functions that operate on a set of values and return a single value as output.
Aggregate functions perform calculations on multiple rows to return a single result.
Examples include SUM, AVG, COUNT, MIN, and MAX.
They are commonly used with the GROUP BY clause in SQL queries.
Sharding is a database partitioning technique to improve performance and scalability by distributing data across multiple servers.
Sharding involves breaking up a database into smaller, more manageable parts called shards.
Each shard contains a subset of the data, allowing for parallel processing and improved performance.
Sharding helps distribute the workload across multiple servers, preventing bottlenecks and improving scalability.
Examples of sharding implementations include M...read more
BCNF stands for Boyce-Codd Normal Form, a higher level of normalization in database management systems.
BCNF is a stricter form of 3NF (Third Normal Form) and ensures that there are no non-trivial functional dependencies between attributes.
It helps in reducing redundancy and anomalies in the database.
BCNF is important as it helps in maintaining data integrity and improving database performance.
Example: If we have a table with attributes {StudentID, CourseID, Professor}, BCNF w...read more
Q13. What is Dbms ? What is Mysql
Dbms stands for Database Management System. MySQL is an open-source relational database management system.
Dbms is a software system that allows users to define, create, maintain and control access to databases.
MySQL is a popular open-source relational database management system.
MySQL is used for web applications and is compatible with many programming languages.
MySQL is known for its speed, reliability, and ease of use.
Different languages used in DBMS include SQL, PL/SQL, T-SQL, and NoSQL.
SQL (Structured Query Language) is the standard language for relational database management systems.
PL/SQL (Procedural Language/SQL) is Oracle Corporation's procedural extension for SQL.
T-SQL (Transact-SQL) is Microsoft's proprietary extension to SQL.
NoSQL encompasses a wide range of database technologies that can store unstructured, semi-structured, or structured data.
Q15. Draw the 3-Tier Architecture of DBMS
3-Tier Architecture of DBMS includes presentation, application, and data layers.
Presentation Layer: User interface for interacting with the database (e.g. web browser)
Application Layer: Business logic and processing of user requests (e.g. server-side scripts)
Data Layer: Storage and retrieval of data from the database (e.g. SQL database)
Q16. What is foreign key in dbms
A foreign key is a column or set of columns in a database table that refers to the primary key of another table.
A foreign key ensures referential integrity between two tables.
It is used to establish a relationship between two tables.
It helps in maintaining data consistency and accuracy.
For example, a customer table may have a foreign key that refers to the primary key of an orders table.
Q17. what are views in DBMS
Views in DBMS are virtual tables that display data from one or more tables.
Views are created using SELECT statements.
They can be used to simplify complex queries.
Views can also be used to restrict access to sensitive data.
They do not store data themselves, but rather display data from other tables.
Changes made to the underlying tables are reflected in the view.
Q18. Explain characteristics of DBMS?
DBMS is a software system that manages databases, providing features like data storage, retrieval, and manipulation.
DBMS stands for Database Management System.
It provides a structured way to store and organize data.
DBMS allows multiple users to access and manipulate the data simultaneously.
It ensures data integrity and security through various mechanisms.
DBMS provides a query language to retrieve and manipulate data, such as SQL.
Examples of popular DBMS include Oracle, MySQL,...read more
Yes, I can design an ER diagram for an online shopping portal.
Entities: User, Product, Order, Payment, Cart
Relationships: User places Order, Order contains Product, Payment for Order, User has Cart
Attributes: User (id, name, email), Product (id, name, price), Order (id, date), Payment (id, amount)
The database design for an ATM system should include tables for users, accounts, transactions, and ATM machines.
Create a table for users with fields like user_id, name, pin, etc.
Create a table for accounts with fields like account_id, user_id, balance, etc.
Create a table for transactions with fields like transaction_id, account_id, amount, date, etc.
Create a table for ATM machines with fields like atm_id, location, status, etc.
CRUD operations in DBMS refer to Create, Read, Update, and Delete operations for managing data.
Create: Inserting new data into the database
Read: Retrieving existing data from the database
Update: Modifying existing data in the database
Delete: Removing data from the database
Examples: Creating a new user record, Reading a product's details, Updating a customer's address, Deleting an outdated entry
To join multiple models in a DBMS, use SQL JOIN statements based on common keys.
Identify common keys between the models
Use SQL JOIN statements (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN) to combine the models based on the common keys
Specify the columns to be selected in the SELECT statement
ACID properties in DBMS ensure data integrity and consistency.
Atomicity: All transactions are either fully completed or fully aborted. For example, transferring money from one account to another should be completed in its entirety.
Consistency: The database remains in a consistent state before and after the transaction. For example, if a constraint is violated during a transaction, the transaction will be rolled back.
Isolation: Transactions are isolated from each other until t...read more
Concurrency control is a technique used in databases to manage simultaneous access and modification of data by multiple users or processes.
Concurrency control ensures that transactions are executed in a way that maintains data consistency and integrity.
Techniques like locking, timestamp ordering, and optimistic concurrency control are used to implement concurrency control.
For example, in a banking system, concurrency control ensures that two users cannot withdraw money from t...read more
A correlated subquery is a subquery that references a column from the outer query, allowing for more complex filtering and data retrieval.
Correlated subqueries are executed for each row processed by the outer query.
They can be used to filter results based on values from the outer query.
Example: SELECT * FROM table1 t1 WHERE t1.column1 = (SELECT MAX(column2) FROM table2 t2 WHERE t2.column3 = t1.column3);
Normalization forms in a DBMS help reduce data redundancy and improve data integrity.
1NF (First Normal Form) - Each column contains atomic values, and there are no repeating groups.
2NF (Second Normal Form) - Meets 1NF and all non-key attributes are fully functional dependent on the primary key.
3NF (Third Normal Form) - Meets 2NF and there are no transitive dependencies between non-key attributes.
BCNF (Boyce-Codd Normal Form) - Every determinant is a candidate key.
4NF (Fourth ...read more
Q27. What is DBMS AND RDMS
DBMS stands for Database Management System, which is a software system that allows users to define, create, maintain and control access to the database. RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using rows and columns.
DBMS is a software system that allows users to define, create, maintain and control access to the database
RDBMS is a type of DBMS that stores data in a structured format using rows and...read more
The three levels of data abstraction in a Database Management System are Physical Level, Logical Level, and View Level.
Physical Level: Deals with how data is stored on the storage medium. It includes details like data structures, file organization, and indexing.
Logical Level: Focuses on how data is viewed by users. It hides the physical storage details and presents a logical view of the database.
View Level: Represents a subset of the database to specific users. It provides a ...read more
A clustered index is a type of index that sorts and stores the data rows in the table based on their key values.
Defines the order in which data is physically stored in a table
Only one clustered index per table
Helps in improving the performance of queries that involve range searches or sorting
Example: Clustered index on a table's primary key
Integrity rules in a DBMS ensure data accuracy, consistency, and reliability.
Constraints like primary key, foreign key, unique key enforce data integrity
Referential integrity ensures relationships between tables are maintained
Entity integrity ensures each row has a unique identifier
Domain integrity enforces valid data types and values
Check constraints validate data before insertion or update
Intension refers to the attributes or properties of a concept, while extension refers to the instances or examples of that concept in a database.
Intension describes the characteristics or properties of a concept.
Extension refers to the actual instances or examples of that concept.
For example, in a database of fruits, intension would include attributes like color, taste, and size, while extension would list specific fruits like apples, oranges, and bananas.
B+ Trees are advantageous in database management systems due to their ability to efficiently store and retrieve data.
B+ Trees have a high fanout, allowing for more keys to be stored in each node, reducing the height of the tree and improving search performance.
B+ Trees are balanced trees, ensuring that operations like search, insertion, and deletion have a predictable time complexity of O(log n).
B+ Trees are optimized for range queries, as the leaf nodes are linked together i...read more
A weak entity set is an entity set that does not have sufficient attributes to form a primary key on its own.
Weak entity sets depend on another entity set (strong entity set) to form a primary key.
They have a partial key which is a set of attributes that can uniquely identify entities within the weak entity set.
Examples include 'Order Item' which depends on 'Order' entity set to uniquely identify each item.
Another example is 'Dependent' entity set which depends on 'Employee' ...read more
Deadlock avoidance schemes are strategies used to prevent deadlocks in a system.
Banker's algorithm: Ensures that the system will never enter an unsafe state by keeping track of available resources and only granting a request if it does not lead to a deadlock.
Wait-die and Wound-wait: Two deadlock prevention schemes used in transaction processing systems to avoid deadlocks by allowing transactions to wait or abort based on their timestamps.
Resource allocation graph: A graph-bas...read more
Oracle Database Architecture is a set of physical and logical structures that manage data storage and retrieval.
Consists of physical structures like data files, control files, redo logs, and tablespaces
Includes logical structures like tables, indexes, views, and sequences
Uses memory structures like SGA (System Global Area) and PGA (Program Global Area)
Processes like background processes and server processes handle database operations
An Object-Oriented Database Management System (OODBMS) is a type of database management system that supports the creation and management of objects in a database.
OODBMS stores data in the form of objects, which can contain attributes and methods.
It allows for complex data structures and relationships to be represented more easily.
Examples of OODBMS include db4o, ObjectDB, and ObjectStore.
Explaining a complex joins problem in DBMS
Discussing the use of different types of joins like inner join, outer join, self join, etc.
Explaining how to handle null values and duplicates during joins
Demonstrating a scenario where multiple tables need to be joined based on different keys
Q38. What are DBMS? how do you manage them?
DBMS stands for Database Management System. It is a software that allows users to interact with databases.
DBMS is used to create, update, and manage databases.
It provides tools for data storage, retrieval, and manipulation.
Examples of DBMS include MySQL, Oracle Database, and Microsoft SQL Server.
DBMS was used to store and manage data in the project, handled problems by optimizing queries and database design.
Used DBMS to store and manage project data efficiently
Optimized queries for better performance
Designed database schema to handle data effectively
Resolved concurrency issues by implementing proper locking mechanisms
Q40. Whats the link between Data Structures and DBMS
Data structures are used to organize and store data efficiently, while DBMS is a software system that manages databases.
Data structures like arrays, linked lists, trees, and graphs are used to store and organize data in memory.
DBMS uses data structures to store and retrieve data from databases efficiently.
For example, a B-tree data structure is commonly used in DBMS for indexing and searching data.
Efficient data structures help improve the performance of DBMS operations like ...read more
Q41. Do you know anything about DBMS? Where is it used?
DBMS stands for Database Management System. It is used to manage and organize data in a structured manner.
DBMS is used in various industries such as healthcare, finance, education, and more.
It helps in creating, modifying, and deleting data in a database.
DBMS provides security features to protect data from unauthorized access.
Examples of DBMS include MySQL, Oracle, Microsoft SQL Server, and PostgreSQL.
Q42. What is dbms and what are its types?
DBMS stands for Database Management System. It is a software system that manages databases.
DBMS is used to store, retrieve, and manage data efficiently.
There are different types of DBMS such as relational, object-oriented, hierarchical, network, and more.
Relational DBMS is the most commonly used type and uses tables to store data.
Object-oriented DBMS stores data in objects and is used for complex data structures.
Hierarchical DBMS organizes data in a tree-like structure and is...read more
Q43. What is dbms and types
DBMS stands for Database Management System. It is a software that manages databases and allows users to interact with them.
DBMS is used to create, retrieve, update, and manage data in databases.
Types of DBMS include relational, hierarchical, network, object-oriented, and NoSQL.
Examples of popular DBMS include MySQL, Oracle, SQL Server, and MongoDB.
Data modeling is the process of creating a visual representation of data structures and relationships within a database.
Data modeling involves identifying entities, attributes, and relationships in a database.
It helps in organizing data in a way that is easy to understand and use.
Examples of data modeling tools include ER diagrams and UML diagrams.
Q45. What is dbms how it's work?
DBMS stands for Database Management System. It is a software system that manages and organizes data in a database.
DBMS is responsible for creating, maintaining, and manipulating data in a database.
It provides a way to store, retrieve, and update data in an organized manner.
Examples of DBMS include MySQL, Oracle, and Microsoft SQL Server.
DBMS uses a query language such as SQL to interact with the database.
It ensures data integrity and security by enforcing rules and constraint...read more
Q46. what is dbms explain in its importance
DBMS stands for Database Management System. It is a software that manages databases and allows users to interact with them.
DBMS helps in organizing and storing data efficiently.
It provides data security by controlling access to the database.
DBMS allows for data consistency and integrity through features like transactions and constraints.
It enables data sharing and collaboration among multiple users.
Examples of popular DBMS include MySQL, Oracle, and Microsoft SQL Server.
Q47. explain primary key in dbms
Primary key is a unique identifier for each record in a database table.
Primary key ensures data integrity and helps in faster data retrieval.
It cannot have null values and must be unique for each record.
It can be a single column or a combination of columns.
Examples of primary keys are social security number, email address, etc.
Q48. The meaning of DBMS is database management system, it's manage the data
DBMS stands for Database Management System which is a software system that allows users to define, create, maintain and control access to the database.
DBMS is a software system that manages the storage, organization, retrieval, security, and integrity of data in a database.
It allows users to define the structure of the database, create and modify data, and control access to the data.
Examples of popular DBMS include Oracle, MySQL, Microsoft SQL Server, and PostgreSQL.
Q49. What is DBMS?which db u have used
DBMS stands for Database Management System. It is a software system that allows users to define, create, maintain and control access to databases.
DBMS is used to manage and organize data in a structured manner.
It provides a way to store, retrieve and manipulate data efficiently.
Examples of DBMS include MySQL, Oracle, SQL Server, and MongoDB.
DBMS can be used in various applications such as banking, healthcare, e-commerce, and more.
Q50. What is DBMS in Oracle ?
DBMS in Oracle stands for Database Management System, which is a software that manages the storage, retrieval, and organization of data in a database.
DBMS in Oracle is a software system that allows users to define, create, maintain, and control access to the database.
It provides an interface for users to interact with the database and perform various operations like querying, updating, and managing data.
Oracle Database is a popular DBMS that offers features such as data secur...read more
Q51. What are the disadvantages of DBMS?
Disadvantages of DBMS include high cost, complexity, potential for data loss, and security vulnerabilities.
High cost of implementation and maintenance
Complexity in managing and scaling the database
Potential for data loss due to system failures or human errors
Security vulnerabilities that can lead to data breaches
Dependency on a single vendor for support and updates
Q52. What is the difference between DBMS and NoSQL?
DBMS is a traditional relational database management system, while NoSQL is a non-relational database management system.
DBMS uses structured query language (SQL) for querying and managing data, while NoSQL databases use different query languages or APIs.
DBMS is typically used for structured data with predefined schemas, while NoSQL is more flexible and can handle unstructured or semi-structured data.
DBMS is ACID-compliant (Atomicity, Consistency, Isolation, Durability), ensur...read more
Q53. What is mutex in dbms?
Mutex in DBMS stands for mutual exclusion and is used to control access to shared resources to prevent data inconsistency.
Mutex ensures that only one process can access a shared resource at a time
It helps prevent data corruption and maintain data integrity
Mutex is commonly used in database management systems to control access to critical sections of code
Example: In a multi-threaded database system, mutex can be used to lock a table while it is being updated to prevent concurr...read more
Q54. what about new technologies of DBMS
New technologies of DBMS are constantly emerging to improve data management and analysis.
New SQL databases like CockroachDB and TiDB are gaining popularity for their scalability and distributed architecture.
NoSQL databases like MongoDB and Cassandra are widely used for their flexibility and ability to handle unstructured data.
Graph databases like Neo4j and OrientDB are becoming popular for their ability to handle complex relationships between data.
In-memory databases like Red...read more
Q55. Explain DBMS along with CRUD
DBMS is a software system that manages databases, while CRUD stands for Create, Read, Update, Delete operations in databases.
DBMS (Database Management System) is a software system that allows users to interact with databases.
CRUD stands for Create, Read, Update, Delete - the four basic functions of persistent storage.
Examples: Creating a new record in a database (Create), Reading data from a database (Read), Updating existing data in a database (Update), Deleting data from a ...read more
Q56. Explain DBMS and its needs
DBMS stands for Database Management System, it is a software that manages databases and allows users to interact with them.
DBMS is used to create, retrieve, update, and manage data in databases.
It provides a way to store and organize data efficiently.
DBMS ensures data integrity, security, and consistency.
Examples of DBMS include MySQL, Oracle, SQL Server, and PostgreSQL.
Q57. What are the difference between types of normal forms in DBMS
Different normal forms in DBMS help in organizing data efficiently and reducing redundancy.
First Normal Form (1NF) - Eliminates repeating groups and ensures each attribute contains only atomic values.
Second Normal Form (2NF) - Meets 1NF requirements and all non-key attributes are fully functional dependent on the primary key.
Third Normal Form (3NF) - Meets 2NF requirements and eliminates transitive dependencies between non-key attributes.
Boyce-Codd Normal Form (BCNF) - A stro...read more
Q58. What is an instance of a DBMS?
An instance of a DBMS is a specific installation of a database management system software.
An instance is a running copy of a DBMS software.
It can be installed on a single computer or a network of computers.
Each instance has its own set of databases and users.
Examples of DBMS instances include Oracle Database, Microsoft SQL Server, and MySQL.
Passwords are typically stored in a DBMS using encryption techniques to ensure security.
Passwords are often hashed using algorithms like SHA-256 before being stored in the database.
Salt is commonly added to passwords before hashing to prevent rainbow table attacks.
Some DBMS also support encryption at rest to further secure stored passwords.
Access controls and proper user authentication mechanisms are crucial to protect password data.
Examples of hashing algorithms used for pas...read more
Q60. What is DBMS ? What DBMS language are familiar to you.
DBMS stands for Database Management System. It is a software that manages databases and allows users to interact with them.
DBMS is used to create, retrieve, update, and manage data in a database.
Common DBMS languages include SQL (Structured Query Language), MySQL, Oracle, and Microsoft SQL Server.
SQL is a standard language for interacting with relational databases.
MySQL is an open-source relational database management system.
Oracle is a popular enterprise-level DBMS.
Microsoft...read more
The ER Model is a conceptual data model that describes the data and relationships in a system using entities and their attributes.
ER Model stands for Entity-Relationship Model
It is used to represent the logical structure of a database
Entities are objects or concepts in the real world that are represented in the database
Attributes are properties that describe the entities
Relationships define how entities are related to each other
Example: In a library database, 'Book' is an ent...read more
Functional relations in DBMS define a relationship between input and output values where each input has a unique output.
Functional relations ensure that each input value maps to only one output value.
They are commonly used in database design to enforce data integrity and consistency.
For example, in a table storing employee information, the employee ID can be a functional key that uniquely identifies each employee.
Q63. Designing dbms for a college website
Designing a DBMS for a college website involves creating tables for students, courses, faculty, and more.
Create tables for students, courses, faculty, departments, etc.
Establish relationships between tables using foreign keys.
Include attributes like student ID, course ID, faculty ID, etc.
Implement normalization to reduce redundancy and improve data integrity.
Consider implementing views for complex queries or reports.
Q64. advantages of dbms?
DBMS provides data consistency, security, efficiency, and scalability.
Data consistency ensures that all data in the database is accurate and up-to-date.
Security features protect sensitive information from unauthorized access.
Efficiency in data retrieval and storage operations improves overall performance.
Scalability allows for the database to grow and handle increasing amounts of data.
Examples: Oracle, MySQL, SQL Server
Q65. Establishe DBMS?data base management system,it's manage or control the data
A DBMS is a software system that manages and controls the storage, organization, and retrieval of data in a database.
DBMS provides a way to store and retrieve data efficiently.
It allows multiple users to access the same data simultaneously.
It ensures data integrity and security.
Examples of DBMS include Oracle, MySQL, and Microsoft SQL Server.
Q66. Types of integrity in dbms? (Ans- Foreign, referential, domain)
Types of integrity in DBMS include foreign, referential, and domain.
Foreign integrity ensures that foreign key values in a table match primary key values in another table.
Referential integrity ensures that relationships between tables are maintained, preventing orphaned or invalid data.
Domain integrity ensures that data in a column adheres to specified data types, formats, or constraints.
For example, in a database for an online store, foreign integrity would ensure that a cus...read more
Q67. Constraints in DBMS
Constraints in DBMS ensure data integrity and consistency.
Constraints are rules that limit the type of data that can be inserted into a database table.
They ensure data integrity and consistency by preventing invalid data from being entered.
Examples of constraints include primary keys, foreign keys, unique constraints, and check constraints.
Q68. DBMS VS FS describe
DBMS is a software system that manages databases, while FS is a system that manages files and directories.
DBMS stores data in structured format with relationships between entities
FS stores data in files and directories without relationships
DBMS provides ACID properties for transactions
FS does not provide ACID properties
Examples: MySQL, Oracle for DBMS; NTFS, ext4 for FS
Q69. DBMS Locking exmple with a scenario
DBMS locking is a mechanism to manage concurrent access to data in a database to prevent data corruption.
Locking is used to ensure data integrity and consistency in a multi-user environment.
Types of locks include shared locks, exclusive locks, and update locks.
Example scenario: Two users trying to update the same record simultaneously - one user gets an exclusive lock while the other waits.
Deadlocks can occur when two transactions are waiting for each other to release locks.
Q70. aggregation functions in DBMS?
Aggregation functions are used to perform calculations on groups of data in a database.
Aggregation functions include COUNT, SUM, AVG, MAX, and MIN.
They are used with the GROUP BY clause to group data based on a specific column.
COUNT function returns the number of rows in a table or the number of non-null values in a column.
SUM function returns the sum of values in a column.
AVG function returns the average of values in a column.
MAX function returns the maximum value in a colum...read more
Q71. What is a difference between dbms and rdbms
DBMS is a software system to manage databases while RDBMS is a type of DBMS that stores data in a structured manner.
DBMS stands for Database Management System while RDBMS stands for Relational Database Management System.
DBMS can manage any type of database while RDBMS manages only relational databases.
DBMS does not enforce any specific data model while RDBMS enforces the relational data model.
Examples of DBMS include MongoDB and Cassandra while examples of RDBMS include MySQL...read more
Joins in database management systems are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN returns all rows from the...read more
Q73. How would you design DBMS for Snapdeal’s website’s shoe section. Now if you want to further break it into Sports and Casual Shoe would you break the DB into two or add another entity?
For Snapdeal's shoe section, I would design a DBMS with separate entities for Sports and Casual Shoes.
Create a main entity for shoes with attributes like brand, size, color, etc.
Create separate entities for Sports and Casual Shoes with attributes specific to each category.
Link the Sports and Casual Shoe entities to the main Shoe entity using a foreign key.
Use indexing and normalization techniques to optimize performance and reduce redundancy.
Consider implementing a search fea...read more
Q74. What is dbms and SQL questions
DBMS stands for Database Management System, which is a software that manages databases. SQL is a language used to interact with databases.
DBMS is a software that allows users to create, retrieve, update, and manage databases.
SQL (Structured Query Language) is a language used to communicate with databases.
DBMS and SQL are commonly used in software development for storing and retrieving data efficiently.
Examples of popular DBMS include MySQL, Oracle, SQL Server, and PostgreSQL....read more
Q75. What is dbms and explain all kinds of normalization in oracle
DBMS stands for Database Management System. Normalization in Oracle is the process of organizing data in a database efficiently.
DBMS is a software that manages databases, allowing users to store, retrieve, and manipulate data.
Normalization in Oracle involves organizing data into tables and columns to reduce redundancy and improve data integrity.
There are different levels of normalization, such as First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), and ...read more
Q76. What is dbms.different keys and its uses
DBMS keys are used to uniquely identify a record in a table. Primary, foreign, candidate, and super keys are some of the types.
Primary key: uniquely identifies a record in a table
Foreign key: links two tables together
Candidate key: can be used as a primary key
Super key: a set of attributes that can uniquely identify a record
Composite key: a combination of two or more attributes used as a primary key
Core concepts of indexing in DBMS include types of indexes, benefits of indexing, and factors affecting index performance.
Types of indexes: B-tree, Hash, Bitmap, etc.
Benefits of indexing: Faster data retrieval, improved query performance, reduced disk I/O.
Factors affecting index performance: Selectivity, clustering factor, index fragmentation.
Examples: Creating an index on a column in a table to speed up search queries.
An aggregate function is a function where the values of multiple rows are grouped together to form a single summary value.
Used in SQL to perform calculations on sets of values
Examples include SUM, AVG, COUNT, MIN, MAX
Can be used with GROUP BY clause to group results
Q79. explain me Sharding in DBMS
Sharding is a technique used in DBMS to horizontally partition data across multiple databases to improve performance and scalability.
Sharding involves breaking up a large database into smaller, more manageable pieces called shards.
Each shard contains a subset of the data, allowing for parallel processing and improved performance.
Sharding helps distribute the workload across multiple servers, reducing the load on any single server.
Examples of sharding implementations include M...read more
BCNF is a normal form in database management systems that ensures all determinants are candidate keys.
BCNF stands for Boyce-Codd Normal Form.
It is a stricter version of 3NF (Third Normal Form).
In BCNF, every determinant must be a candidate key.
It helps in reducing redundancy and anomalies in the database.
Example: If a table has columns A, B, and C, and A determines B and B determines C, then it is not in BCNF unless A is a candidate key.
Q81. What is DBMS? Are you aware about mysql
DBMS stands for Database Management System. Yes, I am aware of MySQL.
DBMS is a software that manages databases, allowing users to interact with the data stored within them.
MySQL is a popular open-source relational database management system.
DBMS provides functionalities like data storage, retrieval, update, and deletion.
MySQL uses SQL (Structured Query Language) for querying and managing the database.
DBMS ensures data integrity, security, and concurrency control.
Q82. What is foreign key and how you can you can use foreign key in your DBMS system?
Foreign key is a key used to link two tables in a database, enforcing referential integrity.
Foreign key is a column or a set of columns in one table that references the primary key in another table.
It ensures that the values in the foreign key column(s) match the values in the primary key column of the referenced table.
Foreign key constraints help maintain data integrity by preventing actions that would destroy links between tables.
For example, in a database with tables 'Orde...read more
Q83. What is a view in dbms?
A view in DBMS is a virtual table created by a query that can be used like a regular table.
Views are used to simplify complex queries by storing them as a virtual table.
They can also be used to restrict access to certain columns or rows of a table.
Views do not store data themselves, but instead display data from the underlying tables.
Changes made to the data in a view will affect the underlying tables.
Example: CREATE VIEW view_name AS SELECT column1, column2 FROM table_name W...read more
Q84. what is dbms and tell its acid propertie
DBMS is a software system that manages databases and their access. ACID properties ensure data consistency and reliability.
DBMS stands for Database Management System
It is a software system that manages databases and their access
ACID properties ensure data consistency and reliability
ACID stands for Atomicity, Consistency, Isolation, and Durability
Atomicity ensures that a transaction is treated as a single unit of work
Consistency ensures that the database remains in a valid sta...read more
Q85. Difference between RDMS and DBMS
RDBMS is a type of DBMS that manages data in a structured format using tables with relationships.
RDBMS enforces ACID properties (Atomicity, Consistency, Isolation, Durability) for data integrity.
DBMS is a general term for any system that manages databases, while RDBMS specifically refers to relational databases.
Examples of RDBMS include MySQL, Oracle, SQL Server, while examples of DBMS include MongoDB, Redis.
RDBMS uses SQL for querying and managing data, while DBMS may use di...read more
Q86. What is relation between DBMS and Data Structure? ---told
DBMS manages data using data structures like B-trees, hash tables, etc.
DBMS uses data structures to organize and store data efficiently
Examples of data structures used in DBMS include B-trees, hash tables, linked lists, etc.
Efficient data retrieval and storage in DBMS is achieved through the use of appropriate data structures
Q87. Database and types of DBMS?
A database is a collection of organized data. Types of DBMS include relational, object-oriented, hierarchical, and network.
Relational DBMS: Organizes data into tables with rows and columns. Examples include MySQL, Oracle, and SQL Server.
Object-oriented DBMS: Stores data as objects. Examples include MongoDB and Cassandra.
Hierarchical DBMS: Organizes data in a tree-like structure. Example: IBM's Information Management System (IMS).
Network DBMS: Organizes data using a network mo...read more
Q88. Primary key in DBMS
Primary key is a unique identifier for each record in a database table.
Primary key ensures data integrity and helps in faster retrieval of data.
It cannot have null values and must be unique for each record.
Examples of primary keys include social security numbers, email addresses, and employee IDs.
Q89. DBMS what is database
A database is a collection of organized data that can be easily accessed, managed, and updated.
A database management system (DBMS) is software that allows users to interact with the database.
Data in a database is stored in tables, which consist of rows and columns.
Examples of popular DBMS include MySQL, Oracle, and Microsoft SQL Server.
Q90. Normal forms in dbms?
Normal forms in DBMS are rules to ensure database tables are structured efficiently.
1NF: Each column contains atomic values.
2NF: Non-key attributes are fully functional dependent on the primary key.
3NF: No transitive dependencies between non-prime attributes.
BCNF: Every determinant is a candidate key.
4NF: Multivalued dependencies are eliminated.
5NF: Join dependencies are eliminated.
Q91. What is oops?,what is different between dbms and rdbms?,mainly concentrate on java..
OOPs is a programming paradigm based on the concept of objects. DBMS is a software system to manage databases, while RDBMS is a type of DBMS that uses a relational model.
OOPs stands for Object-Oriented Programming System
Java is an OOPs language
DBMS is a software system to manage databases
RDBMS is a type of DBMS that uses a relational model
DBMS is used for small-scale applications, while RDBMS is used for large-scale applications
Java supports RDBMS through JDBC API
Q92. Whats is dbms and what are joins?
DBMS stands for Database Management System. Joins are used to combine rows from two or more tables based on a related column between them.
DBMS is a software that manages databases, allowing users to interact with the data stored in them.
Joins are used in SQL queries to combine data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Q93. what is DBMS in SQL?
DBMS in SQL stands for Database Management System, which is a software that allows users to interact with databases.
DBMS is a software that enables users to create, manage, and access databases.
It provides tools for data organization, storage, retrieval, and security.
Examples of popular DBMS in SQL include MySQL, Oracle Database, and Microsoft SQL Server.
Q94. Explain Normalisation in DBMS
Normalization in DBMS is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a database into smaller, more manageable tables.
It helps in reducing data redundancy by storing data in a structured manner.
Normalization ensures data integrity by minimizing data anomalies.
There are different normal forms like 1NF, 2NF, 3NF, BCNF, etc.
Example: In a database of students, instead of storing student details i...read more
Different types of keys in a database include primary key, foreign key, unique key, and composite key.
Primary key: uniquely identifies each record in a table, must be unique and not null.
Foreign key: establishes a link between two tables, ensures referential integrity.
Unique key: ensures that all values in a column are unique.
Composite key: combination of two or more columns to uniquely identify a record.
Q96. What is a DBMS ans what are the types
A DBMS (Database Management System) is a software that manages databases, allowing users to store, retrieve, and manipulate data efficiently.
DBMS types include relational, hierarchical, network, object-oriented, and NoSQL.
Relational DBMS (RDBMS) organizes data into tables with rows and columns, like MySQL and Oracle.
Hierarchical DBMS organizes data in a tree-like structure, like IBM's IMS.
Network DBMS allows multiple relationships between records, like IDMS and RDM.
Object-ori...read more
Q97. What is RDBMs?How is it different from dbms
RDBMS stands for Relational Database Management System. It is different from DBMS in terms of data organization and management.
RDBMS stores data in tables with predefined relationships between them, while DBMS stores data in files or folders.
RDBMS uses SQL (Structured Query Language) for data manipulation and retrieval, while DBMS uses a programming language or command-line interface.
RDBMS ensures data integrity and consistency through the use of constraints and transactions,...read more
Q98. What are joins in dbms
Joins in DBMS are used to combine rows from two or more tables based on a related column between them.
Joins help retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Q99. What Schooling in DBMS?
DBMS schooling typically includes courses in database design, implementation, management, and querying.
Courses in database design cover topics such as normalization, ER modeling, and schema design.
Implementation courses focus on creating and maintaining databases using tools like SQL Server or Oracle.
Management courses teach skills related to backup, recovery, security, and performance tuning.
Querying courses cover SQL syntax, joins, subqueries, and optimization techniques.
Q100. Normalization in DBMS (in detail with eg.)
Normalization is a process of organizing data in a database to reduce redundancy and dependency.
Normalization is used to eliminate data redundancy and improve data integrity.
It involves dividing a database into two or more tables and defining relationships between them.
There are different levels of normalization, such as first normal form (1NF), second normal form (2NF), and so on.
Normalization helps in efficient data retrieval and reduces the chances of data inconsistencies....read more
Top Interview Questions for Related Skills
Interview Questions of DBMS Related Designations
Interview experiences of popular companies
Reviews
Interviews
Salaries
Users/Month