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:
  • There are ___________ types of action query.

      1.one                   

      2. Three              

      3.Four 

Answer - Click Here:

  • 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:
  • The _______________deletes a group of records from one table
  1. Delete query
  2. delete action query   
  3. action query
    Answer - Click Here:
  • 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:
  • 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:
  • 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:

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

 

Fazal Rehman Shamil
Welcome to all friends. The reason for our success is only your love for T4Tutorials. Our team is always available to answer your queries regarding any kind of confusions or discussion regarding your study and career matters. For discussion with us please join our facebook group "T4Tutorials.com". The link of the group is mentioned below. Thanks and love to all for connecting with us. We are nothing without you. Love you all.....
https://web.facebook.com/groups/2066136233601097/

Leave a Reply