Answer: Macintosh start January 24, 1984
Windows start November 20, 1985
Linux start October 5, 1991
The format for the UPDATE command is the word UPDATE, followed by the name of the table to be updated. The next portion of the command consists of the word <u>SET</u>, followed by the name of the column to be updated, an equals sign, and the new value.
Explanation:
- An Update Query is an action query (SQL statement) that changes a set of records according to criteria you specify.
- The SQL UPDATE Query is used to modify the existing records in a table. You can use the WHERE clause with the UPDATE query to update the selected rows, otherwise all the rows would be affected.
- Update Queries let you modify the values of a field or fields in a table.
<u>UPDATE Syntax
</u>
- UPDATE table_name
- SET column1 = value1, column2 = value2, ...
- WHERE condition;
UPDATE table_name SET column1 = value1, column2 = value2, etc WHERE condition;
- table_name: name of the table
- column1: name of first , second, third column....
- value1: new value for first, second, third column....
- condition: condition to select the rows for which the
- values of columns needs to be updated.
Answer:
A - 2
B - 3
C - 5
D - 4
E - 1
Explanation:
A. Virtual private network : 2
This is very useful when you have to work from home or visiting a client and need access to files/applications just like if you were at the office.
B. Email : 3
Yes, this is basically why the Internet was created in the first place.
C. Social networking sites : 5
Social networks are indeed a great marketing tool, allowing to target potential customers very precisely.
D. Search engines : 4
Yes, to find information about new products for the company, how the competitors are doing and so on.
E. Video and web conferencing: 1
Another great tool for employees working from home for example, or for employees located in an office at the other side of the country.
Answer:
Data manipulation languages are used for the retrieval of the,insertion,deletion and modification of data.
Explanation:
Data Manipulation Languages(DML) are used to insert,delete,update,modify the data in the database.
The commands used to do these operations are as following:-
INSERT INTO :-This command is used to insert values in the database.
DELETE:-It is used to delete existing records from the table.
UPDATE:- It is used to modify the records in the table.
SELECT:- It is used to select data from database.
