Class-X-Solved Exercise:
Unit-11 Database Development(Basic)
Session-1 Database Concept
Session-2 Data Storage
Session-3 Manipulating Data
Session-4 Creating a Database Object
I. Objective Type Questions:
1. Fill in the blanks.
a. A ____ is an organized collection of data.
Answer: Database
b. A__ is a software package that can be used for creating and managing databases.
Answer: DBMS
c. A_______ is a database management system that is based on the relational model.
Answer: RDBMS
d. Three popular DBMS software are ______, _____, & ______.
Answer: IBM DB2, Microsoft Access, & MY SQL
e. A______ is a set of data elements that is organized using a model of vertical columns and horizontal rows.
Answer: Table
f. A____ is a set of data values of a particular simple type, one for each row of the table.
Answer: Column record
g. A____ represents a single, data item in a table.
Answer: Row
h. ______ are used to identify which type of data we are going to store in the database.
Answer: Data types
i. A_____ is a unique value that identifies a row in a table.
Answer: Primary key
j. OpenOffice is downloadable from ______ website.
Answer: www.openoffice.org
k. ______ is the database component of OOo.
Answer: OOCalc, OObase, OO Writer
2. Write 'T' for true and 'F' for false against the statement.
a. Columns of a table are termed as Records and rows are termed as fields.
Answer: F
b. Primary key field can contain duplicate values.
Answer: F
c. A character type field allows entry of any ASCII character.
Answer: T
d. OpenOffice database has .odb extension.
Answer: T
e. OpenOffice is a licensed software.
Answer: F
f. Base is a component of OpenOffice application suite.
Answer: T
g. When OOo gets loaded the Quick starter icon appears in the system tray.
Answer: T
h. Some components of OOo need Java files to run.
Answer: T
II. Multiple choice questions.
1. OpenOffice is a
a. Operating system b. An open source software
c. An integrated suit of office applications d. Both b) and c)
Answer: Both b and c
2. Which of the following is not a component of OpenOffice?
a. Calc b. Math c. Draw d. Paint
Answer: Paint
3. Which of the following is not a feature of OpenOffice?
a. Cross platform b. Open source c. Licensed software d. Provides file compatibility
Answer: Licensed software
4. The status bar is situated
a. Below the title bar b. Above the ruler bar c. At the bottom of the document window d. Above the title bar
Answer: At the bottom of the document window
5. The Navigation pane lists
a. Database objects b. Menu commands c. Database tables d. All of the above
Answer: Database tables
III. Short Answer Questions.
1. What does DBMS and RDBMS stands for? How is data organized in a RDBMS?
Answer: DBMS stands for Database management system.
RDBMS stands for Relational Database management system.
Relational database allows to store data in multiple tables connected with each other through a common field between them.
2. List the data types used in a DBMS/RDBMS?
Answer: Data Types:
Numeric Types
Alphanumeric types
Binary types
Data time
Other variable types
3. List data types available in Numeric and Alphanumeric Data type.
Answer: Data types available in Numeric data type.
BOOLEAN
TINYINT
INTEGER
BIGINT
NUMERIC
DECIMAL
REAL
FLOAT
DOUBLE
Data types available in Alphanumeric data type.
LONGVARCHAR
CHAR
VARCHAR
VARCHAR_IGNORE
CASE
4. List data types available in Binary Data type.
Answer: Data types available in Binary data type.
LONGVARBINARY
BINARY
VARBINARY
5. Define the terms:
a. Table b. Primary key c. Record
Answer:
Table: A table is a combination of Rows and Columns. A database comprises of one or more tables.
Primary Key: A field which contains unique data values and which identifies the records of a table uniquely is a primary key field in a table.
Record: A row of information in a table is termed as a record. It is the set of all data fields treated as a unit.
6. What is the significance of a data type for a field?
Answer: Data types of a field determine which type of data can be stored in that column or field.
7. What is the relationship between a field and a record?
Answer: Field: A single column in a table is called field.
Record: A row of information in a table is termed as a record.
Row is also called record and Column is also called field.
8. What is OpenOffice Base?
Answer: Open Office Base is a relational database management system. It is a program that facilitates the storage and retrieval of structured information on a computer's hard drive.
9. What is the use of Navigation pane?
Answer: The navigation pane allows you to access the related object and also gives you options to create the database.
10. List the features of OpenOffice Base.
Answer: Features of OpenOffice base:
1. No licensing fees.
2. Open source
3. Cross platform
4. Extensive language support
5. Consistent user interface
6. Integration
7. File compatibility
8. No vendor lock-in
Some other links:
No comments:
Post a Comment