Important Questions and Notes
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 Q2. A currency data type can only store monetary data that is in dollars. (a) … 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 Q2. Which of the following is NOT a DBMS? (a) MS … Read more
Chapter 8 Introduction to DBMS Notes: Important Points Chapter 8 Introduction to DBMS Notes: Important Points INTRODUCTION A database is an organized collection of data. It is considered as a container of information. In the manual system, you would maintain several files with different bits of information while in the computerized system you would use … 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 Q2. Sharing spreadsheet feature allows to save the changes in (a) multiple sheets(b) … 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
Ch 7 Share and Review a Spreadsheet Notes Ch 7 Share and Review a Spreadsheet Notes Introduction A shared spreadsheet is a sheet that can be accessed by more than one user and can allow them to make changes simultaneously on it. Sharing allows working in collaboration so that everyone can contribute, make changes and … Read more