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 9497

List the differences between plsql - function & procedures

TCS, Verizon,

2 7472

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

10 18453

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

6 14799

What is pl/sql tables?

TCS,

7 12389

What is a mutating table

TCS, Tech Mahindra,

5 11191

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

3 6225

what is the Default Libraries for Oracle Report 6i

IBM,

2266

What is the Diff b/w Constraints and Trigeer

HCL,

4 12639

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

2 6591

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 8375

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

4 7778

How do u count no of rows in a table?

CTS,

8 15975

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 4070

what is sql.

Ericsson, Hewitt,

7 11434

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How many types of tables are there?

952

What is the difference between distinct and unique in sql?

948

What is a dirty read sql?

1138

In pl/sql, what is bulk binding, and when/how would it help performance?

994

What is a dynamic query?

1022

How is a PL/SQL code compiled?

1230

What is a sql profiler?

1025

Can a procedure in a package be overloaded?

1043

What do you know by pl/sql cursors?

1105

What is the source code of a program?

1069

what is msql? : Sql dba

988

What is a crud api?

954

What are joins in sql?

1044

how to select unique records from a table? : Sql dba

1111

Why do we create stored procedures & functions in pl/sql and how are they different?

947

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