SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1051

what are date and time intervals? : Sql dba

1053

what is the difference between a local and a global temporary table? : Sql dba

1062

how to drop an existing table in mysql? : Sql dba

1038

what is a cursor? : Sql dba

1019

what is the difference between char_length and length? : Sql dba

1037

what are enums used for in mysql? : Sql dba

1165

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1068

what is the difference between a web-garden and a web-farm? : Sql dba

1077

what is a composite primary key ? : Sql dba

1044

what is the difference between blob and text? : Sql dba

1008

how to get @@error and @@rowcount at the same time? : Sql dba

1018

what is not null constraint? : Sql dba

1023

how to delete an existing column in a table? : Sql dba

1003

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

988

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How many subqueries can be nested in a statement?

979

How is use pl and sql?

1055

what are the types of join and explain each? : Sql dba

1032

What is a nested table in word?

952

What is sql and its types?

1174

Can we use ddl statements in stored procedure sql server?

1006

Which are the different case manipulation functions in sql?

1016

What are sql indexes?

992

What are the disadvantages of not performing database normalization?

1153

Is pl sql different from sql?

985

What is a unique constraint?

1065

What is procedure and function in sql?

992

What is the difference between the conventional and direct path loader? : aql loader

1149

Explain how can you save or place your msg in a table?

1026

what is uncommittable transactions? : Transact sql

993

For More Un-Answered { SQL PLSQL } Questions Click Here