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

 

Fazal Rehman Shamil Click Here to Know More
Instructor, Researcher, Blogger, SEO Expert, Poet and Publisher of International Journal Of Software, Technology & Science ISSN : 2616 - 5325
Dear Professors and Resarchers!You are welome to Cite these tutorials in your research or slides etc. Please don't forget to mention the reference of website. Copy Paste of text is strcitly forbidden. Images can be reuse because images are protected with watermark.

Leave a Reply

Your email address will not be published. Required fields are marked *