SESSION 2 : CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS

 

Unit – 3 DBMS

SESSION 2 : CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS

 

Q1. What do you mean by RDBMS?

Ans. RDBMS stands for Relational Database Management System. It is a database management system which is based on relational model.

 

Q2. Define the following terms :

1 Table

2. Fields

3. Records

Ans.

Table : A table is a set of data elements that is organized in vertical columns and horizontal rows.

Fields : A field is a set of data values of a particular simple type, one for each row of the table.

Records : A row also called a Record or Tuple represents a single, data item in a table.

 

Q3. What are the two ways of creating table in OpenOffice Base.

Ans. Two ways of creating table in OpenOffice Base are :

a. Create table in design view

b. Use Wizard to create table.

 

Q4. What do you mean by Data type? Give example of two data type used in OpenOffice Base.

Ans. Datatypes are used to identify which type of data (value) we are going to store in the database.

 

Q5. Identify the data type in which we can store the decimal value :

a. Boolean

b. TinyInt

c. Decimal

d. Real

e. Double

f. Smallint

Ans. Data types in which we can store the decimal value are :

c. Decimal

d. Real

e. Double

 

Q6. What is the difference between Char and Varchar data type?

Ans. Char is a fixed length data type and Varchar is a variable length data type.

 

Q7. Write the data type suitable for the following fields.

a. DateofBirth

b. Name

c. Rollno

d. Class

e. Email

f. City

Ans.

a. DateofBirth – Date

b. Name – Char or Varchar

c. Rollno – TinyInt / Smallint / Integer

d. Class – Char / Varchar

e. Email – Char or Varchar

f. City – Char or Varchar

Q8. Write four data types available in Alphanumeric Data types.

Ans. Four data types available in Alphanumeric Data types :

  1. LongVarchar
  2. Char
  3. Varchar
  4. Varchar_Ignorecase

 

Q9. Data in a (RDBMS) is organized in the form of __________________.

Ans. Tables.

 

Q10. In RDBMS table is also known as ________________

Ans. Relation

 

Q11. Write four data types which are used to store numerical value.

Ans. Four data types which are used to store numerical value are

  1. Smallint
  2. Bigint
  3. Integer
  4. Float

 

Q12. Write four appropriate field names and their data types to store record of student.

Ans. Four appropriate field names and their data types to store record of students are :

1 Name —————— Char / Varchar

2. Admno —————- Integer

3. Fees ——————–Float/Double

4. DOB ——————-Date

 

Q13. Write four appropriate field names and their data types to store record of book.

Ans. Four appropriate field names and their data types to store record of book are :

a. Author_name ————- Char / Varchar

b. Price ———————– Float / Decimal / Double

c. Class ———————– Char / Varchar

d. Subject ———————Char / Varchar

 

Q14. What is the default data type of a field while creating table in design view?

Ans. Varchar

 

Q15. _______________ are the basic building blocks of a database.

Ans. Tables

 

Q16. Write the expanded form of SQL

Ans. SQL : Structured Query Language

 

Q17. A table has __________________ (horizontal / Vertical) row and ____________________ columns (horizontal / Vertical).

Ans. Horizontal , Vertical

 

Q18. OpenOffice Base is an open source _________________ (DBMS / RDBMS )

Ans. RDBMS

 

Q19. ________________ (Database / Table ) wizard helps you to create a new database.

Ans. Database

 

Q20. Multiple tables can be created in a database. (T / F)

Ans. True

Comments

Post a Comment

Popular posts from this blog

SESSION 5: CREATE FORMS AND REPORTS USING WIZARD

  Unit – 3 DBMS SESSION 5: CREATE FORMS AND REPORTS USING WIZARD   Q1. What is Form in OpenOffice Base? Ans. A form provides the user a systematic way of storing information into the database.   Q2. Name the interface which lets users to view, enter, and change data directly in database. Ans. Form   Q3. Write two ways of creating form in Open Office Base. Ans. Two ways of creating form in Open Office Base are : a. Create form in design view b. Use Wizard to create form   Q4. Can we enter the data in table using forms? Ans. Yes Q5. What do you mean by Report in Open Office Base? Ans. A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format.   Q6. Differentiate between Forms and Report. Ans. Form 1. It is a way of storing data into a database 2. Values entered in the form can be modified Report ...
Read more

SESSION 3: PERFORM OPERATIONS ON TABLE

  Unit – 3 DBMS SESSION 3: PERFORM OPERATIONS ON TABLE   Q1. 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 datasheet view   Q2. What do you mean by design view? Ans. A view in which we can change the structure of the table is called design view.   Q3. Write steps to open table in design view. Ans. Steps to open table in design view are : Open the Open Office Base Right click on the table which we need to open. Select option Edit from popup menu. Required table will open in design view   Q4. What do you mean by Field Property in Base? Ans. Those properties which determine the characteristics and behavior of fields are called field property.   Q5. Name two properties of Numeric type data. Ans. Two properties of Numeric type data are : Auto Value Length   Q6. Name two properties of Character type ...
Read more