Why we use Semicolon after SQL Statements? ,Java, C ,C++, ASP, ASP.net C# ,Struts ,Questions & Answer, Struts2, Ajax, Hibernate, Swing ,JSP , Servlet, J2EE ,Core Java ,Stping, VC++, HTML, DHTML, JAVASCRIPT, VB ,CSS, interview ,questions, and answers, for,experienced, and fresher
Why we use Semicolon after SQL Statements?

Some database systems are very curious about the its must be semicolon at the end of each SQL statement. Semicolon is the very good way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server. We are always try to using MS Access and SQL Server 2000 and we don\'t have to put a semicolon after each SQL statement, but some database programs force us to use it.

More interview questions and answers

What is Thrashing?

What is the mean of Memory Leaks?

void main() { int i=10, j=2; int *ip= &i, *jp = &j; int k = *ip/*jp; printf("%d",k); }

{ char ch; for(ch=0;ch<=127;ch++) printf("%c %d \n", ch, ch); }

Is this code legal? int *ptr; ptr = (int *) 0x400;

main() { char a[4]="HELLO"; printf("%s",a); }

main() { char a[4]="HELL"; printf("%s",a); }

main() { int a=10,*j; void *k; j=k=&a; j++; k++; printf("\n %u %u ",j,k); }

main() { extern int i; { int i=20; { const volatile unsigned i=30; printf("%d",i); } printf("%d",i); } printf("%d",i); } int i;

What is the The Deque Container?

char *someFun() { char *temp = "string constant"; return temp; } int main() { puts(someFun()); }

char *someFun1() { char temp[ ] = "string"; return temp; } char *someFun2() { char temp[ ] = {"s", "t","r","i","n","g"}; return temp; } int main() { puts(someFun1()); puts(someFun2()); }

What is a pragma?

What are The Multimap Container?

Whats the requirement of Input Itrator?

What is the difference b/n the Heap and the Stack

What is the difference between the Heap and the Stack?

Why n++ executes faster than n+1?

What is the Heap Operations?

What is the difference b/n a linker and linkage?

What is the difference b/n run time binding and compile time binding?

What Is Recursion?

What is the Hash Function?

What is the chaining?

What is an Bucket Addressing?

What is Quadratic Probing?

What is the Parsing? and tell me how many types of Parsing?

What is Parsing Numeric Expressions?

What Is a B-Tree?

What are the differences between Get and post methods in form submitting, give the case where we can use get and we can use post methods?

What is PHP?

Tell more about PHP file?

How PHP is more secure than JavaScript?

What do you understand about MySQL?

Why do we use PHP?

How to install PHP in our system?

What is the Syntax of PHP?

Tell me about basic statements that we used in PHP?

What are the PHP variables?

What are the Limitations of Variable Naming?

How to declare data types in PHP?

What is the use of strlen() and strpos() functions?

Tell me about PHP operator?

Why we use Semicolon after SQL Statements?

How we use if..else and elseif statement in PHP?

Define the Primary key?

What do you mean by Candidate key?

What is the Foriegn Key?

How to use Switch statement in PHP?

What are the use of Null?

What do you understand with array in PHP?

What are the properties of the Relational tables?

What do you understand about Numeric array, Associative array and Multidimensional array?

What is De-Normalization?

What is the mean of Nested Trigger?

What is a Linked Server?

What do you understand about looping in PHP?

What is Cursor?

What is Collation?

What is Difference between Function and Stored Procedure?

What is the Sub-Query?And what is the properties of Sub-Query?

How to use while,do..while,for and foreach loop in PHP?

Give the list how many type of Joine?

Define : What is the Cross Join?

give us a definition of Inner Join?

What do you mean by Outer Join? and define also how many types of Outer Join?

Defeine : Self Join?

What is User Defined Functions?

What kind of User-Defined Functions can be created?

What do you understand functions in PHP?How we create them?

What is Identity?

What is DataWarehousing?

What is the clustered index?

What do you mean by A non clustered index?

How to handle form in PHP?

What are the different index configurations a table can have?

What are different types of Collation Sensitivity?

What is OLTP?

What is form validation?What is Client Side and Server Side validation?

What do you mean by TRUNCATE?

What do you mean by DELETE command?

When is the use of UPDATE_STATISTICS command?

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

What are the properties of SUB-QUERY?

What is the difference between constants and variables in PHP?

What are the type of SUB-QUERy?

What is SQL Profiler?

What is Ant?

What is a build tool?

How many types of build tool you know?

What is different between Ant and Make?

What is History of Ant?

Which version of Java is required to run Ant?

What are the authentication modes in SQL Server? How can it be changed?

Why do you call it Ant?

What is SQL Server Agent?

When we used $_GET and $_POST variable?

How you can Prepare a project in ANT?

Why we use $_REQUEST variable?

From where we can download Ant latest version?

R4R provides free online tutolrails ,examples for Freshers and experts .We cover core java, tutorials, spring, Hibernate, python, struts, struts 2,c language, spring boot,PHP,MYSQL,C#,ASP.NET,WPF,WCF,Photoshop , JSP, programming, example, Interview questions and answer