SQL PLSQL Interview Questions
Questions Answers Views Company eMail

How to use transactions efficiently : transact sql

652

Explain locks? : Transact sql

652

What is the least restrictive isolation level? : Transact sql

662

What is optimistic concurrency control? : Transact sql

631

What is the most restrictive isolation level? : Transact sql

661

Explain isolation levels. : Transact sql

658

Explain the advantages and disadvantages of stored procedure?

735

what does the t-sql command ident_incr does? : Transact sql

700

what is the difference between truncate and delete statement? : Transact sql

649

what is “go” in t-sql? : Transact sql

695

what are the join types in tsql? : Transact sql

665

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

597

what is uncommittable transactions? : Transact sql

655

what are the t string functions available in tsql? : Transact sql

617

what is the syntax used for partition in tsql? : Transact sql

636


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what are properties of a transaction? : Sql dba

656


Can we edit a view in sql?

639


what is column? : Sql dba

646


Why self join is used in sql?

587


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

627






When should I use nosql database?

632


Can we create foreign key without primary key?

621


Are sql database names case sensitive?

594


What is the difference between distinct and unique in sql?

550


how to analyze tables with 'mysqlcheck'? : Sql dba

636


Does a user_objects view have an entry for a trigger?

648


What is the difference between a procedure and a function?

586


How do I view tables in sql developer?

591


Write a sql query to find the names of employees that begin with ‘a’?

659


Mention what is the plv (pl/vision) package offers?

734