CLASS IX PRACTICE QUESTION M S EXCEL

-

 






Comments

Post a Comment

Popular posts from this blog

CHAPTER 4 RAISING QUERIES CLASS 8 COMPUTER

-
CLASS 8 CHAPTER 4 RAISING QUERIES A. Fill in the blanks with the help of the given words. 1. Connecting tables in a database is the concept of relational database. 2. A foreign key is the primary key of another table which creates a link between two tables based on a common column. 3. If you modify the primary key value, Cascade update related fields  allows you to update all the related foreign key values. 4. A query   allows you to pull information from one or more tables based on a set of defined search conditions. 5. The query design view allows you to customise the query.     B. Tick the correct answer. 1. Which of the following options allows you to delete the related records from the foreign key table, if you delete records from the primary key table? ANS B. Cascade delete related records 2. Which option in Edit Relationships dialog box prevents you from entering a value in the foreign key field? ANS B. Enforce referential integrity 3. Press.......... to...
Read more