CLASS 8 DBMS CHAPTER 2

-

 Answer the following questions.

1.   Q1    List the types of DBMS. Which type is the most commonly used database and why?

ANS1. Following are the types of DBMS:-                              1.  Flat file Database

        2.    Relational Database

Relational Database Management System (RDBMS) is the most commonly used database because in RDBMS multiple tables are related to each other by using common fields.

2.      Q2 Why should one update a database regularly?

Ans2. Updating a database regularly is important because:

  1. To Keep Information Accurate: Data can change over time. For example, phone numbers, addresses, or prices may change. Regular updates keep the database correct.
  2. To Add New Data: New information is always being created. Adding it to the database keeps it complete and useful.
  3. To Remove Old or Useless Data: Outdated or incorrect data can cause confusion. Removing it helps keep the database clean and efficient.
  4. To Improve Performance: A well-maintained and updated database works faster and better.

3.       Q3. How does a DBMS eliminate inconsistency from the data?

Ans3. The data that appear more than once are updated automatically. Hence, data consistency is maintained. For example, change in the phone number of a patient will reflect in the personal details as well as in the bill.

4.       Q4. Differentiate between short text and long text data types.

ANS4. PAGE 38

5.        

 


Comments

Post a Comment

Popular posts from this blog

CLASS 8 DATA TYPES IN PYTHON

-
  DATA TYPES IN PYTHON A. Tick the correct option 1.   Which of the following is not a valid variable name? ANS1. a. Print 2.   Which of the following is not a string?   ANS2. a. 89 3.   How many types of number data type are there in Python? ANS C. 4 4.   Which of the following is a data type? ANS A. TUPLE 5.   Which of the following will you use to access a value stored in a dictionary? ANS C. [ ] B. Fill in the blanks 1.   A multiline string spreads across multiple lines. 2.   Data type is used to represent data in the memory of the computer. 3.   A tuple can consist of different types of values. 4.     A conditional statement can also be called a decision making statement. 5.     The IF conditional statement has code for the condition being true only. C  Write the output of the following code snippets. 1. >>> number_of_pages=200 >>>print( number_of_pag...
Read more

HTML 1 TEST ONLINE 20 MAY 2025

-
Image
                   QUESTION 3. Which HTML Tag is used to underline the text?                                 a. <U>   b. <I>    c. <TT>   d. <B>                               QUESTION 4. HTML Tags are written in                                 a. Capital letters                                b. Small letters                                c. Both Capital and Small letters                                d. No...
Read more

COMPUTER PRACTICAL CLASS VII

-
Image
 Q1.  Write the html code and find the output  Q2. Write the HTML CODE using Ordered List:- 1. English 2. Mathematics 3. Science  Q3 .  C  Write the output of the following code snippets. 1. >>> number_of_pages=200 >>>print( number_of_pages) 2. Given a list lst=["Monday","Tuesday","Wednesday","Thursday", "Friday","Saturday"] a. What statements will you write to print the elements stored at even indices? b. Write a statement to replace incorrect spelling with the correct spelling of Friday. c. Write a statement to print the number of elements in the list. d. Write a statement to print the first element of this list. 3. fruits=["apple,"mango","orange"] numbers=(5,4,3) alphabets={'a':'apple','b':'ball','c':'cat'} print(fruits) print(numbers) print(alphabets['b']) 4. >>>list1=[1,2,3,4] >>>list2=['i...
Read more