MCQS Database Systems- for admission in universities – Set 10

Multiple Choice Questions

Set 10

• If we require a large number of similar changes, we can save time by using an ____________.

1. Action query
2. update query   
3. delete query
   Answer - Click Here:

   1

• There are ___________ types of action query.

      1.one                   

      2. Three              

      3.Four 

• The ________________creates a new table from all or part of the data in one or

         more tables.

1. make-table
2. action query
3. Append query            
4. cross-table query
   Answer - Click Here:

   4

• The _______________deletes a group of records from one table

1. Delete query
2. delete action query   
3. action query
   Answer - Click Here:

   1

• An _______________makes global changes to a group of records in one or more tables.

1. Make-table action query
2. action query    
3. update action query
   Answer - Click Here:

   3

• We use an _____________to insert records from one or more source tables into a single target table.

1. append action query
2. update action query
3. 3.action query
   Answer - Click Here:

   2

• The _______________can be used to find records in one table that do not have related records in another table.

     1, Find Unmatched Query Wizard

     2. Action query            

     3. Update query

• The _________________can be used to determine if there are duplicate records in a table or determine which records in a table share the same value.

1. Find Duplicates Query Wizard
2. Matched query        
3. Action query
   Answer - Click Here:

   1

4. More MCQs Of Database Systems

   1. SET 1: database design mcqs (database design mcqs )
   2. SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
   3. SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
   4. SET 4: database systems mcqs (database systems mcqs)
   5. SET 5: dbms mcqs (dbms mcqs )
   6. SET 6: dbms mcqs with answers (dbms mcqs with answers)
   7. SET 7: solved mcqs of dbms (solved mcqs of dbms)
   8. SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
   9. SET 9: relational database management system mcqs(relational database management system mcqs)
   10. SET 10: solved mcqs of database management system(solved mcqs of database management system)
   11. SET 11: basic database mcqs pdf (basic database mcqs pdf)
   12. SET 12: relational database management system mcqs (relational database management system mcqs )
   13. SET 13: database mcqs online test (database mcqs online test)
   14. SET 14: database interview questions mcqs (database interview questions mcqs)
   15. SET 15: database developer mcqs (database developer mcqs)
   16. SET 16: database Repeated mcqs (database Repeated mcqs)
   17. SET 17: Database mcqs PPSC (Database mcqs PPSC)
   18. SET 18: Database mcqs FPSC (Database mcqs FPSC)
   19. SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)