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

1057

what are date and time intervals? : Sql dba

1057

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

1073

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

1044

what is a cursor? : Sql dba

1022

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

1044

what are enums used for in mysql? : Sql dba

1170

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

1079

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

1081

what is a composite primary key ? : Sql dba

1050

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

1019

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

1026

what is not null constraint? : Sql dba

1029

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

1005

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

993

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How does rowid help in running a query faster?

1416

how to write date and time literals? : Sql dba

959

What is 19 null in sql?

959

State some properties of relational databases?

1056

What are instead of triggers?

1044

How do you define a foreign key?

1002

what are the different functions in sorting an array? : Sql dba

1017

List out the acid properties and explain?

949

how to show all tables with 'mysql'? : Sql dba

1118

Is sql a scripting language?

1006

What is a sql select statement?

1039

How do I filter in sql profiler?

993

How to write html code in pl sql?

1114

What is mutating error in pl sql?

1015

What are the disadvantages of not performing database normalization?

1164

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