What is the use of COMMIT in sql ? -Technology

What is the use of COMMIT in sql ? -Technology
by

1 Answer

Answer :

Commit is used to save all the DML transactions, and once saved they cannot be rolled back.
by

Related questions

What is the purpose of SQL? -Technology

Description : What is the purpose of SQL? -Technology

Last Answer : SQL is structured query language. It is a standard language of all the RDBMS.

Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the training. -Technology

Description : Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the training. -Technology

Last Answer : (i)Select count(name) from training where name like ‘Ms.%’;(ii) Select * from training where fee is NULL;(iii) Select city, fee from training where topic = ‘Cyber Security’;(iv) Alter table training add feedback varchar(20);

Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Description : Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Last Answer : Cancelling a transaction means rolls the transaction to the beginning. It aborts any changes made during the transaction and the state of database is returned to what it was before the transaction began to execute.Rollback command is used for the same.

Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Description : Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Last Answer : Create table Books(BOOK_ID Integer (2) Primary Key,BOOK_NAME Varchar (20),CATEGORY Varchar (20),ISSUE_DATE Date);

Write SQL query to create a table “Registration” with the following structure: -Technology

Description : Write SQL query to create a table “Registration” with the following structure: -Technology

Last Answer : Create table Registration(Reg_Id Integer(2) Primary Key,Name varchar(20),Course varchar(10),Join_Dt date);

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

What is the purpose of SQL? -Technology

Description : What is the purpose of SQL? -Technology

Last Answer : SQL is structured query language. It is a standard language of all the RDBMS.

Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Description : Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Last Answer : (i) ASCII () function returns a number.(ii) LCASE () function returns lowercase letters .(iii) DAYNAME () function returns names of days.(iv) DAYOFWEEK () function returns weekday number

Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Description : Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Last Answer : SQL commands for the given statements (i) to (viii) ;1. SELECT FCODE, NAME. PRICE FROM Furniture WHERE PRICE < 5000;2. SELECT NAME. PRICE FROM Furniture3.4. WHERE NAME LIKE %table% ;5. SELECT DISTINCT WCODE ... ;15.16. Output for SQL queries (ix) and (x)(ix)SUM(PRICE)6500(x)COUNT(DISTINCT PRICE)5

Write SQL query to create a table Inventory with the following structure : -Technology

Description : Write SQL query to create a table Inventory with the following structure : -Technology

Last Answer : CREATE TABLE Inventory(Material Id Integer Primary Key,Material Varchar (50) NOT NULL,Category Char,DatePurchase Date) :

To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology

Description : To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology

Last Answer : The correct code is :SELECT ID, Salary FROM empsalaryWHERE Salary = 56000 ;

Write SQL query to create a table Player with the following structure : -Technology

Description : Write SQL query to create a table Player with the following structure : -Technology

Last Answer : CREATE TABLE Player(};

Write SQL Query commands based on the following table: -Technology

Description : Write SQL Query commands based on the following table: -Technology

Last Answer : This answer was deleted by our moderators...

Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Description : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Last Answer : The correct answer is : (a) 50

The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Description : The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Last Answer : The update command can be used to makes changes in the rows of a table in SQL.

Write the SQL command that will display the current time and date. -Technology

Description : Write the SQL command that will display the current time and date. -Technology

Last Answer : Select now();

Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology

Description : Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology

Last Answer : i. select round(8459.2654);ii.select round(8459.2654,-2);

Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Description : Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Last Answer : commands to display:(a)“occupied” (b)“cup”

Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Description : Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Last Answer : (a)select instr 'Preoccupied' , ‘ 'cup'));(b)select left 'Preoccupied',4);

Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Description : Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Last Answer : (i) monthname(date(now()))(ii) trim(“ Panaroma “)(iii) dayname(date(dob))(iv) instr(name, fname)(v) mod(n1,n2)

Can you use a commit statement within a database trigger?

Description : Can you use a commit statement within a database trigger?

Last Answer : No

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Description : Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Last Answer : It is not possible. As triggers are defined for each table, if you use COMMIT of ROLLBACK in a trigger, it affects logical transaction processing.

What’s the best way you can think of to commit all seven deadly sins?

Description : What’s the best way you can think of to commit all seven deadly sins?

Last Answer : drink to excess

Which argument for healthcare policy, Democratic or Republican could have convinced this couple not to commit murder-suicide over worries on treatment costs?

Description : Which argument for healthcare policy, Democratic or Republican could have convinced this couple not to commit murder-suicide over worries on treatment costs?

Last Answer : To take the cynical side of this: Some Republican party supporters - mostly Tea Party and fiscal conservatives, would not have made any effort to prevent these people from commiting murder-suicide. Their rationale: ... come up to address these dead peoples' needs,, I wouldn't trust it for a second.

If Epstein was on suicide watch, how did he manage to commit suicide?

Description : If Epstein was on suicide watch, how did he manage to commit suicide?

Last Answer : I am convinced that this is one of these “He shot himself in the head. From behind. With his hands tied behind his back. From a 10m distance. How tragic.” situations. He was murdered, to tie up loose ends.

What would make you tell someone it's better for him or her to commit suicide?

Description : What would make you tell someone it's better for him or her to commit suicide?

Last Answer : I think that borders on conspiracy to commit murder.

Do animals agree to commit euthanasia, when they are taken as pets?

Description : Do animals agree to commit euthanasia, when they are taken as pets?

Last Answer : My dog is pretty tight lipped about the subject.

Why do people shame a person who wants to commit suicide when they have not gone through what he has?

Description : Why do people shame a person who wants to commit suicide when they have not gone through what he has?

Last Answer : Because it’s cheaper than a universal health care program that includes mental health.

If you own a super car, or a hyper fast muscle car does it mean you are eventually going to commit major traffic crimes?

Description : If you own a super car, or a hyper fast muscle car does it mean you are eventually going to commit major traffic crimes?

Last Answer : You're Canadian, so I'm going to spoon-feed this to you. Cars can only be driven when registered, insured, and piloted by a licensed, demonstrably competent individual. The right to pilot a ... of the American population is vehemently against, and the reason why those things don't exist here.

If someone has split personality and threatens that he or she will commit suicide, can it be considered as holding hostages?

Description : If someone has split personality and threatens that he or she will commit suicide, can it be considered as holding hostages?

Last Answer : No, I highly doubt it, because split personalities or not, it’s still only one person.

Have you ever had a customer you wanted to verbally abuse of commit acts of violence against?

Description : Have you ever had a customer you wanted to verbally abuse of commit acts of violence against?

Last Answer : answer:What people who deal with customers need to understand is the cost of re-acquiring a lost customer is prohibitively expensive while keeping a customer happy costs relatively little. Businesses sometime ... who are on the front lines with customers and by not having policies that support that.

Inspired by a movie I watched: If you were falsely convicted of a crime and done the time, should you, upon release, have the right to commit the crime you were falsely convicted for, without being punished?

Description : Inspired by a movie I watched: If you were falsely convicted of a crime and done the time, should you, upon release, have the right to commit the crime you were falsely convicted for, without being punished?

Last Answer : answer:Well, and just how's that gonna work for you? If you are the only one that knows, in their heart, you were truly innocent and the legal system disagreed, well .all you'd gain is a repeat ... , much better to swallow your bitter pill and move on. Unless you've come to enjoy prison life. lol

How should we talk to those who are having thoughts about and have made attempts to commit suicide?

Description : How should we talk to those who are having thoughts about and have made attempts to commit suicide?

Last Answer : Frankly, I always refer them to a mental illness suicide line or depression line because they are trained on how to deal with these things as a profession.

Could you commit murder?

Description : Could you commit murder?

Last Answer : answer:I could not. I’ve thought about it, and could not get past the theoretical level. I could plan. I could not execute. Knowing I could not execute, I wouldn’t bother to plan. There are other ways to solve problems, so it’s hard to imagine a situation where murder would make sense.

Why do teens commit suicide when they only have 4 years of high school?

Description : Why do teens commit suicide when they only have 4 years of high school?

Last Answer : I didn't realize until I was out of HS that I didn't have to be bound to the label that had been placed on me by the HS crowd. I'm sure that many HS students feel the same way ... people get stuck with I can imagine it would feel pretty hopeless, especially if it's coupled with mental illness.

Do you think that a person who lies to convict a person of a crime they did not commit should spend time in prison themselves?

Description : Do you think that a person who lies to convict a person of a crime they did not commit should spend time in prison themselves?

Last Answer : Abso-freaking-lutely. They should get the same amount of time as well. That person’s life was ruined because of them.

If you were the Judge and the Jury, and it were totally up to your judgement and opinion, what would be the punishment for the kid whose webcam spying caused his roommate Tyler Clemente to commit suicide?

Description : If you were the Judge and the Jury, and it were totally up to your judgement and opinion, what would be the punishment for the kid whose webcam spying caused his roommate Tyler Clemente to commit suicide?

Last Answer : He's 18? And he caused another person's death because of his thoughtless douchebaggery? Hmmmm. I'd likely sentence him to a long prison sentence. That other boy is dead because of him; that' ... prison sentence. With a gay cellmate nicknamed Shirley who gets really lonely in the middle of the night.

What are 100 reasons not to commit suicide?

Description : What are 100 reasons not to commit suicide?

Last Answer : 2. I want to see what tomorrow brings.

Could sibling rivalry lead a 14 year old to commit suicide?

Description : Could sibling rivalry lead a 14 year old to commit suicide?

Last Answer : How can any of us, not knowing the details and the child himself, dare to speculate?

What can we do when a large group of people commit a crime?

Description : What can we do when a large group of people commit a crime?

Last Answer : Um… build a large jail? : )

Do people who commit suicide imagine that they are about to enter an improved version of life?

Description : Do people who commit suicide imagine that they are about to enter an improved version of life?

Last Answer : It’s about the deep desire to end their suffering.

Did Kurt Cobain really commit suicide?

Description : Did Kurt Cobain really commit suicide?

Last Answer : First off I just have to say that I love Kurt Cobain. ♥ But I honestly think he committed suicide. I have heard from differen’t places that he might have been murdered. But I do not believe so.

Would you ever confess to a crime you did not commit?

Description : Would you ever confess to a crime you did not commit?

Last Answer : Nope

Can fishes commit suicide?

Description : Can fishes commit suicide?

Last Answer : Some fish jump. I’ve had fish jump out of the pond to their death. It happens and it’s not abnormal.

What do you believe is the best punishment for people who commit sexual crimes against children?

Description : What do you believe is the best punishment for people who commit sexual crimes against children?

Last Answer : Lifetime jail or just be executed.

Do you think the human species could be trying to commit suicide?

Description : Do you think the human species could be trying to commit suicide?

Last Answer : I don’t think that we’re trying to commit suicide, at least, in this moment – I just think that some of us are too lazy to realize what is happening and are unwilling to take the necessary steps to make changes.

Why commit suicide ?

Description : Why commit suicide ?

Last Answer : answer:Suicide is a personal decision . There are a lot of justifiable reasons to commit suicide ...just not justifiable to everyone. Remember we live in a culture where everyone must live no matter what ... do is talk to a therapist about this ..he can answer your questions better then Fluther .

Which of the seven deadly sins is the worst to commit in your eyes?

Description : Which of the seven deadly sins is the worst to commit in your eyes?

Last Answer : answer:It’s a tie for me between gluttony and greed. Both mandate that you take when it is unnecessary, and probably from someone that should have. The rest will mostly just make you kind of tacky.

Do you commit yourself to too much throughout the week? If you cut back, how has it affected your life?

Description : Do you commit yourself to too much throughout the week? If you cut back, how has it affected your life?

Last Answer : answer:This is irrelevant but I think Lisa is asleep so it might not get deleted right away. But my STFU script snagged your score. :-)

Should I commit to 5 days on the Appalachian trail?

Description : Should I commit to 5 days on the Appalachian trail?

Last Answer : Read A Walk in the Woods by Bill Bryson. It gives you a humorous and accurate view of this very thing.