Great News!
Many students who study using our platform have reported that a large number of the practice questions here are very similar to those that appear in real exams. View Courses
Many students who study using our platform have reported that a large number of the practice questions here are very similar to those that appear in real exams. View Courses
Which SQL statement is used to modify existing data in a relational database table?
The Correct Answer is: B. UPDATE
The UPDATE statement is used in SQL to modify existing data within a table. It allows you to change the value of one or more columns in rows that meet specific conditions. For example, you can update an employee’s salary or change a customer’s email address.
Why the other options are incorrect:
A. SELECT
This statement is used to retrieve data from a database. It reads data but does not change it.
C. CREATE
The CREATE statement is used to define new database objects, such as tables or indexes. It is not used to alter existing data.
D. INSERT
INSERT is used to add new rows of data to a table, not to change data that is already stored.
Discover a range of courses designed to provide you with the knowledge and skills needed to excel in your chosen field.
You don’t need one month to study and pass your test.
With Prepsaret, it takes you a few days to grasp all the concepts needed to pass your exams