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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 9472

List the differences between plsql - function & procedures

TCS, Verizon,

2 7448

How do you retrieve the last N records from a table?

10 18435

Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 14785

What is pl/sql tables?

TCS,

7 12357

What is a mutating table

TCS, Tech Mahindra,

5 11161

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott

3 6207

what is the Default Libraries for Oracle Report 6i

IBM,

2254

What is the Diff b/w Constraints and Trigeer

HCL,

4 12609

If the base table structure is changed what will happen to join index????

2 6575

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 8359

what is the different between unique+not null & primary key,

4 7773

How do u count no of rows in a table?

CTS,

8 15946

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 4063

what is sql.

Ericsson, Hewitt,

7 11391

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a nested table in word?

952

What is a pdo connection?

1025

What is pl sql and why it is used for?

1111

What is the difference between an inner join and an outer join?

1016

What is the purpose of the partition table?

1046

What is a ddl command?

1083

What is the difference between python and sql?

995

Can you join views in sql?

951

What is cross join example?

989

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1575

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.

2607

What is the difference among union, minus and intersect?

991

Explain what is a subquery ?

1184

what are the different index configurations a table can have? : Sql dba

994

What is out parameter used for eventhough return statement can also be used in pl/sql?

1068

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