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

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

1 Answer

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.
by

Related questions

Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Description : Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Last Answer : ALTERUPDATEIt s a DDL command.It s a DML command.It can be used for the following purpose:To add a new column.To remove an existing column.To modify a column.To add/remove a constraint.It s ... Delhi ;suitable command:(i)Show Databases(ii) Use City(iii) Drop Database Clients(iv) Drop table Club

Ms. Sita trying to log into your Internet Banking account for online transaction activity. However, as strange as it may seem, -Technology

Description : Ms. Sita trying to log into your Internet Banking account for online transaction activity. However, as strange as it may seem, -Technology

Last Answer : I. (i)Source code is available.(ii) Money need not to be paid for procuring the license for usage and further distribution.II. She could be under a DoS attack!She should deploy an ... into her network if not already done. This helps in restricting the bandwidth usage to authenticated users only.

Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology

Description : Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology

Last Answer : (i) Where clause is used to show data set for a table based on a condition and having clause is used to put condition on the result set that comes after using Group by clause.(ii) COUNT ... unique as single column or combined multiple columns to the table. They are all candidates for Primary Key.

Ms Samtha has many electronics gadgets which are not usable due to outdated hardware and software. Help her to find any three best ways -Technology

Description : Ms Samtha has many electronics gadgets which are not usable due to outdated hardware and software. Help her to find any three best ways -Technology

Last Answer : 1. Give Your Electronic Waste to a Certified E-Waste Recycler2. Donating Your Outdated Technology3. Give Back to Your Electronic Companies and Drop Off Points.

Ms. Cathy is creating a form for Vidya University Sports Council application. Help her to choose the most appropriate controls -Technology

Description : Ms. Cathy is creating a form for Vidya University Sports Council application. Help her to choose the most appropriate controls -Technology

Last Answer : Appropriate controls for the given entries :S.NOFunctionControl1.To let the user enter NameTextField2.To let the user enter MOBILE NUMBERTextField3.To let the user choose one PROFESSION out of the ... , Yoga, Table Tennis, Badminton and Aerobics. More than one facility may be chosen.CheckBox

How do noise cancelling headphones work and to what extent?

Description : How do noise cancelling headphones work and to what extent?

Last Answer : There are technically two types of noise canceling headphones. The first are pretty normal, simply insulating your ear to the point of isolation. The second type is more advanced; they put out ambient and ... I think there is a good chance that you couldn't hear a thing with the second type.

Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. -Technology

Description : Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. -Technology

Last Answer : Software name:Team Viewer

Mention any one major environmental benefits of ICT to Ms. Megha so that she can utilize it in her future “Save Earth” campaign. -Technology

Description : Mention any one major environmental benefits of ICT to Ms. Megha so that she can utilize it in her future “Save Earth” campaign. -Technology

Last Answer : Major environmental impact of ICT on our society is that it is creating a virtually paperless work environment so reducing cutting down of trees for paper manufacturing.

Ms. Achla, works as a Programmer in a survey firm named “National Survey Foundation”. In her current project, she is supposed to design -Technology

Description : Ms. Achla, works as a Programmer in a survey firm named “National Survey Foundation”. In her current project, she is supposed to design -Technology

Last Answer : S. No.Control used to inputControl1TRAINEE’S NAMETextField2TRAINING LOCATIONRadio Button/Combo Box3GRADE THE SESSION(Excellent, Good, Satisfactory, Unsatisfactory)Radio Button/Combo Box4SUGGESTIONSText Area

Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. -Technology

Description : Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. -Technology

Last Answer : Team Viewer

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);

In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMAC.CREATE CLUSTERD.All of theaboveE.None of the above;

Description : In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMA C. CREATE CLUSTER D. All of theabove E. None of the above;

Last Answer : CREATE SCHEMA

Anju, a beginner in java programming has written following code with some mistakes: -Technology

Description : Anju, a beginner in java programming has written following code with some mistakes: -Technology

Last Answer : int k=0;String s='Save Earth';int l=s.length();for(int i=0;k

Who is called 'Udan Pari'? -General Knowledge

Description : Who is called 'Udan Pari'? -General Knowledge

Last Answer : answer:

Which of the following pari of metals is purified by VanArkel method

Description : Which of the following pari of metals is purified by VanArkel method

Last Answer : Which of the following pari of metals is purified by VanArkel method A. Ga and In B. Zr and Ti C. Ag and Au D. Ni and Fe

Sino sa dalawang pari ang nararapat na maupo sa kabiserapangatiranan?

Description : Sino sa dalawang pari ang nararapat na maupo sa kabiserapangatiranan?

Last Answer : Feel Free to Answer

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);

Why can I not install MS SQL Server Express 2008 R2?

Description : Why can I not install MS SQL Server Express 2008 R2?

Last Answer : Please provide details on what and how it fails the precheck.

MS-SQL stores data in a ........................ file format. A) .DAT B) .MDB C) .MSSQL D) .OBJ

Description : MS-SQL stores data in a ........................ file format. A) .DAT B) .MDB C) .MSSQL D) .OBJ

Last Answer : A) .DAT

Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Description : Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Last Answer : PL/SQL

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.

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 use of COMMIT in sql ? -Technology

Description : What is the use of COMMIT in sql ? -Technology

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

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”

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)

I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Description : I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Last Answer : answer:PL\SQL really isn’t my thing, but I believe you need something between the first IF statement and the ELSIF. What do you want it to do with the number if it is 50 or 90?

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology

Last Answer : (i)Acc_No, Cust_Phone(ii)All the columns having capability to become Primary Key are known as Candidate Keys.(iii)Acc_No(iv)Trans_Id

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

How do you tell the system that a transaction is beginning -Technology

Description : How do you tell the system that a transaction is beginning -Technology

Last Answer : When a transaction begins, Oracle Database assigns the transaction to an available undo data segment to record the undo entities for the new transaction. A transaction ID is not allocated until an ... ID is unique to a transaction and represents the undo segment number, slot and sequence number.

Write a query to display customer’s name along with their transaction details. -Technology

Description : Write a query to display customer’s name along with their transaction details. -Technology

Last Answer : Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;

Write a query to display customer’s name who have not done any transaction yet. -Technology

Description : Write a query to display customer’s name who have not done any transaction yet. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No!=t.Acc_No;

Select Acc_No, sum(Amount) from Customer c, Transaction t where c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type='Credit'; -Technology

Description : Select Acc_No, sum(Amount) from Customer c, Transaction t where c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type='Credit'; -Technology

Last Answer : 2301003 650002201002 20000

Understand Computer Hardware for SQL Training?

Description : Understand Computer Hardware for SQL Training?

Last Answer : A good knowledge of basic computer hardware will prepare you to understand the mechanics of computers and servers that are essential for data processing. Take as many hardware courses as ... and temporary memory requirements. This technology is constantly improving and will shape SQL software.

Sally has four classes, Science, Math, English Language Arts, and History. She had a test in every class, and wanted to have some fun, so she did all of her tests in French. When she received her tests back, only one teacher could understand her work. If none of Sally's teachers spoke French, which teacher was able to understand the test and how did they understand it? -Riddles

Description : Sally has four classes, Science, Math, English Language Arts, and History. She had a test in every class, and wanted to have some fun, so she did all of her tests in French. When she ... teachers spoke French, which teacher was able to understand the test and how did they understand it? -Riddles

Last Answer : The Math teacher, because numbers are the same in French as they are in English.

(i) Ms. Sangeeta wants to add few descriptive lines in the HTML code which should not be displayed on the webpage rather -Technology

Description : (i) Ms. Sangeeta wants to add few descriptive lines in the HTML code which should not be displayed on the webpage rather -Technology

Last Answer : (i) She should use comments in HTML.Any text to make comments in HTML, should be preceded by Example:Welcome(ii)HTML is used to display data and to focus on formatting of data, whereas XML ... XML is used to store and transfer the data over different platforms while HTML is used to design webpages.

Ms. Neelam works as a programmer in “Kidz Entertainment Zone”. She has designed a Registration Page to calculate -Technology

Description : Ms. Neelam works as a programmer in “Kidz Entertainment Zone”. She has designed a Registration Page to calculate -Technology

Last Answer : (i)int age=Integer.parseInt(jTextField2.getText());if(age>=3 && age1000)disc=fee*20/100;jTextField4.setText(''+(disc));(iv)int fee=Integer.parseInt(jTextField3.getText());int disc=Integer.parseInt(jTextField4.getText());jTextField5.setText(''+(fee-disc));

Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary. -Technology

Description : Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary. -Technology

Last Answer : SQL command to add a primary key column:Alter table employee add empid int primary key;Importance of Primary key in a table:Primary key column is used to uniquely identify each record of the table. A column defined as primary key cannot have a duplicate entry and can't be left blank.