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?
|
|
DELETE ROW FirstName=’Peter’ FROM Persons
|
|
|
DELETE FirstName=’Peter’ FROM Persons
|
|
|
DELETE FROM Persons WHERE FirstName = ‘Peter’
|
|
|
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.