7 Find out the output of below commands?
As part of this question we are going to understand the TCL Commands such as rollback and commit.
Please contact us for ETL Testing training: 9886827826
Script:
--CREATE TABLE
create table emp_tcl(id);
--INSERT THE DATA 10 RECORDS
insert all
into emp_tcl values(1)
into emp_tcl values(2)
into emp_tcl values(3)
into emp_tcl values(4)
into emp_tcl values(5)
into emp_tcl values(6)
into emp_tcl values(7)
into emp_tcl values(8)
into emp_tcl values(9)
into emp_tcl values(10)
select * from dual;
--Reverting the changes
rollback;
--delete the data
delete from emp_tcl;
--insert the data
insert all
into emp_tcl values(1)
into emp_tcl values(2)
into emp_tcl values(3)
into emp_tcl values(4)
into emp_tcl values(5)
into emp_tcl values(6)
into emp_tcl values(7)
into emp_tcl values(8)
into emp_tcl values(9)
into emp_tcl values(10)
select * from dual;
commit;
rollback;
#sql #etltesting #interview #etl #job #oracle #rank
#etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql_server #informatica #etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql_server#etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql#ntile #pyhon #etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql #sql_server #postgresql #postgres #dataanalytics #hdfs #sql #development #pyhon #dwh #plsql #db2 #dataengineer #teradata #dataengineer #mssqlserver #msdhoni #msexcel #interview #interviewquestions #views #subquery #inlineview #businessanalystcourse #businessanalyst #sybase #postgres #mssqlserver#etltesting #etl #dwh #sql #like #regularexpressions #oracle #interview #etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql#etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql #unoin #unionafricaine #unionall #dwh #datalake#etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #data #interview #departmentwiselowestsalary#Analyticalfunctions
#union #it #informatica #groupby #operator #operatorsinjava#etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql#Delete#drop#truncate #etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql
#SQLConstraints#Primarykey#uniquekey#etl #etltesting #sql #operator #operatorsinjava #interview #oracle #job #dwh #informatica #it #sql_server #db2 #postgres #postgresql #teradata #mysql #hive #hdfs #data #dataengineeringessentials #dataengineering #dataengineer #dataanalytics #datascience #dataanalysis #odd #evenrecords #dataengineer #java #pyhon#sql
#SQLConstraimnts#Primarykey#foriegnkey#etl testing interview questions and answers #etl interview questions and answers #etl tester #etl testing interview