Very short questions of DBMS

 Very short Questions of DBMS

Introduction:

Database Management Systems (DBMS) is an essential topic for students pursuing a degree in computer science or information technology. It is a fundamental component of many applications, and it is essential to understand the basics of DBMS to design, manage and manipulate databases effectively. For SEE students, understanding DBMS can help lay a strong foundation for future studies in computer science and other related fields. In this article, we will cover some very short questions of DBMS that SEE students may find useful.

1)  Define Data  (SEE 2073)

Ans: Data is the collection of facts.

 

2)  What is information  (SLC 2070)

Ans: Information is organized or classified data, which has some meaningful values for the receiver.

 

3) What do you mean by Database? (SEE 2073. 2074)

Ans: Database is the collection of information in organized form.

 

4)  What is Database Management System (DBMS)?

Ans:  DBMS is a software package designed to define, manipulate, retrieve and manage data in a database.

 

5) What is cell?

Ans: A cell is a intersection of row and columns.

 

 6) Define field?

Ans:  Field is an element in which one piece of information is stored

 

7) What is a tuple?

Ans: A single entry in a table is called a Tuple

 8) What do you mean by record?

Ans: A record is a collection of multiple related fields.

 9) What is table?

Ans: A table is a collection of rows having one or more columns.

 

10) What is purpose of table?

Ans: Table is used to store the data and information.

 

11) Which data type is used to store alpha numeric characters or special symbols in MS- Access?

Ans: Text data type is used to store alpha numeric characters or special symbols in MS-Access.

 

 12. Name view is used to modify a table in MS-Access.

Ans: Design view is used to modify a table in MS-Access.

 

13) What is relationship in database?

Ans: A relationship is a link between two or more tables.

 14)  What is Primary key?  (SEE 2073)

Ans: A primary key is the field that uniquely identifies each record in a table.

 15) Which objects of Ms-Access is used to enter the data?

Ans: Form and Table are used to enter the data.

16) In which object of Ms-Access we can display the data by giving criteria and condition.

Ans: Query is the object of Ms-Access where we can display the data by giving criteria and condition.

 17)  Which object of Ms-Access is used to display the data in printed format?

Ans: Report is the object of Ms-Access which is used to display the data in printed format.

 

18) Which data type of Ms-Access is used to store graphics, picture and sound.

Ans: OLE is the object of Ms-Access which is used to store graphics, picture and sound.

 

19) Which field property of Ms-Access is used to limits the value to be entered in the field.

Ans: Validation rule is used to limits the value to be entered in the field.

 

20)  What is the program that enables you to create, access and manage a database called?

Ans: Database Management System is the program used to create, access and manage a database.

Conclusion:

DBMS is an essential topic for students interested in computer science or information technology. Understanding the basics of DBMS can help lay a strong foundation for future studies and careers. In this article, we covered some very short questions of DBMS that SEE students may find useful. It is important to keep in mind that while these questions provide a basic understanding of DBMS, there is much more to learn and explore in this field. With the right knowledge and skills, students can go on to design, manage and manipulate databases effectively, and make valuable contributions in the field of computer science.

Also Read: 

Class 9 computer question model

Analytical questions of QBASIC

Numeric pattern in QBASIC