MCQS Database Systems- for admission in software engineering – Set 9

Multiple Choice Questions

Set 9

 

  • Which key is used to relate two different table
  1. Primary key
  2. Foreign key
  3. Candidate key
  4. Both 1 and 2
    Answer - Click Here:
    2
  • Which type of specific word are used to enter the data in table___
  1. Insert into table name
  2. Save into table name
  3. Enter into table name
  4. Type into table name
    Answer - Click Here:
    1
  • Which is best to make primary key from the following
  1. Roll-no
  2. Phone number
  3. name
  4. both 1 and 2
    Answer - Click Here:
    4
  • Which is not a function in SQL______
  1. MIN
  2. COUNT
  3. SUM
  4. A= R2 
    Answer - Click Here:
    4
  • Which is not allowed in an efficient DBMS______
  1. Duplicate row
  2. Duplicate column
  3. Duplicate data
  4. All 1,2 and 3
    Answer - Click Here:
    4
  • An­__________can be used to automatically fill in certain field values for a new record.
  1. Autolook up query
  2. Select query    
  3. 3.update query
    Answer - Click Here:
    1