CBSE Class 10 Computer Science Database Management System MCQs

Question. Unlike filters queries can be saved as in a database ?
a) objects
b) filters
c) database
d) Any of the above

Answer : A

Question. A collection of interrelated records is called a ?
a) management information system
b) spreadsheet
c) database
d) text file

Answer : C

Question. The ability to find an individual item in a file immediately ?
a) sequential access
b) file allocation table
c) direct access
d) directory

Answer : C

Question. _______ provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorized access of data ?
a) DBMS
b) Tables
c) Database
d) Protection passwords

Answer : A

Question. The simultaneous execution of two or more instructions is called ?
a) sequential access
b) reduced instruction set computing
c) multiprocessing
d) disk mirroring

Answer : C

Question. The software that is used to create text-based documents are referred to as ___________ ?
a) DBMS
b) suites
c) spreadsheets
d) word processors

Answer : D

Question. A Field is a related group of __________ ?
a) Records
b) Files
c) Characters
d) Cables

Answer : C

Question. _____ search method is conducted for a specific title, domain, URL, or host ?
a) Keyword
b) Field
c) Boolean
d) Miscellaneous

Answer : B

Question. Where will we find the referential integrity command ?
a) Tools
b) View
c) Format
d) Table

Answer : D

Question. Participants can see and hear each other in a/an ?
a) electronic mail system
b) message system
c) teleconference
d) bulletin board

Answer : C

Question. The name of the location of a particular piece of data is its __________ ?
a) address
b) memory name
c) storage site
d) data location

Answer : A

Question. Which command we will give if we want to show the database objects with it's decription ?
a) Details
b) Show
c) List
d) None of the above

Answer : D

Question. What does the data dictionary identify ?
a) Field names
b) Field types
c) Field formates
d) All of the above

Answer : D

Question. In order to understand DBMS, it is important to understand ?
a) the physical schema
b) all sub schema that are system support
c) one sub schema
d) Both (a) and (b)

Answer : C

Question. Distributed processing involves ?
a) solving computer component problems from a different computer
b) solving computing problems by breaking them into smaller parts that are separately processed by different computers
c) allowing users to share files on a network
d) allowing users to access network resources away from the office

Answer : B

Question. An ad hoc query is a __________ ?
a) pre-planned question
b) pre-scheduled question
c) spur-of-the-moment question
d) question that will not return any results

Answer : C

Question. Which is one function of a database management system (DBMS) ?
a) Ensuring usability
b) Identifying what a user needs
c) Deciding what to do with legacy systems
d) Preventing errors arising, while enabling multiple, simultaneous users

Answer : D

Question. The DBMS acts as an interface between what two components of an enterprise-class database system ?
a) Database application and the database
b) Data and the database
c) The user and the database application
d) Database application and SQL

Answer : A

Question. A DBMS that combines a DBMS and an application generator is ________ ?
a) Microsoft’s SQL Server
b) Microsoft’s Access
c) IBM’s DB2
d) Oracle Corporation’s Oracle

Answer : B

Question. A tuple is a ?
a) column of a table
b) two-dimensional table
c) row of a table
d) key of a table

Answer : C

Question. Grouping and processing all of a firm’s transactions at one time is called ?
a) a database management system
b) batch processing
c) a real-time system
d) an on-line system

Answer : B

Question. You organise files by storing them in ?
a) archives
b) folders
c) indexes
d) lists

Answer : B

Question. Part number, part description, and number of parts ordered are examples of ?
a) control
b) output
c) processing
d) input

Answer : D

Question. How many options does a binary choice offer ?
a) One
b) Two
c) Three
d) It depends on the amount of memory in the computer

Answer : B

Question. E-R modeling technique is a ?
a) top-down approach
b) bottom-up approach
c) left-right approach
d) both top-down and bottom-up

Answer : A

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.