Question

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

a.

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

b.

MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

c.

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

d.

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Posted under SQL Server

Answer: (d).UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

Add Comment

Similar Questions

Discover Related MCQs

Q. Which TCL command undo all the updates performed by the SQL in the transaction?

View solution

Q. SQL query to find all the cities whose humidity is 95.

View solution

Q. SQL query to find the temperature in increasing order of all cities.

View solution

Q. What is the meaning of LIKE ‘%0%0%’?

View solution

Q. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

View solution

Q. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

View solution

Q. Find all the tuples having a temperature greater than ‘Paris’.

View solution

Q. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

View solution

Q. The command to remove rows from a table ‘CUSTOMER’ is __________________

View solution

Q. Which is not a type of join in T-SQL?

View solution

Q. Which of the following is not a limitation of view?

View solution

Q. SQL Server has mainly how many types of views?

View solution

Q. Dynamic Management View is a type of ___________

View solution

Q. Syntax for creating views is __________

View solution

Q. You can delete a view with ___________ command.

View solution

Q. What is SCHEMABINDING a VIEW?

View solution

Q. Which of the following is not a SQL Server INFORMATION_SCHEMA view?

View solution

Q. ___________ is stored only in the Master database.

View solution

Q. If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression.

View solution

Q. All aggregate functions except __________ ignore null values in their input collection.

View solution

View All MCQs on SQL Server

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...