MCQS Database Systems- for admission in universities – Set 10

By: Prof. Fazal Rehman Shamil
Last modified on September 23rd, 2020

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 

Answer - Click Here:
3

  • 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

Answer - Click Here:
1

  • 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)

Computer Science Repeated MCQs Book Download

Prof. Fazal Rehman Shamil
Latest posts by Prof. Fazal Rehman Shamil (see all)