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:
  • When concepts of relational database technology were articulated_____
  1. 1980
  2. 1970
  3. 1998
  4. 1965
    Answer - Click Here:
  • 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:
  • Which key is must to generate in each table_____
  1. Primary key
  2. Candidate key
  3. Foreign key
  4. Select key
    Answer - Click Here:
  • 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:
  • 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:
  • 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:
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