You are usually editing a word document when you are finished typing up and assignment or what not, then highlighting what you want to edit will tell the computer/word document what and where your making your edits.
Answer:
The Update statement in the DML is used for changing existing data in a table.
Explanation:
Their are following Sql statement in the DML.
Insert
This SQL statement is used for inserting data into the table.
select
This SQL statement is used for retrieving data from database
update
This SQL statement is used for updating data in a table.
delete
This SQL statement is used for delete data from database .
The "UPDATE" SQL statement in DML is used for Modify the data in the existing table .
Following are the syntax of Update SQL query
Update tablename
set column1=value1,column2=value2............column N=valueN
Where condition;
Example :Suppose we have student table and (rollno,name,age and add) are the field for that table we have to change the address of rollno 105
Then we use update query like that
UPDATE STUDENT
SET add='kalam nagar'
where rollno=105;
1. The opportunity to create several equations for launching program files is called
a) creating a file
b) creating a folder
✒ <u>c) creating a directory</u>
d) creating a shortcut
2. Unless you specify otherwise most spreadsheet packages assume all cell addresses are
a) macros
b) relative cell reference
c) absolute cell reference
✒<u> d) mix cell references</u>
3. Which of the following is not a type of lcon
a) program icon
✒ <u>b) document icon </u>
c) folder icon
d) utility icon
Input
Output
(Sorry for not being detailed)
