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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

what is unique key constraint? : Sql dba

991

describe mysql connection using mysql binary. : Sql dba

993

what is a materialized view? : Sql dba

996

describe transaction-safe table types in mysql : sql dba

944

how to add a new column to an existing table in mysql? : Sql dba

1001

what is the difference between union and union all? : Sql dba

974

what are string data types? : Sql dba

972

what is blob? : Sql dba

1055

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

916

what is a foreign key ? : Sql dba

1026

explain the difference between delete , truncate and drop commands? : Sql dba

1015

what is a relationship and what are they? : Sql dba

1025

what is data integrity? : Sql dba

985

what is the command used to fetch first 5 characters of the string? : Sql dba

1584

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

994

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how to get a list of indexes of an existing table? : Sql dba

914

What are the parts of a basic sql query?

918

Is left join inner or outer by default?

973

how do you know if your mysql server is alive? : Sql dba

1024

What is meant by truncate in sql?

1003

What is the maximum database size for sql express?

959

What is rtm in testing?

1038

What are some emotional triggers?

928

What is rownum?

923

How to fix oracle error ora-00942: table or view does not exist

955

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4095

How does index help in query performance?

967

What is a full join?

911

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

989

how can we know the number of days between two given dates using mysql? : Sql dba

991

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