Class 10: Database management(Old Course)

 Database Management System 

Part 1: Very Short Questions (1 Mark)

1. What is a database?

A database is a collection of related data stored in a systematic way for a specific purpose.

2. What is data? 

Data refers to raw facts and figures collected from various sources.

3. Define information. 

Information is the meaningful result obtained after processing raw data.

4. What is the full form of DBMS? 

The full form is Database Management System.

5. Name any one DBMS software. 

Microsoft Access is a common DBMS software.

6. What is a table in a database? 

A table is a collection of data organized into rows and columns.

7. What is a field?

A field is a vertical column in a table that represents a specific unit of information.

8. What is a record? 

A record is a horizontal row in a table that contains complete information about a specific object or person.

9. What is a Primary Key? 

It is a field that uniquely identifies each record in a table and does not accept null values.

10. What is a Foreign Key? 

A Foreign Key is a field used to establish a relationship between two tables by referring to the primary key of another table.

11. What is MS-Access? 

It is a relational database management system software developed by Microsoft.

12. Name one object of MS-Access. 

A Query is one of the main objects in MS-Access.

13. What is a Query? 

A Query is an object used to retrieve, filter, or manipulate data from one or more tables.

14. What is a Form? 

A Form is a user interface used to enter, view, and edit data in a table.

15. What is a Report? 

A Report is an object used to present data from a table or query in a formatted, printable layout.

16. What is sorting?

Sorting is the process of arranging records in ascending or descending order.

17. What is filtering? 

Filtering is the process of displaying only the records that meet specific criteria.

18. Which data type is used for long descriptions? 

The Memo data type is used for detailed descriptions.

19. What is the default field size for Text data type? 

The default size is 50 characters.

20. What is the maximum size for Text data type? 

It can store up to 255 characters.

21. What is the storage size of the Number data type? 

It can take up to 4 bytes or more depending on its subtype.

22. What is the storage size of the Currency data type? 

It occupies 8 bytes of memory.

23. What is the storage size of the Yes/No data type? 

It occupies 1 bit.

24. What is an OLE Object? 

It stands for Object Linking and Embedding, used to link external files like images or documents.

25. What is a Hyperlink data type? 

It is used to store links to web pages, emails, or other files.

26. What is a Wizard in MS-Access? 

A Wizard is a tool that helps perform complex tasks through step-by-step instructions.

27. What is the use of the Caption property? 

It provides a descriptive label for a field to be displayed on forms or reports.

28. What is a Validation Rule? 

It is a property that limits the data values a user can enter into a field.

29. What is Validation Text? 

It is the message displayed when a user enters data that violates a validation rule.

30. What is the Required property? 

When set to Yes, it forces the user to enter a value in that field.

31. What is the default value property? 

It automatically fills a field with a predefined value when a new record is created.

32. What is Indexing? 

Indexing is used to speed up the process of searching and sorting data.

33. What is the difference between A to Z and Z to A sorting? 

A to Z is Ascending order, and Z to A is Descending order.

34. What is an Action Query? 

A query that changes data or the structure of a table.

35. Name one type of Action Query. 

An Update Query is a type of action query.

36. What is a Select Query? 

A query used to retrieve and display specific data from tables.

37. What is the use of the "Run" command in Queries? 

It executes the query to show the resulting data.

38. What is an expression in Access? 

It is a combination of operators, field names, and constants used for calculations.

39. What is Data Redundancy? 

It refers to the repetition of the same data in a database.

40. How does DBMS handle redundancy? 

It minimizes duplication by centralizing data storage.

41. What is the use of the "Freeze" command? 

It keeps specific columns visible while scrolling through other fields.

42. What is the use of "Hide Fields"? 

It temporarily hides columns in a table without deleting them.

43. What is the Memo data type's character limit? 

It can store up to 65,535 characters (implied as "long text").

44. Which data type generates numbers automatically? 

The AutoNumber data type.

45. What is an Entity? 

An entity is an object, person, or place about which data is stored.

46. What is a Null Value? 

A Null value represents missing or unknown information.

47. What is a Composite Key? 

A Primary Key consisting of more than one column.

48. Name a form layout. 

Columnar is one type of form layout.

49. What is an Attribute? 

An attribute is a characteristic or property of an entity (represented as a field).

50. What is the storage size of Date/Time data type? 

It occupies 8 bytes.

--------------------------------------------------------------------------------

Part 2: Short Questions (2 Marks)

1. Differentiate between Data and Information. 

Data consists of raw, unprocessed facts, while Information is organized data that provides clear meaning and is useful for decision-making.

2. Mention any two advantages of using a DBMS. 

It helps in controlling data redundancy and, 

it ensures data security by protecting information from unauthorized access.

3. Explain the term "Data Redundancy" in detail. 

Data redundancy is the unnecessary repetition of the same information in different places in a database, which wastes storage and can cause errors.

4. What are the features of a Primary Key? 

• A primary key must contain unique values, 
• It cannot be null, and
•  only one primary key is allowed per table.

5. Why is a Primary Key important in a table? 

It is important because it allows the system to uniquely identify every record and prevents duplicate entries, ensuring data accuracy.

6. Define a Foreign Key and its purpose. 

A Foreign Key is a field in one table that links to a primary key in another. Its purpose is to create a relationship between tables to maintain data integrity.

7. List four main objects of MS-Access. 

The four main objects are Tables, Queries, Forms, and Reports.

8. What is the difference between Design View and Datasheet View? 

Design View is used to create or change the structure of a table (fields and data types), while Datasheet View is used for entering and viewing data.

9. Describe the Text data type in MS-Access. 

The Text data type is used for short alphanumeric data up to 255 characters. It is commonly used for names and addresses where calculations are not needed.

10. When should a user choose the Memo data type over the Text data type? 

A user should choose Memo when the information is long, such as detailed notes, comments, or summaries that exceed 255 characters.

11. Explain the Currency data type with an example. T

he Currency data type is used for monetary values. It prevents rounding during calculations and adds symbols like Rs. or $ automatically.

12. What is the OLE Object data type used for? 

It is used to store objects like images, sounds, or documents from other programs (like Word or Excel) within the Access database.

13. Explain the purpose of the Validation Rule property. 

The Validation Rule is used to restrict data entry to ensure it meets specific criteria, such as requiring a number to be between 1 and 100.

14. How are Validation Rule and Validation Text related? 

The Validation Rule defines the allowed data, and the Validation Text provides the error message that pops up if the rule is broken.

15. What is the function of the "Default Value" property? It simplifies data entry by automatically inserting a specific value into a field every time a new record is added.

16. Differentiate between Sorting and Filtering. Sorting rearranges all records in a specific order, whereas Filtering hides all records except those that meet specific requirements.

17. What is a Query and why is it useful? 

A Query is a request for data. It is useful because it can extract specific records from huge tables based on the user's questions.

18. Name two types of Action Queries and describe one. 

Two types are Update and Delete queries. An Update query changes existing field values in a set of records based on criteria.

19. What is the purpose of the Form object? 

The Form object provides a user-friendly interface for data entry and navigation, making it easier than working directly in a table.

20. Why are Reports used in a database? 

Reports are used to present data in an organized and attractive layout specifically designed for printing and sharing information with others.

21. How can you add a new field to an existing table in MS-Access? 

Open the table in Design View, go to the end of the field list, type the new field name, and select the appropriate data type.

22. What is the use of the "Required" property in a field? 

The Required property ensures that a specific field is never left blank, which is essential for critical information like IDs or names.

23. Explain the concept of "Relationship" between tables. 

Relationship is a link between two tables using common fields. It allows the database to combine data from different tables for queries and reports.

24. What is a "Composite Primary Key"? 

A composite primary key is a primary key that consists of two or more fields combined to uniquely identify a record.

25. Define "Data Integrity" in a database. 

Data integrity refers to the accuracy and consistency of data stored in a database, often maintained through keys and validation rules.

26. Explain the "Input Mask" property. 

Input Mask provides a template or pattern (like ###-###) that helps users enter data correctly, such as phone numbers or dates.

27. What is the "AutoNumber" data type? 

It is a data type that automatically assigns a unique, sequential number to each new record, making it ideal for primary keys.

28. What is the "Yes/No" data type used for? 

It is used for fields that can have only one of two values, such as True/False, On/Off, or Yes/No.

29. Differentiate between a Field and a Record. 

A Field is a specific category of data (like 'Name'), while a Record is a collection of all fields for one specific entry (like 'John Doe's full info').

30. What happens if you open a table in "Datasheet View"? 

In Datasheet View, the table appears like a spreadsheet, allowing the user to view, edit, add, or delete actual data records.

31. Explain the "Indexed" property. 

The Indexed property speeds up searching and sorting for a specific field, though it can slightly slow down data entry.

32. What is a "Select Query"? 

A Select Query is the most common query type used to retrieve data from one or more tables and display the results in a datasheet.

33. Define "Calculated Field" in a Query. 

It is a field in a query that performs mathematical or logical operations using data from other fields, such as calculating 'Total' from 'Price' and 'Quantity'.

34. What is the "Lookup Wizard"? 

It is a tool used to create a drop-down list or a relationship that allows a user to choose a value from another table.

35. Name three layouts available for creating a Form. 

The three layouts are Columnar, Tabular, and Datasheet.

36. What is the "Print Preview" feature in Reports? 

Print Preview allows the user to see exactly how the report will look on paper before actually printing it.

37. How do you rename a table in MS-Access? 

Right-click on the table name in the navigation pane, select Rename, type the new name, and press Enter.

38. What is the "Design View" of a Query? 

It is a window where you select tables, choose fields, and set specific criteria to define what data the query should find.

39. Explain the "AND" operator in a Query criteria. 

The AND operator is used when you want the query to find records that meet all the specified conditions simultaneously.

40. Explain the "OR" operator in a Query criteria. 

The OR operator is used when you want the query to find records that meet at least one of the specified conditions.

41. What is the purpose of the "Total" row in a Query? 

The Total row allows you to perform aggregate functions like Sum, Avg, Count, Min, or Max on a group of records.

42. Describe the "Justified" layout of a form. 

In a Justified layout, fields are arranged in a balanced way across the form, usually showing one record at a time.

43. Why should you set a Field Size for a Number field? 

Setting a Field Size (like Integer or Long Integer) helps save memory and ensures that the data entered fits within specific limits.

44. What is the "Format" property used for? 

The Format property changes how data is displayed (like showing a date as 'Long Date') without changing the actual stored value.

45. Define "Action Query" and give an example. 

An Action Query is a query that makes changes to many records at once. An example is a Delete Query that removes all students from a specific city.

46. What is the use of the "Description" column in Design View? 

It is used to provide extra information about a field, which appears in the status bar when the user enters data.

47. How do you delete a record from a table? 

Select the entire row by clicking the record selector, then press the Delete key or use the Delete button in the Records group.

48. What is "Relational Database Management System" (RDBMS)? 

An RDBMS is a DBMS that manages data stored in related tables, allowing for complex data linking and retrieval.

49. Explain the "Allow Zero Length" property. 

This property determines whether a user can enter an empty string ("") into a text or memo field to indicate that the data is not applicable.

50. How can you change the order of fields in a table? 

In Design View, click and drag the field selector (the gray box to the left of the field name) to the new desired position

MS- Access

1.    Define Data. [2073]

A Collection of facts and figure is data.

2.    What do you mean by database [2073, 2074]

Database is a collection of information organized in proper form.

3.    What is database management system (DBMS)?

A Database Management System (DBMS) is a collection of software tools that enables users to create, define, manipulate, and manage databases.

4.    Define field.

A field is an element in which one piece of information is stored.

5.    What is a tuple?

A single entry in a table is called a tuple.

6.    Define record.

A record is a collection of multiple related data.

7.    Which data type is used to store alpha numeric character or special symbols in MS-Access?

Text data type is used to store alpha numeric character or special symbols in MS-Access.

8.    Which view is used to modify table in MS-Access.

Design view is used to modify table in MS-Access.

9.    What is relationship in database?

A relationship is a link between two or more table in a database.

10. What is primary key? [207 3)

A primary key is the field that uniquely identifies each record in a table.

11.  Which object of MS-Access is used to enter the data?

Forms and tables are used to enter data in MS-Access.

12. In which object of MS-Access we can display the data giving criteria and condition?

Queries are used to display data by applying criteria and conditions

13. Which object of MS-Access is used to display the data in printed form?

Reports are used to display data in printed form.

14. Which data type of MS-Access is used to store graphics, picture and sound?

OLE Object data type is used to store graphics, pictures, and sounds.

15. What data type is used to store numeric character or special symbols in MS-Access?

Text (Short Text) data type is used to store numeric characters or special symbols.

16. What view is used to modify  a table in MS-Access?

Datasheet View is used to view a table in MS-Access.

17. What data type is suitable to store photographs of students in MS-Access? [2078]

OLE Object or Attachment data type is suitable for storing student photographs.

18. Which view is used to modify table structure in MS-Access? [2078]

Design View is used to modify table structure.

19. What is the default extension of MS-Access? [2078]

 The default extension of MS-Access database files is .accdb.

20. Which object of MS-Access is used to retrieve data from a table?

 Queries are used to retrieve data from a table.

21. What is the default size of the text field in MS-Access? [2079]

The default size of the text field in MS-Access is 255 characters.

22.  What is a foreign key?

A field in a table that refers to the primary key of another table.

23. What is a query?

A database object that allows us to select, sort and filter data from a table or tables.

24. What is a form?

25. A database object that allows us to enter, edit and view data in a table.

26. What is a report?

27. A report is a database object that allows us to create formatted output of data from a table or tables.

 

2 marks questions

1.    What do you mean by database? Give example. [2073, 2074, 2068, 2070, 2072, 2073]

2.    A database is the collection of data that is organized so that its contents can easily be accessed, managed and updated.

3.    Write the importance of database.

Its importance includes:

·      Efficient Data Management: Helps in storing large amounts of data systematically.

·      Data Security: Protects sensitive information through access control.

·      Minimized Data Redundancy: Reduces duplicate data and ensures consistency.

·      Faster Data Retrieval: Allows quick access to required information.

·      Data Integrity and Accuracy: Ensures data remains accurate and consistent.

·      Easy Data Sharing: Multiple users can access and work on data simultaneously.

4.    Write the advantage of computerized database.

A computerized database offers several benefits over a manual database:

• Speed: Data can be stored, retrieved, and processed quickly.
• Accuracy: Reduces human errors and maintains data integrity.
• Storage Efficiency: Can store large volumes of data in a small space.
• Security: Provides access control to protect data.
• Data Analysis: Allows easy data sorting, filtering, and reporting.
• Backup and Recovery: Prevents data loss through automatic backup systems.

5.    What is database management system? [specific grid 2065]

A Database Management System (DBMS) is software that allows users to create, manage, and manipulate databases efficiently. It provides tools to store, retrieve, update, and organize data while ensuring security and consistency.

6.    List some popular database management system software.

Some popular database management system software are: Microsoft Access, MySQL, Oracle Database, Microsoft SQL server, SQLite

7.    Write some features of DBMS.

Some features Database Management System (DBMS) are::

Stores large amounts of structured data efficiently.

Controls access to prevent unauthorized use.

Ensures accuracy and correctness of data.

Changes in database structure do not affect applications.

Supports querying using SQL for data retrieval and analysis.

 Allows multiple users to access and manipulate data simultaneously.

8.    Write the advantages and disadvantages of DBMS.

Advantages:

• Data Redundancy Control: Eliminates duplicate data storage.
• Improved Data Security: Provides user authentication and access control.
• Efficient Data Access: Allows fast searching and retrieval using queries.
• Data Consistency: Ensures data accuracy across the system.

Disadvantages:

• High Cost: Requires expensive hardware, software, and maintenance.
• Complexity: Needs trained professionals to manage the system.
• Performance Issues: Large-scale databases may slow down operations.
• System Failure Risk: A database crash can affect multiple applications.

9.    Write the different elements of Database.

Different elements of Database are:

• Tables: Store data in rows and columns.
• Fields (Columns): Represent data attributes (e.g., Name, Age, Email).
• Records (Rows): A single data entry in a table.
• Keys (Primary & Foreign Keys): Ensure uniqueness and relationships between tables.
• Queries: Retrieve, filter, and manipulate data.
• Forms: Provide user-friendly interfaces for data entry.
• Reports: Present data in a structured format for printing.

10. What is Relational Database Management System (RDMS)?

A Relational Database Management System (RDBMS) is a type of DBMS that organizes data into related tables using rows and columns. It uses primary keys and foreign keys to establish relationships between tables. Examples include MySQL, Oracle, PostgreSQL, and MS SQL Server.

 

2.    Why is relationship needed in database?

Relationships in a database are important because:

• Avoids Data Redundancy: Prevents duplicate data storage.
• Ensures Data Integrity: Maintains accuracy and consistency.
• Improves Efficiency: Reduces data storage and retrieval complexity.
• Supports Data Analysis: Helps in linking and analyzing data from multiple tables.

3.    Write down the importance of primary key. [SEE 2073, 2075]

A primary key is used to avoid data redundancy or non repletion of data. Primary key is declared for unique field. Eg. Rollno, Acno, symbolno, etc.

4.    Define foreign key.

A foreign key is the linking pin between two tables.

5.    List the different objects of Microsoft Access.

The different objects of Microsoft Access are: table, report, query, macro, form, module.

6.    What is query? Write the importance of query. [specific grid 2065]

Query is one of the most important objects of Ms-Access. It is a way of retrieving and editing information according to the condition asked.

Importance of query:

a) It display result of different tables.

b) It sorts and filter the data.

c) It manipulates the data according to the user choice.

d) It can be used as a source of records for forms and reports.

7.    What is a table? List the importance of table.

A table is a collection of data about a specific topic. The importance of table are:

a) to store data about specific topic.

b) It hold the main information.

c) It facilitates grouping and storing the relevant data.

8.    In how many way you can create a table?

We can create a table in design view, using wizard and by entering data.

9.    What can you do in query?

We can do the following things in query:

a) To display or view the desired or required records.

b) to view change and analyze the data.

c) To give criteria ]for each field.

10. What is form? List the importance of form [2068, 2070, 2073]

A form is a database object which is designed to enter new records and edit existing records easily.

The importance of form are:

a) It is used to make modification or addition of data into the table.

b) We can enhance and control the data the way look on the screen.

c) We can view the table in user defined manner using form.

11. Write the advantages of form over a table.

The advantages of form over a table are:

a) Forms are easier to enter data than a table.

b) It is easier to make modification than table.

c) It is easier to focus on just information needed.

d) We can design the form in our own way to display data on screen.

12. List the different controls used in forms.

The different controls used in form are:

·      Select control

·      Moving control

·      Grouping control

·      Resizing control

·      Aligning control

13. What is report? Write the importance of report. [2072]

A report is a very important object in a database. A report is the effective way of presenting data in a printed format or on screen softcopy.

Importance of report are:

·      It allows us to complete output of our processed database.

·      It compare, summarize and subtotal a large database.

·      It can be used to develop attractive invoices, purchase order, mailing, labels, etc.

·      We can view the report in preview before printing.

14. What is a wizard?

A wizard is a small program that allow us to create a table, form, query or report in a specific format.

15. Write two differences between design view and wizard.

Two differences between Design view and wizard are:

Design View	Wizard
1. It takes more time.	It takes less time.
2. We can make our own design.	We can choose from pre-defined design.
3. We can create any field according to own requirement.	We can copy field form any of the simple table.

 

16. What is Data type? List the different data types used in Ms-Access.

Data type is an attribute for a field that determines what typ0e of data it can contain. Following are the datatypes used in MS-Access.

·      Text             

·      Memo

·      Number

·      Date/time

·      Currency

·      Auto number

·      Yes/No

·      OLE object

·      Hyperlink

·      Look wizard

17. List the different types of field properties of database.

·      Field size

·      Format

·      Input mask

·      Caption

·      Decimal place

·      Default value

·      Validation rule

·      Required

·      Allow zero length

·      Indexed

18.  Define sorting and filtering. (2068)

Data sorting is the process of arranging records in a particular order of a field. The order of sorting may be in ascending (A-Z) or descending (Z-A).

Filtering is the activity by which specified records only can be seen on the basis of criteria.

19. Write the difference between database and DBMS.

The differences between Database and DBMS are:

Database	DBMS
It is the collection of field or data.	It is the software to manage database.
It consists of data.	It manages data stored in database.
It is a part of DBMS.	It is a software system which contains database.
Example: Result sheet, Salary sheet, employee record, etc.	Example: Ms-Access, MySQL, FoxPro, etc.

 

20. What is field size.

Field size is a property to set maximum size for the data stored in a fixed set to the text, number or auto number, data type.

21. What is the difference between number and autonumber?

Number allows any number to be entered in the field where as autonumber insert unique number in the raw data automatically.

22. Write two uses of primary key. [2069]

Two uses of primary key are:

a) Use to uniquely identify the each record in database.

b) prevent data redundancy in the primary key field.

23. What is data redundancy? How can it be reduced in database? [2074]

The repetition of same piece of data in a database in more than one location is called data redundancy. Data redundancy can be minimized by normalization of database using primary key or foreign key.

24. Write two features of form. [2075]

Two features of form are:

a) It allows us to design the layout of field on screen in any arrangement.

b) It shows only the information we want to see.

25. Differentiate between field and record with an example. [2075 MP]

Field	Record
A column in a table is called a field and it contains a specific piece of information with a record.	Record is a collection of multiple fields in a row which gives complete information about a person or thing.
Example: Name, Address, Phone number	Example: Bharat Singh, Baidauli, 76411070

 

.