Important QnA table operations in Base Class 10

If you are looking for study material for class 10, you are on the right place here, in this article you will get QnA table operations in Base Class 10. So let’s start!

Important QnA table operations in Base Class 10

First we will start Important QnA table operations in Base Class 10 with objective types questions carries 1 mark each. This section contains fill in the blanks, MCQs, one word answer questions, and True/False. So let’s begin!

Objective type questions

1. A ____________ view allows you to type records directly in table. (Ans. Datasheet)
2. In the _________ view you have to type the command with proper syntax. (Ans. SQL)
3. You can open the table datasheet through ______________ (Ans. double click)
4. You cannot insert record in between the table using datasheet view. (True/False)
5. To open SQL view, click on _____________>____________ option. (Ans. Tools, SQL)
6. The ______________ command is used to insert record using SQL view. (Ans. Insert)
7. Click on ________>_________ option to edit records in the table. (Ans. Edit,Edit Data)
8. Which of the following icon is available on the toolbar to edit records in OO Base?
   1. Update
   2. Edit
   3. Modify
   4. Alter
9. Which of the following command is used to edit records through SQL View?
   1. Update
   2. Edit
   3. Modify
   4. Alter
10. The Delete Record option is present in OO Base in which of the following menu?
    1. File
    2. Tools
    3. Insert
    4. Edit
11. When you select the Delete record option, the record will be deleted without any confirmation in the OO base. (True/False)
12. Which of the following command is used to delete records using SQL view?
    1. Remove
    2. Drop
    3. Delete
    4. Erase
13. Which of the following Yes/No type properties change the value of a field without typing the value in the cell?
    1. Default Value
    2. Entry Required
    3. Auto Value
    4. Format Example
14. The default value properties insert a pre-defined value when the user left the cell blank. (True/False)
15. Which of the following properties restrict the total number of characters in the field?
    1. Length
    2. Entry Required
    3. Auto Value
    4. Format Example

Now in the nest section of Important QnA table operations in Base Class 10, we will provide you the subjective type questions.

Subjective Type Questions

For answer follow this link:

1. What are the ways of inserting records in OO Base? Enlist them.
2. How to insert a record using datasheet view? Explain with an example.
3. Write SQL command to insert a student record in a student table. The fields are rollno, name, birthplace, contactno, and previousschool.
4. Write all the steps to execute the command through SQL view.
5. How to refresh the table? Write the complete procedure.
6. Write steps to edit records using datasheet view with example.
7. Write SQL command to update the record: Change the contactno of rollno 5.
8. Write steps to delete a record from the table with an example.
9. Write SQL command to delete the record: whose birthplace is Ahmedabad.
10. Explain all the common field properties of a table provided by OO Base.
11. How to sort the records? Write compelte steps.

That’s all from the Important QnA table operations in Base Class 10. I hope you it will help you to understand the concept.

Hit the like button and share this Important QnA table operations in Base Class 10 with your friends. Feel free to ask your doubts or queries in the comment section.

If you have anything for us reflect through your comments in the comment section. It will help us to understand your need and we will provide you more better and better contents for the subject.

Thank you very much for visiting our blog. Keep visiting, keep learning.

TADA!!!

If you are looking for more contents of IT 402, follow this link and enjoy.