DBMS Interview Questions - Set 1

DBMS Interview Questions

Share

This page consists of DBMS interview questions and answers.

Q1: What is DBMS?

DBMS or Database Management System is a collection of programs that allows users to create and manage databases.

Q2: Name some of the DBMS softwares?

Following are some of the popular DBMS softwares used in the industry.

  • Oracle Database
  • Microsoft SQL Server
  • IBM Db2
  • MySQL
  • MariaDB
  • SQLite
  • PostgreSQL

Q3: What is a database?

A database is a logical collection of organised data that can be easily accessed, updated and managed.

For example we can have a school database to store school related data.

Q4: What is a database system?

Collection of databases and DBMS software makes a database system.

Q5: What is RDBMS?

RDBMS or Relational Database Management System is a database management system based on the relational model invented by Edgar Frank Codd.

In RDBMS data is represented in terms of tuples or rows.

So, RDBMS consists of databases which contains tables which contains rows.

Q6: What is a table in database?

A table is a collection of related data stored in rows and columns.

For example we can have a students table to store student data like studentid, name etc.

Following is an example of a student table.

studentid firstname lastname modified_at created_at
s1 Yusuf Shakeel 2018-01-01 10:00:01 2018-01-01 10:00:01
s2 Jane Doe 2018-01-01 10:01:10 2018-01-01 10:01:10
s3 John Doe 2018-01-01 10:02:00 2018-01-01 10:02:00

Q7: What is a row of a table?

A row (also referred as record) is the horizontal entity of a table representing an individual entry.

Following is a row from the student table.

s1 Yusuf Shakeel 2018-01-01 10:00:01 2018-01-01 10:00:01

Q8: What is a field of a table?

A field is an entity of a table that contains specific data of every records.

Following are the fields of the student table.

  • studentid
  • firstname
  • lastname
  • modified_at
  • created_at

Q9: What is a column of a table?

A column is a vertical entity of a table representing all the data of a particular field.

Following is the firstname column of the student table.

firstname
Yusuf
Jane
John

Q10: List the advantage of using DBMS over file based system

Following are the advantage of using DBMS over file based system.

  • Controls data redundancy.
  • Provides multi user interface.
  • Restricts unauthorised access.
  • Provides different level of access to the users.
  • Data backup and recovery.
  • Enforces integrity constraints.
Share

Recently Updated