MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Complete the following SQL query to find all records for surname = “Khan":SELECT * FROM Customers ____
A
surname = “Khan”
B
WHERE surname = “Khan”
C
AND surname = “Khan”
D
WHEN surname = “Khan"
Explanation: 

Detailed explanation-1: -Khan (/xɑːn/) is a surname of Turko-Mongol origin, commonly found in parts of India, Pakistan, Afghanistan, Bangladesh and Iran.

Detailed explanation-2: -It is hard to believe that surnames – Peer, Wali or Khan, are common Hindu surnames. At the same time a Muslim carrying his last name as Rishi or Pandit…… sounds incredible, but it is a common feature in Kashmir. Unlike in other parts of the country, Muslims and Hindus have been sharing the same surnames since ages.

Detailed explanation-3: -Thanks to this ancient name, baby is sure to be a force to be reckoned with. Khan, which is more popular as a surname, is a Turkish boy’s name meaning “prince, ” so get ready to give your son the royal treatment. Khan is a shorter form of Khagan, and was originally a historic title given to military chiefs and rulers.

Detailed explanation-4: -The upper caste Muslim castes include Pathan, Muslim Rajput, Turk, Sheikh, Khan, Syed, Rizvi, biradri, and Malik.

There is 1 question to complete.