Important Questions and Notes
Ch 11 Queries in LibreOffice Base Class 10 IT-402 Ch 11 Queries in LibreOffice Base Class 10 IT-402 A. Multiple choice questions Q1. Which of the following is refer to asking questions from the database? (a) Report(b) Table(c) Query(d) Database [showhide type=”links1″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (c) Query [/showhide] Q2. Which of the following … Read more
Ch 11 Queries in Libre Office Base NOTES Important Points Ch 11 Queries in Libre Office Base NOTES Important Points Introduction A database is used to store data in an organized manner. Queries are used to retrieve the desired data easily and accurately from database. In other words we can say that a query is … Read more
IT-402 Ch 10 Working with Multiple Tables Question Answers IT-402 Ch 10 Working with Multiple Tables Question Answers A. Multiple choice questions Q1. Which of the following actions can be performed once the tables are created in a database? (a) Add a field in a table(b) Rename a table(c) Delete a table(d) All of the … Read more
Ch 10 Working with Multiple Tables NOTES Important Points Ch 10 Working with Multiple Tables NOTES Important Points INTRODUCTION After creating the table in database, we may require to edit or delete the table. Sometimes we have to setup the relations between tables to control data redundancy and inconsistency. If you set up relations between … Read more
Ch 9 Starting with Libre Office Base Questions Answers Ch 9 Starting with Libre Office Base Questions Answers A. Multiple choice questions Q1. Which of the following is NOT a type of text data type? (a) Memo(b) Varchar(c) Float(d) Char [showhide type=”links1″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (c) Float [/showhide] Q2. A currency data type … Read more
Ch 9 Starting with LibreOffice Base Notes Important Points Ch 9 Starting with LibreOffice Base Notes Important Points Introduction LibreOffice Base is a free and open source DBMS. It can be downloaded from www.libreoffice.org. Data which we stored in DBMS can be a text, number, date or in any other form. So, we need to … Read more
Ch 8 Introduction to Database Management System Questions Answers Ch 8 Introduction to Database Management System Questions Answers A. Multiple choice questions Q1. Which of the following can not be considered as an example of a database? (a) Dictionary(b) Telephone directory(c) Marks Register(d) Newspaper [showhide type=”links1″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (d) Newspaper [/showhide] Q2. … Read more
Ch 7 Share and Review Spreadsheet Question Answers Ch 7 Share and Review Spreadsheet Question Answers A. Multiple choice questions Q1. Sharing allows to edit the Spreadsheet by (a) single user(b) different users simultaneously(c) one by one users(d) one after other users [showhide type=”links1″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (b) different users simultaneously [/showhide] Q2. … Read more
Ch 6 Linking Spreadsheet Data Notes Important Points Ch 6 Linking Spreadsheet Data Notes Important Points Introduction When the marks scored by each student in three terminal examinations are stored in three different sheets T1, T2, T3. Now to generate final result in single result sheet by finding the addition of marks of each subject, … Read more
Using Macros in Spreadsheet Question Answers Using Macros in Spreadsheet Question Answers A. Multiple choice questions 1. Macro Recordings can be enabled from the ________________ option in the menu bar. (a) Sheet(b) Data(c) Tools(d) Window. [showhide type=”links1″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (c) Tools [/showhide] 2. Which of the following is valid Macro Name? (a) … Read more