SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is unique key constraint? : Sql dba

799

describe mysql connection using mysql binary. : Sql dba

796

what is a materialized view? : Sql dba

797

describe transaction-safe table types in mysql : sql dba

739

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

824

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

771

what are string data types? : Sql dba

751

what is blob? : Sql dba

787

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

766

what is a foreign key ? : Sql dba

835

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

796

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

792

what is data integrity? : Sql dba

820

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

1409

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

833


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are the different dml commands in sql?

813


What are analytical functions in sql?

777


Which one is better sql or oracle?

736


What is varchar sql?

850


How do you run a query?

807


How to rename a table?

801


What is a heap in sql?

765


What is benefit of creating memory optimized table?

745


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

881


How do you pronounce sql?

773


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3673


What are the benefits of pl/sql packages?

804


What is sqlite format?

868


What is sql*loader and what is it used for?

791


how to run 'mysql' commands from a batch file? : Sql dba

835