Class 10 Unit 3 SESSION2:CREATE AND EDIT TABLES USING WIZARD & SQL COMMANDS IMPORTANT Questions(ASSESSMENT)

Class 10 Unit 3 SESSION2:CREATE AND EDIT TABLES USING WIZARD & SQL COMMANDS IMPORTANT Questions(ASSESSMENT)

Class 10 Unit 3 SESSION2:CREATE AND EDIT TABLES USING WIZARD & SQL COMMANDS IMPORTANT Questions(ASSESSMENT)

Fill in the blanks:

1. A table is a set of data elements that is organized using a model of vertical _______ and horizontal _________.

Answer: Columns, Rows

2. A ________ is a set of data values of a particular type, one for each row of the table.

Answer: Column

3. A ________ represents a single, data item in a table.

Answer: Row

4. _____ are used to identify which type of data we are going to store in the database.

Answer: Data Types

5. There are __ ways to create a table.

Answer: 2

6. Field properties can be set in both the and ______ .

Answer: Design View , Wizard

Short Answer Questions:

Question 1.In how many ways tables can be created in Base?

Answer: Tables can be created in two ways:

1. Design View
2. Wizard

Question 2. Why are data types used in DBMS /RDBMS?

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

Question 3. List datatypes available in Numeric Datatype?

Answer:

1 BOOLEAN

2. TINYINT

3. SMALLINT

4. INTEGER

5. BIGINT

6. NUMERIC

7. DECIMAL

8.REAL

9. FLOAT

10. DOUBLE

Question 4. List datatypes available in Alphanumeric Datatype?

Answer:

1. LONGVARCHAR
2. CHAR
3. VARCHAR
4. VARCHAR_IGNORE CASE

Question 5. Define the structure of a table.

Answer: A table is a set of data elements that is organized using a model of vertical columns and horizontal rows. A table has a defined number of columns, but can have any number of rows.

Question 6. Differentiate between Tuples and Attributes of a table.

Answer: A column is a set of data values of a particular simple type, one for each row of the table. A row also called a Record or Tuple represents a single, data item in a table.

Question 7. Name different Binary data types.

Answer:

1. LONGVARBINARY
2. BINARY
3. VARBINARY