MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
With SQL, how can you delete the records where the “FirstName” is “Peter” in the Persons Table?
A
DELETE ROW FirstName=’Peter’ FROM Persons
B
DELETE FirstName=’Peter’ FROM Persons
C
DELETE FROM Persons WHERE FirstName = ‘Peter’
D
None of the above
Explanation: 

Detailed explanation-1: -With SQL, how can you delete the records where the “FirstName” is “Peter” in the Persons Table? DELETE FROM Persons WHERE FirstName = ‘Peter’;

Detailed explanation-2: -Expert Answer Hi dear, Answer:-SELECT * FROM Persons WHERE FirstName=’Peter’ AND LastName=’Jackson’ This query selects all the records from a table named “Person…

Detailed explanation-3: -2. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”? Explanation: The SQL LIKE clause is used to compare a value to similar values using wildcard operators. 3.

There is 1 question to complete.