MENU

Chapter 3 Database Concepts Solutions

Question - 1 : - What is database? Give example.

Answer - 1 : - A collection of related information organised as tables is known as database, e.g. INGRES, MySQL etc.

Question - 2 : - Write the purpose of DBMS.

Answer - 2 : - DBMS is used to store logically related information at a centralised location. It facilitates data sharing among all the applications requiring it.

Question - 3 : - Write the relationship between a database and a table.

Answer - 3 : - A database contains multiple tables whereas, a table cannot exist outside a database.

Question - 4 : - Give any one use of database.

Answer - 4 : - A database is used to store logically related information in table.

Question - 5 : - What is field in database? Give an example.

Answer - 5 : - A field is an area, reserved for a specific piece of data. It is also known as attribute, e.g. Customer_Name.

Question - 6 : - Define the term DBMS.

Answer - 6 : - The full form of DBMS is Database Management System. It is a computer based record keeping system.

Question - 7 : - Give any two disadvantages of the database.

Answer - 7 : -

  • High complexity
  • Database failure

Question - 8 : - Give one advantage of using primary key.

Answer - 8 : - A primary key uniquely identifies the record in the table.

Question - 9 : - What is the significance of a primary key?

Answer - 9 : - A primary key cannot allow null values and must have a unique index.

Question - 10 : - Name two possible primary keys for an Employee table.

Answer - 10 : - Possible primary keys for an Employee table are empcode, empphonenumber.

Free - Previous Years Question Papers
Any questions? Ask us!
NodeJS Interview Questions Answers
ASP.Net Interview Questions Answers
Interview Questions Answers
×