Cbse 10th IT Half Year Exam Question Paper

Cbse 10th IT Half Year Exam Question Paper

*Each question carries 1 marks*

*solve any 40 questions out of 45 questions*

Q.1. Which of the following is a type of DBMS model?

a) Relational

b) Network

c) Hierarchical

d) All of the above

Q.2. Which of the following is used to organize a database in DBMS?

a) Table

b) Views

c) Query

d) All of the above

Q.3. Which model uses a tree structure to represent relationships among data?

a) Relational Model

b) Network Model

c) Hierarchical Model

d) Object - Oriented Model

Q.4. What SQL statement retrieves data from a database?

a) SELECT

b) INSERT

c) UPDATE

d) DELETE

Q.5. What does normalization in a relational database help with? 

a) Avoiding redundancy

b) Increasing performance

c) Reducing query time

d) All of the above

Q.6. What is a primary key used for? 

a) Uniquely identify a record in a table

b) Enforce relationships between tables

c) Prevent data duplication

d) All of the above

Q.7. Which of the following is NOT a type of relationship in a relational database? 

a) One-to-One

b) One-to-Many

c) Many-to-Many

d) Many-to-One

Q.8. Which command is used to remove a table from a database in SQL? 

a) DELETE

b) DROP

c) REMOVE

d) TRUNCATE

Q.9. What is a foreign key in a relational database? 

a) A key used to identify a column uniquely in a table

b) A key used to connect two tables

c) A key that does not allow NULL values

d) A key used to store passwords

Q.10. What does referential integrity ensure in a relational database? 

a) Data integrity by ensuring consistency between linked tables

b) Uniqueness of rows in a table

c) Data is entered in the correct format

d) None of the above

Q.11. A _____ is a collection of all formatting information in LibreOffice Writer.

a) Template

b) Style

c) Layout

d) Design

Q.12. Writer provides ____ different types of Style in LibreOffice Writer.

a) 3

b) 4

c) 5

d) 6

Q.13. __ ___Style includes page layout like page size, page margin, borders and background, footnote and header and footer.

a) Page Style

b) Paragraph Style

c) Character Style

d) Frame Style

Q.14. Which shortcut key is used to open Style and Formatting windows in LibreOffice Writer.

a) F2

b) F12

c) F11

d) F10

Q.15. Grayscale is an example of which of the following:

a) image filter

b) image mode

c) image effect

d) none

Q.16. The language one has been exposed to since birth is known as

a) Mother Tongue

b) Local Language

c) Global Language

d) Own Language

Q.17. Effective communication involves

a) Speaking only

b) Listening only

c) Speaking and listening

d) Writing and reading

Q.18. When you apply a _______, you apply a group of formatting effects together in one single step.

a) effect

b) template

c) style

d) format

Q.19. Akshat wants to store a huge amount of information about his firm in a database. Which type of table organization would be most suitable for this purpose?

a) Relational

b) Flat file

c) Either relational or flat file

d) Hierarchical

Q.20. Which of the following What-lf analysis tools deals with multiple unknown variables?

a) Goal Seek

b) Solver

c) Scenario

d) None of these

Q.21. What are Styles? What are the advantages of using styles?

Q.22. What do you mean by table of content?

Q.23. What are templates? What are the advantages of using templates?

Q.24. What is track change in LibreOffice Writer?

Q.25. How to create a template from a document?

Q.26. What different types of keys are available in RDBMS?

Q.27. What is data type in database? Give examples.

Q.28. What do you mean by report in dbms? And explain types.

Q.29. 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? [CBSE 2007]

Q.30. What is the utility of primary key in database? Write distinct features of primary keys.[ CBSE 2013]

Q.31. Identify different types of non-verbal communication.

Q.32. Importance of Feedback?

Q.33. To become successful in life, which basic self – management skills do you require?

Q.34. What are the qualities of Self – motivated people?

Q.35. How can I improve my time management?

Q.36. What are the techniques that are used to manage stress?

Q.37. What is Goal Setting?

Q.38. Write some time management outcomes.

Q.39. write examples of any 4 different queries.

Q.40. What is consolidating data?

Q.41. What are subtotals in LibreOffice Calc?

Q.42. What is a scenario?

Q.43. What do you mean by goal seek?

Q.44. What is the purpose of adding comments?

Q.45. Explain record changes and accepting or rejecting changes.