CBSE Class 10 Computer Science Database Management System

Question. A _________ is an organized collection of data.
a. Database
b. Digital Document
c. Spreadsheet
d. None of the above
Answer : A

Question. A database is an integrated collection of ___________.
a. Data records
b. Files
c. Objects
d. All of the above
Answer : D

Question. Example of the database ________.
a. Microsoft Access
b. OpenOffice Base
c. MySQL
d. All of the above
Answer : D

Question. DBMS Stands for __________.
a. Database Management System
b. Database Manage System
c. Data Manage System
d. None of the above
Answer : A

Question. Data can be organized into __________.
a. Flat File
b. Relational
c. Both a) and b)
d. None of the above
Answer : C

Question. When the same piece of data is stored in two or more locations, it is called ______________.
a. Data Redundancy
b. Data Integrity
c. Data Consistency
d. None of the above
Answer : A

Question. __________ are dedicated computers that hold the actual databases and run only the DBMS and related software.
a. Database Server
b. Decided Server
c. Web Server
d. None of the above
Answer : A

Question. When the primary key is applied on multiple columns is known as __________.
a. Primary Key
b. Composite Primary Key
c. Foreign Key
d. None of the above
Answer : B

Question. A ____________ is a collection of data components organized in the form of vertical columns and horizontal rows.
a. Table
b. Fields
c. Attributes
d. None of the above
Answer : A

Question. _________ prevents creating multiple copies in the database.
a. Data Redundancy
b. Data Integrity
c. Data Consistency
d. None of the above
Answer : A

Question. Data stored in a single table is known as __________.
a. Flat File
b. Relational
c. Both a) and b)
d. None of the above
Answer : A

Question. __________ in a table represents a set of information with the same structure in every row.
a. Tuples
b. Record
c. Both a) and b)
d. None of the above
Answer : C 

Question. What are the advantages of database __________.
a. Reduces Data Redundancy
b. Sharing of Data
c. Data Integrity
d. All of the above
Answer : D

Question.  __________ means that the data is accurate and consistent in the database.
a. Data Redundancy
b. Data Integrity
c. Data Consistency
d. None of the above
Answer : B

Question. A __________ is the actual text, number, or date that you enter when adding data to your database.
a. Values
b. Table
c. Boolean
d. None of the above
Answer : A

Question.  ________ is a software package that can be used for creating and managing databases.
a. Database Management System
b. Basedata Management System
c. Database Manage System
d. None of the above
Answer : A 

Question. Database Management System automatically takes care of ____________.
a. Data Redundancy
b. Backup and Recovery
c. Data Security
d. None of the above
Answer : B

Question. What are the different numerical data types?
a. Boolean
b. Tinyint & Smallint
c. Integer & Bigint
d. All of the above
Answer : D

Question. The unique field present in the table is called __________.
a. Primary Key
b. Candidate Key
c. Foreign Key
d. None of the above
Answer : A

Question. Only authorized users should be allowed to access the database and their identity should be authenticated using a username and password known as ________.
a. Data Redundancy
b. Data Consistency
c. Data Security
d. None of the above
Answer : C

Question. A database management system is a software package with computer programs that controls the___________.
a. Creation
b. Maintenance
c. Use of Database
d. All of the above
Answer : D

Question. _____________ are used to define the type of data that will be stored in the database.
a. Data Types
b. Data field
c. Key Data
d. None of the above
Answer : A

Question. ___________ prevent multiple mismatching copies of the same data in the database and only valid data will be added in the database.
a. Data Redundancy
b. Backup and Recovery
c. Data Consistency
d. None of the above
Answer : C

Question. The database concept has evolved since the _______.
a. 1980
b. 1960
c. 1955
d. 1950
Answer : B

Question. By default if the primary key is not defined that column is known as __________.
a. Primary Key
b. Candidate Key
c. Foreign Key
d. None of the above
Answer : C

Question. __________ types are used for describing numeric values for the field used in the table of a database.
a. Numeric Type
b. Alphanumeric Type
c. Boolean Type
d. Date & Time
Answer : A

Question. Shortcut key for executing query in OpenOffice base.
a. F2
b. F3
c. F4
d. F5
Answer : D

Question. If the user does not specify a value for a field while putting values into the table, a _____________ value can be assigned to it.
a. Default Value
b. Length
c. Format
d. None of the above
Answer : A

Question. A ________ is a collection of data values of a specific type, one for each row of a table.
a. Column
b. Row
c. Cell
d. None of the above
Answer : A

Question. ____________ data type can store UTF 8 Characters in the database.
a. Longvarchar
b. Char
c. Both a) and b)
d. None of the above
Answer : C

Question. A DBMS enables several user application programs to access the ________ database.
a. Other Database
b. Same Database
c. Both a) and b)
d. None of the above
Answer : B

Question. A row also called a Record or _________ represents a single, data item in a table.
a. Column
b. Tuples
c. Fields
d. None of the above
Answer : B

Question. Data is stored in multiple tables, which are connected together via a common field.
a. Flat File
b. Relational
c. Both a) and b)
d. None of the above
Answer : B

Question. A_________________ database management system is referred to as a relational model.
a. DBMS
b. RDBMS
c. DB
d. None of the above
Answer : B

Question. ____________ are the basic building blocks of a database.
a. Table
b. Query
c. Database
d. None of the above
Answer : A

Question. What are the different types of data type available in OpenOffice base?
a. Numeric Types
b. Alphanumeric Types
c. Binary Types & Date time
d. All of the above
Answer : D

Question. __________ is case sensitive data type in the database.
a. Longvarchar
b. Varchar_Ignorecase
c. Varchar
d. All of the above
Answer : B

Question. In a table, a __________ represents a single data item.
a. Row
b. Truple
c. Both a) and b)
d. None of the above
Answer : C

Question. SQL stands for _____________.
a. Single Query Language
b. Structured Query Language
c. Semantic Query Language
d. None of the above
Answer : B

Question. __________ key can store multiple same records in the table.
a. Primary Key
b. Candidate Key
c. Foreign Key
d. None of the above
Answer : C

Question. A table is a collection of data elements that are organized using a vertical __________ and horizontal ___________ model.
a. Column & Row
b. Row & Column
c. Column & Column
d. Row & Row
Answer : A

Question. A __________ statement used to display the zero record or multiple record from the database.
a. Select
b. Order By
c. Where
d. None of the above
Answer : A

Question. ___________ is the relationship, where both the tables must have primary key columns.
a. One to One
b. One to Many or Many to One
c. Many to Many
d. All of the above
Answer : A

Question. You can create tables in the database using _________.
a. Wizard
b. SQL
c. Both a) and b)
d. None of the above
Answer : C

Question. A popular data manipulation language is _________________.
a. Structured Query Language
b. Machine Level language
c. Low level language
d. None of the above
Answer : A

Question. To retrieve all the columns in a table the syntax is ___________.
a. Select $ from <tablename>;
b. Select * <tablename>;
c. Select * from <tablename>;
d. Select % <tablename>;
Answer : C

Question. There are ________ ways to create a table.
a. 1
b. 2
c. 3
d. 4
Answer : B

Question. The connection or association between two or more table is known as ____________
a. Connection
b. Relationship
c. Connector
d. None of the above
Answer : B

Question. A ____________________ is a standard for commands that define the different structures in a database.
a. Data Manipulation Language (DML)
b. Data Definition Language (DDL)
c. Both a) and b)
d. None of the above
Answer : B

Question. Relationships between tables help to __________.
a. Save time
b. Reduce data-entry errors
c. Summarize data from related tables
d. All of the above
Answer : D

Question. Field properties can be set in both the ________ and _________ .
a. Length & Default Value
b. Length & Entry
c. Both a) and b)
d. All of the above
Answer : C

Question. By default the length of the numerical data type is _______.
a. 05
b. 10
c. 20
d. 30
Answer : B

Question. ____________ is used to maintain accuracy and consistency of data in a relationship.
a. Referential data
b. Referential Integrity
c. Referential Value
d. None of the above
Answer : B

Question. ___________ data type can store 0 or 1 in the database.
a. Boolean
b. TinyInt
c. Smalint
d. BigInt
Answer : A

Question. In base, data can be linked between two or more tables with the help of ____________.
a. Primary Key
b. Foreign Key
c. Both a) and b)
d. None of the above
Answer : C

Question. ____________ in this relationship, one of them must have a primary key column.
a. One to One
b. One to Many or Many to One
c. Many to Many
d. All of the above
Answer : B 

Question. To display the records containing the same type of values _________ clause can be used with the Select SQL Command.
a. Where
b. More
c. Order
d. None of the above
Answer : A

Question. ________ means to arrange the data in either ascending order or descending order.
a. Filter
b. Sorting
c. Arrangement
d. None of the above
Answer : B

Question. _____________ are used to identify which type of data we are going to store in the database.
a. Datatype
b. DataItem
c. DataValue
d. DataCat
Answer : A

Question. A ______________ is a language that enables users to access and manipulate data in a database.
a. Data Manipulation Language (DML)
b. Data Definition Language (DDL)
c. Both a) and b)
d. None of the above
Answer : A

Question. Referential Integrity helps to avoid ____________.
a. If you want to add a record in the related table and if there is no associated record available in the primary key table.
b. Changing values in a primary if there are any dependent records in the related table.
c. Deleting records from a primary key table if there are any matching related records available in the associated table.
d. All of the above
Answer : D

Question. What are the different types of relationships which can be created in table___________.
a. One to One
b. One to Many or Many to One
c. Many to Many
d. All of the above
Answer : D

Question. A ____________ is a subset of DML that just deals with information retrieval.
a. Query Language
b. Structure Language
c. Both a) and b)
d. None of the above
Answer : A

Question. The relationship between two tables where one table has one record and another table has many records is known as ___________.
a. One-to-Many
b. Many-to-Many
c. Many-to-One
d. None of the above
Answer : A

Question. ___________ data types in a database can be used for storing photos, music, video or any file format.
a. Numerical Type
b. Alphanumeric Type
c. Binary Type
d. Date & Time
Answer : C

Question. _________ means that the query hides certain data and displays only what you want to see based on the criteria you provided.
a. Filtering
b. Sort
c. Query
d. All of the above
Answer : A

Question. Which datatype is used for storing date and time both in the database.
a. Date
b. Time
c. Timestamp
d. None of the above
Answer : C

Question. To view records in ascending order from a database.
a. Unorder by
b. Order by
c. Acc by
d. Decc by
Answer : B

Question. ___________ statement is used for modifying records in a database.
a. Modify
b. Update
c. Delete
d. Select
Answer : B

Question. There are __________ types of Relationships in a table.
a. 2
b. 3
c. 4
d. 5
Answer : B