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