Q. What is a database?
Ans. A database is an organized collection of data.
Q. What is DBMS? Name two DBMS Software.
Ans. DBMS stands for Database Management system. It is software that controls the creation, maintenance, and use of a database.
Microsoft Access, MySQL
Q. What is the difference between Flat file and Relational ?
Flat File: Data is stored in a single table. This is usually suitable for less amount of data.
Relational: Data is stored in multiples tables which are linked by a common field. This is suitable for medium to large amount of data.
Q. What do you mean by database servers?
Ans. Database servers are dedicated computers that hold the actual databases and run only the DBMS and related software.
Q. Write four advantages of database.
1 It reduces Data Redundancy
- It allows sharing of data.
- It help to maintain data integrity.
- It provides Data Security.
Q. What do you mean by Data Redundancy?
Ans. Duplication of data in a database is known as data redundancy.
Q.What do you mean by Data Integrity?
Ans. Data integrity means that the data is accurate and consistent in the database.
Q. What is Data Consistency?
Ans. Data Consistency means there should be multiple mismatching copies of the same data in a database.
Q. Write two features of the database.
Ans. Two features of the database are :
- A database can have one or many tables.
- Every table in a database has a primary key field which ensures 100% unique values in the database
Q.What do you mean by RDBMS?
Ans. RDBMS stands for Relational Database Management System. When data is to be stored, maintained, and retrieved from multiple tables then special database softwis are required known as RDBMS.
Q.What is Primary Key?
Ans. A primary key is a unique value that identifies a row in a table. Primary Key helps the database to quickly search for a record.
Q.What do you mean by Composite Primary key?
Ans. When a primary key constraint is applied on one or more columns then it is known as Composite Primary Key.
Q.What is Foreign Key?
Ans. A Foreign Key is a field in one table that refers to the primary key of another table. It is used to link two tables.
Q.What do you mean by RDBMS?
Ans. RDBMS stands for Relational Database Management System. It is a database management system that is based on a relational model.
Q.Define the following terms :
1 Table
- Fields
- Records
Table: A table is a set of data elements that are organized in vertical columns and horizontal rows.
A record: Contains specific data, like information about a particular employee or a product. A field: Contains data about one aspect of the table subject, such as first name or e-mail address.
Q. What are the two ways of creating a table in OpenOffice Base?
Ans. Two ways of creating a table in OpenOffice Base are :
a. Create a table in design view
b. Use Wizard to create a table.
Q. What do you mean by Data type? Give an example of two data types used in OpenOffice Base.
Ans. Datatypes are used to identify which type of data (value) we are going to store in the database.
Numeric, Binary
Q. What is the difference between Char and Varchar data types?
Ans. Char is a fixed-length data type and Varchar is a variable-length data type.
Q. Write four data types available in Alphanumeric Data types
Ans. Four data types are available in Alphanumeric Data types :
LongVarchar
Char
Varchar
Varchar_Ignorecase
Q. Write four data types that are used to store numerical values.
Ans. Four data types that are used to store numerical values are
Smallint
Bigint
Integer
Float
Q. What do you mean by Datasheet View?
Ans. A view in which new data can be inserted and inserted data can be modified or removed in a table is called a datasheet view
Q. What do you mean by design view?
Ans. A view in which we can change the structure of the table is called a design view.
Q. What do you mean by Field Property in Base?
Ans. Those properties which determine the characteristics and behavior of fields are called field properties.
Q. Name two properties of Numeric type data.
Ans. Two properties of Numeric type data are :
Auto Value
Length
Q. Name two properties of Character type data.
Ans. Two properties of Character type data are :
Entry Required
Length
Q. What is the default length of Integer data type?
Ans. The default length of Integer data type is 10.
Q. What is the default length of Varchar data type?
Ans. The default length of Varchar data type is 50.
Q. Define the following field properties in reference to Open Office Base.
- Default Value
- Format
- Auto Value
- Entry Required
Ans – 1) Entry Required – if set to yes then it will be a must to insert the value in the field.
2) Length – By default length of the field is 10 but the size of the field can be set to maximum length.
3) Default Value – A default value can be set for a field if the user doesn’t provide any value while entering the values in the table.
4) Format – This property helps to set the format of the data entered in the field such as 91-222-333.
5) Auto Value – This is the property of Numeric Field type. If this property is set to Yes then numeric fieldwill get auto numeric value.
Q. What do you mean by Sorting?
Ans. Sorting means arranging the data in either ascending or descending order.
Q. What is Referential Integrity?
Ans. Referential Integrity is used to maintain the accuracy and consistency of data in relationships.
Q.What is Referential Integrity?
Ans. Referential Integrity is used to maintain the accuracy and consistency of data in relationships.
Q. How many types of relationships can be created between tables? Name them.
Ans. Three types of relationships can be created between tables.
One to One
One to Many or Many to One
Many to Many
Q. The relationship option is available in _ the menu.
Ans. Tool
Q. Write two advantages of a relationship created between two tables.
Ans. Two advantages of a relationship created between two tables are :
It reduces data entry errors.
It helps to summarize data from related tables
Q. What do you mean by query in Open Office Base?
Ans. A query is a request to collect specific information from a table or combination of tables.
Q. In how many ways you can create query in Open Office Base?
We can create query in Open Office Base by three ways which are :
Create query in Design view
Create query using Wizard
Create query in SQL view
Q. Name the Query language which is used in Base?
Ans. SQL
Q. Which command is used to retrieve data from the table?
Ans. Select command is used to retrieve data from the table.
Q. Name two categories of SQL Commands.
Ans. Two categories of SQL Commands are :
DDL
DML
Q. Differentiate between DDL and DML Commands.
Ans.
DDL
It stands for Data Definition Language
Example : Create, Alter, Drop
DML
It stands for Data Manipulation Language
Example : Insert, Update, Delete
Q. Name two clauses that can be used with Select Command.
Ans. Two clauses that can be used with Select Command are :
Where Clause
Order By Clause
Q. What is the purpose of the Where clause in Select Command?
Ans. Where Clause is used to retrieve specific records from the table.
Q. Write the shortcut to execute the query in “Create query in SQL view” of Base.
Ans. F5
Q. What is the purpose of Order by clause in Select Command?
Ans. Order by clause is used to arrange the records in ascending or descending order.
Q. What is Form in OpenOffice Base?
Ans. FORM: A form provides the user with a systematic way of storing information in the database. It is an interface in a user-specified layout that lets users view, enter, and change data directly in database objects such as tables.
Q. Write two ways of creating a form in Open Office Base.
Ans. Two ways of creating a form in Open Office Base are :
a. Create form in design view
b. Use Wizard to create a form
Q. What do you mean by Report in Open Office Base?
Ans – Report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format.
Q. Name the two types of reports created in OpenOffice Base.
Ans. Two types of reports created in OpenOffice Base are:
a. Static Report
b. Dynamic Report
Q. What do you mean by static report?
Ans. A report which does not show any change if we make any changes in the data of the table.
Q. What do you mean by dynamic report?
Ans. A report which shows the corresponding changes which we make in the data of the table.
Q. Can we enter records by report?
Ans. No
op
pad le kal paper hai