SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is a natural join?

780

What is full join?

730

What is the difference between left join and left outer join?

1 1194

What does inner join mean?

796

Which one is better subquery or joins?

827

What is thread join () in threading?

772

What is the difference between left outer join and left join?

750

What is a left join?

734

Which is better join or inner query?

751

Is left join and outer join same?

815

How do you use join?

734

What is difference between left and right outer join?

769

What is faster join or subquery?

769

What does an inner join do?

844

What is a left inner join?

746


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Can we rollback truncate?

771


What is an exception in pl/sql?

773


C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.

2391


explain the options of myisamchk to improve the performance of a table. : Sql dba

765


What is schema in sql?

719


How do I upgrade sql?

784


Name the different types of indexes in sql and define them.

844


What do you mean by stored procedures? How do we use it?

758


Who developed sql?

805


What is mutating error in pl sql?

802


What is the basic form of sql query?

712


What is schema in sql example?

871


What is the difference between syntax error and runtime error?

865


In a distributed database system, can we execute two queries simultaneously?

791


how can we destroy the session, how can we unset the variable of a session? : Sql dba

772