MCQS Database Systems- for admission in computer science – Set 7

Multiple Choice Questions

Set 7

  • Which was the first commercial DBMS that support SQL_____
  1. ORACLE
  2. XAmpp
  3. Maya
  4. MS office
    Answer - Click Here:
    1
  • When concepts of relational database technology were articulated_____
  1. 1980
  2. 1970
  3. 1998
  4. 1965
    Answer - Click Here:
    2
  • Which command are consider core command of sql
  1. Data manipulation language
  2. Data definition language
  3. Data reduce language
  4. Data control language
    Answer - Click Here:
    1
  • Which key is must to generate in each table_____
  1. Primary key
  2. Candidate key
  3. Foreign key
  4. Select key
    Answer - Click Here:
    1
  • Which will be best query for deleting row from the table______
  1. DELETE FROM TABLE _NAME WHERE CUSTOMER-STATE=” ”;
  2. DELETE WHERE CUSTOMER-STATE=” ”;
  3. DELETE TABLE _NAME WHERE CUSTOMER-STATE=” ”;
  4. DELETE FROM CUSTOMER WHERE CUSTOMER-=” ”;
    Answer - Click Here:
    4
  • Which will be three clauses to retrieval statement____
  1. Select, from, where
  2. Select, delete, where
  3. Select, insert, where
  4. Select, update, where
    Answer - Click Here:
    1
  • In SELECT query we used * sign what is the purpose of this sign___
  1. To indicate all columns
  2. To indicate all rows
  3. To indicate single row
  4. To indicate single column.
    Answer - Click Here:
    2