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

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