CBSE Class 10 Information Technology (IT) DBMS Unit 3 MCQ Question Answers

CBSE Class 10 Information Technology (IT) DBMS Unit 3 MCQ Question Answers

CBSE Class 10 Information Technology (IT) DBMS Unit 3 MCQ Question Answers Download for Session 2022-23.

MCQ / Class-X / IT / Unit 3-DBMS (Session 1 and 2)

Question/ Correct Answer / Question Type

1.Rajat had applied primary key constraint on three columns (fields) in a table of Database in RDBMS. But he is unable to recall the term used for it. Suggest him the correct term used for it from the following:

1. Foreign Key
2. Composite Primary Key
3. Primary Key
4. Secondary Key

b) Composite Primary Key

Conceptual

2. In which year, the relational model for database management based on first-order predicate logic was first formulated and proposed by Edgar F. Codd?

a) 1969

b) 1968

c) 1967

d)1966

a) 1969

Knowledge

3. Which data type in a database out of the following can be used for storing images, music files, photos and sound?

1. Boolean
2. Double
3. Integer
4. Binary

d) Binary

Understanding

4. Identify the type of category of My SQL commands to which CREATE, ALTER, and DROP statements belong.

1. DDL
2. DML
3. DSL
4. DTD

a) DDL

Understanding

5. In the relational model of a database, all data is represented in terms of    , grouped into relations.

1. fields
2. data item
3. tuples
4. columns

c) tuples

Knowledge

6. A table is a set of data elements that is organized using a model of vertical and horizontal.

a) rows, columns

d) columns, rows

Understanding

2. columns, rows
3. Cells, rows
4. Columns, cells

7. Referential integrity helps to avoid:

1. Deleting records from a primary key table if there are any matching related records available in associated table(s).
2. Adding records to a related table if there is no associated record available in the primary key table.
3. Changing values in a primary if any dependent records are present in associated table(s).
4. All of the above.

d) All of the above

Conceptual

8. Choose the statement which is not correct for the following statement.

Relationships between tables does not helps to:

1. Summarize data from related tables.
2. Save time as there is no need to enter the same data in separate tables.
3. Increase data-entry errors.
4. None of the above

c) Increase data-entry errors.

Understanding

9. ……………are the basic building blocks of a database.

1. Reports
2. Forms
3. Queries
4. Tables

d) Tables

Conceptual

10. …………. numeric data type can store integer range between 0 and 255.

1. INTEGER
2. BIGINT
3. TINYINT
4. SMALLINT

c) TINYINT

Knowledge

11.

Which field should be set as Primary key in the above given Client Table?

1. ClientID
2. Name
3. Address

a) ClientID

Understanding

d) None of these

12. ……………data type store both date and time information for a field in a table of a database in Open Office Base.

1. Time
2. Date
3. Timestamp
4. None of these

c) Timestamp

Knowledge

13. To create a table in My SQL- named as ‘detail’ with fields as Id, Name with size 30, Class with size 3, Address with size 35, use the command:

1. Desc table detail (Id int Primary Key, Name varchar(30), Class varchar(3), Address varchar(35));
2. Create table detail (Id int Primary Key, Name varchar(30), Class varchar(3), Address varchar(35));
3. Create table detail (Id int Primary Key; Name varchar(30); Class varchar(3); Address varchar(35));
4. Create detail (Id int Primary Key, Name varchar(30), Class varchar(3),

Address varchar(35));

b)Create table detail (Id int Primary Key, Name varchar(30), Class varchar(3), Address varchar(35));

Knowledge

14. Garvit wants to store values as True and False for the field ‘pass_with_distinction’. Help him to choose appropriate datatype for the same.

1. VARCHAR
2. CHAR
3. Boolean
4. LONGVARCHAR

c)Boolean

Conceptual

15. Match the following:

a) i-3, ii-2 ,iii-1,iv-4

b) i-3, ii-4 ,iii-1,iv-2

c) i-1, ii-2 ,iii-3,iv-4

d) i-4, ii-1 ,iii-2,iv-3

b) i-3, ii-4 , iii-1,iv-2

Knowledge

16. Assertion: A database is an integrated collection of data records, files, and other objects.

Reason: A database cannot have multiple

tables.

c) A is true but R is false

Understanding

1. Both, A and R, are true and R is the correct explanation of A

2. Both, A and R, are true but R is not the correct explanation of A

3. A is true but R is false

4. A is false but R is true

17.Data types in OpenOffice base are broadly classified into categories:

1. three
2. four
3. five
4. six

c) five

Knowledge

18. A row also called a    represents a single, data item in a table.

1. Record or Field
2. Tuple or Field
3. Field or Column
4. Record or Tuple

d) Record or Tuple

Conceptual

19.RDBMS stands for    ….

1. Relational Data Management System
2. Relative Database Management System
3. Relational Database Management System
4. Random Database Management System

c) Relational Database Management System

Knowledge

20. Assertion: Uniqueness in a database helps to avoid accidental duplication of records caused by user or computer error.

Reasoning: This can be achieved by using some number or value that uniquely identifies a record.

1. Both, A and R, are true and R is the correct explanation of A

2. Both, A and R, are true but R is not the correct explanation of A

3. A is true but R is false

4. A is false but R is true

a) Both, A and R, are true and R is the correct explanation of A

Understanding

CBSE Class 10 Information Technology (IT) DBMS Unit 3 MCQ Question Answers

All answers are given below each MCQs.