database-interview-questions-answers

DBMS Interview Questions and Answers

What is DBMS?
A database management system (DBMS) is system software. The DBMS is used for creating databases and manipulating data and records in an organized way.

What is RDBMS?
RDBMS stands for Relational Database Management System. it is based on relational blocks. RDBMS replaces the traditional file system to store the data. All modern systems follow the concept of RDBMS. for example MS SQL Server, Oracle, MySQL etc.

What is Relational Database?
A relational database is a collection of tables and the tables are related to each other. Data is organized in the form of a matrix of rows and columns. The columns are Fields and Rows are the records.

What do you mean by Schema?

The Schema is the structure of Database System.

What is Database Model?
The database model is a conceptual model to represent the flow of data processing and manipulation techniques.It displays the Blueprint of a database.

What is ER-Model?
The entity-relationship model (or ER model) is a graphical representation of Database Model.  ER model uses different types of graphical shapes to represent the different types of the element of database systems.

What is Metadata?
Metadata is the information about other data stored.

What is data dictionary?
The data dictionary is the collection of Metadata. All the metadata are stored in data dictionary.

What is tuple?
A tuple is a row or a record in a table.

What is the unique key?
The unique key is a column of a table that is used to identify a column. It defines a column uniquely.No two rows can have the same unique key. It is used as a constraint to make records unique.

What is a foreign key?
A foreign key is a unique key of a table can is used as a reference in another table. A column in a table can be used to identify records in another table, then It will be a foreign key.

What is a composite key?
A composite key is a combination of keys that functions like a unique key. When two or more columns are required to Identify a record uniquely, then It will be called as a Composite key.

What is Index?
The index is a key that is used to search records in the database. An index makes searching and parsing of data easy. It can be used for sorting or grouping purpose in queries. It improves the runtime of queries.

What is the procedure?
We can say a procedure is a function defined in PL/SQL. It is the collection of multiple Structured Query Language. We cam implement modules in SQL using procedures.

What is a transaction?
A transaction is an independent thread in execution. It can be described on the basis of ACID properties.

Explain ACID properties?

ACID properties are associated with a database transaction. ACID stands for Atomicity, Consistency, Isolation, and Durability. A transaction must maintain these states during its execution.

What is aggregation?
Aggregating the values of many rows to produce an efficient result is known as aggregation in Database System. There are many functions to complete these tasks as SUM, COUNT, AVG etc.

What is normalization?
Normalization is a technique to process over a grouped records organized in tuples.

What are the database languages?
Database systems provide some standard communication that can be used to operate the systems. We can read, update, alter and store data in tables using these languages. For example, SQL is a database Language.

What is DDL – the Data Definition Language?
The database language for creating the structure is known as DDL or Data Definition Language. CREATE, ALTER, and DROP is the DDL parts.

What is DML – the data Manipulation Language?
DML is a tool to read and amend the data stored in the database. SELECT, INSERT, UPDATE are the part of DML.

Spread the love
Dhananjay

Dhananjay

I’m Dhananjay — a free-spirit with a passion for technologies and blogging.

View all posts by Dhananjay →

21 thoughts on “DBMS Interview Questions and Answers

  1. These are truly fantastic ideas in about blogging. You have touched some good factors here. Any way keep up wrinting.|

  2. Thanks for another fantastic post. Where else may anybody get that type of information in such a perfect method of writing? I’ve a presentation next week, and I’m at the search for such information.

  3. Hey would you mind letting me know which hosting company you’re working with? I’ve loaded your blog in 3 completely different web browsers and I must say this blog loads a lot quicker then most. Can you recommend a good internet hosting provider at a fair price? Many thanks, I appreciate it!

  4. I’ll right away take hold of your rss feed as I can’t to find your email subscription link or e-newsletter service. Do you’ve any? Please permit me recognise in order that I may subscribe. Thanks.|

  5. Wow, wonderful blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your web site is magnificent, as well as the content!|

  6. At this time it sounds like Drupal is the preferred blogging platform available right now. (from what I’ve read) Is that what you’re using on your blog?|

  7. Spot on with this write-up, I truly believe that this amazing site needs much more attention. I’ll probably be back again to see more, thanks for the information!

  8. Thanks on your marvelous posting! I definitely enjoyed reading it, you could be a great author. I will remember to bookmark your blog and may come back later in life. I want to encourage that you continue your great posts, have a nice evening!|

  9. It is not my first time to visit this web site, i am visiting this web page dailly and obtain pleasant data from here every day.|

  10. Hi! This post could not be written any better! Reading this post reminds me of my good old roommate! He always kept chatting about this. I will forward this post to him. Fairly certain he will have a good read. Thank you for sharing!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.