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;
A source file has source code, what a human understands. It isn't compiled or linked.
An object file has compiled, but not linked intermediary code.
An executable file has compiled and linked code which is executable.
Answer: Program for bit stuffing in C
#include<stdio.h>
int main()
{
int i=0,count=0;
char data[50];
printf("Enter the Bits: ");
scanf("%s",data); //entering the bits ie. 0,1
printf("Data Bits Before Bit Stuffing:%s",databits);
printf("\nData Bits After Bit stuffing :");
for(i=0; i<strlen(data); i++)
{
if(data[i]=='1')
count++;
else
count=0;
printf("%c",data[i]);
if(count==4)
{
printf("0");
count=0;
}
}
return 0;
}
Explanation:
bit stuffing is the insertion of non-information bits during transmission of frames between sender and receiver. In the above program we are stuffing 0 bit after 4 consecutive 1's. So to count the number of 1's we have used a count variable. We have used a char array to store the data bits . We use a for loop to iterate through the data bits to stuff a 0 after 4 consecutive 1's.
Answer:
Statement:
print("first is "+str(first)+" second = "+str(second)) # It is a python statement where first and second are variable of any type.
Explanation:
- The above statement is the print statement that prints the value of first and second variables like in the form of "first is" value of the first variable, then space, then "second = b" and then the value of the second variable.
- The value for the first and the second variable of any type but it convert it into string form with the help of str() function in the print statement.
- The string of the print statement can be formed by the help '+' operator which adds the string with the value and the other string in print statement in java and python language.
The statement above is false; the motion of electrons can not be predicted precisely. Electrons move around the orbit shells at different energy levels in atoms. Previous research works had devised ways of measuring the angular velocity of electrons and means of tracking the movement of electrons in atoms but the movement of these electrons can not be predicted. They move in a random manner round the nucleus of an atom.<span />
