CBSE Class 10 Computer Science Database Management System MCQs

Question. In which relationship, no table has the primary key column?
a. Many to One
b. One to One
c. Many to Many
d. One to Many
Answer : C

Question. A __________ provides the user a systematic way of storing information into the database.
a. Query
b. Form
c. Table
d. None of the above
Answer : B

Question. Referential integrity refers to the _______________ between tables.
a. communication
b. consistency
c. relationship
d. joining
Answer : C

Question. Which of the following is a benefit of using a database management system?
a. Improved data security
b. Improved data accessibility
c. Improved data consistency
d. All of the above
Answer : D

Question. Which field property in Base must be set to “Yes” in order to require a value to be entered in a field?
a. Entry Required
b. Auto Value
c. Format
d. Length
Answer : A

Question. In which view can field properties be set in Base?
a. Design View
b. Datasheet View
c. Both of the above
d. None of the above
Answer : A

Question. __________ will help you to display summarized data from the database.
a. Report
b. Form
c. Table
d. None of the above
Answer : A

Question. Which of the following is NOT a type of database model?
a. Relational
b. Object-oriented
c. Hierarchical
d. Procedural
Answer : D

Question. What does a single data item in a table represent?
a. Columns
b. Attribute
c. Rows
d. Field
Answer : C

Question. Which query will display the details of all the students in increasing order of Roll number?
a. Select * from student order by ‘Rollno’;
b. Select * student order by ‘Rollno’;
c. Select all from student order by ‘Rollno’;
d. Select * from student orderby ‘Rollno’;
Answer : A

Question. Which of the following is an example of an open-source RDBMS?
a. Oracle
b. Microsoft Access
c. OpenOffice Base
d. Microsoft SQL Server
Answer : C

Question. Which toolbar helps us move from one record to another in a form in a database?
a. Formatting Toolbar
b. Image Toolbar
c. Standard Toolbar
d. Form Navigation Toolbar
Answer : D

Question. What is the correct query to increase the salary of all employees by Rs.10000 in a table named Employee with a column name of Salary?
a. Update Employee set Salary = Salary + 10000;
b. Update * Employee set Salary = Salary + 10000.
c. Update table Employee set Salary = Salary + 10000;
d. Update table Employee set Salary = 10000;
Answer : A

Question. Which clauses can be used with the SELECT statement?
a. Order by Clause
b. Where clause
c. Both a) and b)
d. None of the above
Answer : C

Short Answer Type Questions

Question. What is database? Give an example. What does DBMS stand for?
Answer : A collection of related information organised as tables is known as database e.g. INGRES, MySQL etc. DBMS stands for DataBase Management System. It is a computer-based record keeping system.

Question. What is Data Control Language?
Answer : Data Control Language is used to create roles, permissions, and referential integrity as well it is used to control access to the database by securing it. These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.

Question. What is field in database? Give an example.
Answer : A field is an area, reserved for a specific piece of data. It is also known as attribute. e.g. Customer Name.

Question. What is the value of Entry Required field?
Answer : The value of this property can be Yes or No. If entry required is Yes, the field cannot be absent i.e. should be necessarily present with a value.

Question. What does RDBMS stand for?
Answer : RDBMS stands for Relational Database Management System. It is a type of DBMS that stores data in the form of relations (tables).

Question. A table named School (containing data of students of the whole school) is created, where each record consists of several fields including AdmissionNo (Admission Number), RollNo
(Roll Number), Name. Which field out of these three should be set as the primary key and why?
Answer : AdmissionNo should be set as primary key because admission numbers are unique for each and every students of the school, which is not possible in the case with RollNo and Name.

Question. What is Data Transaction Control Language?
Answer : Transaction control commands manage changes made by DML commands. These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.

Question. Define forms and what is the need of using them?
Answer : A form is a window or screen that contains numerous fields or spaces to enter data. Forms can be used to view and edit your data. It is an interface in user specified layout.

Question. What is the difference between ‘Rows’ and ‘Columns’ in a table?
Answer : In a table, rows are called records and columns are termed a fields. A row stores complete information of a record whereas column stores only similar data values for all records.

Question. Give any two disadvantages of the database.
Answer : The two disadiantages of the database are as follows
(i) A database system creates additional complexity and requirements.
(ii) A database system is a multi-user software, which is less efficient.

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

Question. What is table? Also, define Candidate Key.
Answer : A table consists of a number of rows and columns. Each record contains values for the attributes. A candidate key is the smallest subset of the super key for which there does not exist a proper subset that is super key. Any candidate key can be choosen to uniquely identify the records, it is called primary key.

Question. Write one example of data field for which you would set the Required property to Yes.
Answer : In a table, when we declare a field as a primary key, then the field’s Required property must be set to yes because in a primary key field, we need to enter data always.

Question. Write any two uses of database management system.
Answer : The two uses of database management system are as follows
(i) DBMS is used to store data at a centralised location.
(ii) It is used to minimise data redundancy and data inconsistency.

Question. What is the purpose of Default Value field property?
Answer : If there is a situation when you want to enter same value for all records. Then, to avoid typing the same thing many times, you can set as a Default Value property.

Question. Why Memo data type is preferred over Text data type for a field?
Answer : When the length of the field is more than 255 characters. Text data type is not capable to store the project description because its length cannot be more than 255 characters so, Memo data type is preferred over Text data type.

Question. List datatypes available in Numeric data type.
Answer : Datatypes available in numeric data type are TINYINT, SMALLCINT, MEDIUMINT, INT and BIGINT.

Question. Write any two advantages of using database.
Answer : The two advantages of using database are as follows
(i) It can ensure data security.
(ii) It reduces the data redundancy.

Question. What happens when text is entered in a Number type field?
Answer : When we enter text in a Number field and press Enter or press Tab key, it displays a message that ‘‘The value you entered does not match the Number data type in this column.’’

Question. How is data organized in a RDBMS?
Answer : A relational database is a type of database. It uses a structure that allows us to identify and access datain relation to another piece of data in the database. Data in a relational database is organized into tables.

Question. Insert some information into a table COLLEGE, whose structure is given below.
Answer : 

LONG ANSWER TYPE QUESTIONS

Question. Describe any four major problems associated with sustainable development.
Answer : Four problems associated with sustained development are as follows
(i) The concept of sustainable development is subject to criticism. What, exactly, is to be sustained in a sustainable development? Any positive rate of exploitation of a non-renewable resource will eventually lead to exhaustion of Earth’s final stock.
(ii) Turning the concept of sustainability into policy raises questions about how to assess the wellbeing of present and future generations. The issue is more complicated because our children do not just inherit environmental pollution and resource depletion, but also enjoy the fruits of our labour, in the forms of education, skills, and knowledge (i.e. human capital), as well as physical capital.
(iii) Poor management of natural resources, combined with growing economic activities, will continue to pose serious challenges to environment. The problem arises because people, institutions and governments have failed to evolve mechanism and policies to strike a balance between development and conservation of resources and preservation of environment.
(iv) The commonly held view that greater economic activity necessarily hurts the environment, is based on static assumptions about technology, tastes and environmental investments. In reality, the relationships between inputs and outputs and the overall effects of economic activities on the environment, are continually changing.

Question. Why is it important to adopt sustainable development? Explain.
Answer : A three-year study using satellites and aerial photography undertaken by the United Nations long ago warned that the environment had deteriorated so badly that it was ‘critical’ in many of eighty-eight countries, investigated. In view of all these findings and problems, sustainable development acquires much importance.
Nature and mankind live and die together.
The Earth’s vital signs reveal a patient in declining health. We need to realise our ethical and moral obligations to the mother Earth. Human beings are caretakers of the planet and responsible trustees of the legacy of future generations.
Due to the realisation of importance of sustainable development, now there is a transcending concern for survival of the people and planet. We need to take a holistic view of the very basis of our existence. The environmental problem does not necessarily signal our demise, rather it is our passport for the future. To save ourselves and our future generations from catastrophe, we require to take a holistic view, an ecological view, seeing the world as an integrated whole, rather than a dissociated collection of parts.

Question. Mention the main principles of sustainable development.
Answer : Main principles of sustainable development are
(i) Respect and care for all forms of life.
(ii) Improving the quality of human life.
(iii) Minimising the depletion of natural resources.
(iv) Conserving the Earth’s vitality and diversity.
(v) Enabling communities to care for their own environment.
(vi) Changing personal attitude and practices towards the environment.

Question. Describe the meaning and importance of sustainable development.
Answer : Sustainable development refers to the process of economic development where resources are used judiciously to satisfy needs of not only present generation but also to conserve them for the use of future generations. Sustainable development takes place without depleting the present natural resources.
The importance of sustainable development is discussed below
(i) It helps to conserve and make use of means and resources for the maximum benefit without wastage.
(ii) It awares the people about the responsibility to use and preserve natural resources.
(iii) It creates the feeling that natural resources are the common property of all and nobody can use the property according to his personal will. It helps to conserve natural and social environment.
(iv) People’s participation is to be given priority in development work in order to achieve the aim of sustainable development.
(v) It attempts to create the concept of maintaining the present work for the future and conserving natural resources for future generation.