TCS SQL PLSQL Interview Questions Answers, TCS Placement Papers, TCS Technical, HR Interview Questions, TCS Aptitude Test Questions, TCS Campus Placements Exam Questions

Company Name Starts with ...

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

TCS SQL PLSQL Interview Questions

Questions Answers Views Company eMail

what is the difference between the query and corelated query

8 20719

write a qurey for finding the length of the sting.

6 15008

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 22518

what is oracle sql,pl/sql with interfaces

2 8400

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2270

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 8657

what is the difernece between named and anonymous pl/sql blocks??

8 21722

can we use out parameter in a function?Give an example.

4 16190

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 3713

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 20666

List the differences between plsql - function & procedures

2 7479

What is pl/sql tables?

7 12410

What is a mutating table

5 11214

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 8849

write a query find which rows of a table is updated on 2 days before?

3 9127

Post New TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions (108)

Un-Answered Questions

Can a checkbox as controlling field?

498

How to commuincate between an applet and a servlet?

1057

Explain the asp.net session state modes.

1077

What is bufferpool in db2?

1059

Integration between personnel administration & om?

1065

Describe a TCP connection sequence

4471

Name the different types of Lookups in Datastage?

1264

Why do we use view in sql?

970

What does @inject mean in java?

1108

Mac, windows or linux? Why do you love this platform while using jquery?

787

How does a .exe file work?

949

What is interface in oop?

1138

What is conditional formatting excel?

698

Describe your life as a news headline of today?

1397

Is python easy to learn?

855