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 20672

write a qurey for finding the length of the sting.

6 14985

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 22479

what is oracle sql,pl/sql with interfaces

2 8386

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

2262

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

3 8640

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

8 21691

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

4 16170

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

1 3709

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 20626

List the differences between plsql - function & procedures

2 7467

What is pl/sql tables?

7 12388

What is a mutating table

5 11189

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

2 8832

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

3 9113

Post New TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions (108)

Un-Answered Questions

U r project in which stage in implementation?

2514

How do pointers work?

1181

Give some examples of dapps?

What is session tracking?

1205

Is c and objective c the same?

What is Web Page Composer?

1008

Whats the difference between a thread and a process?

828

How do I combine multiple folders on a mac?

969

why we are not giving the zone 1 trip command to the master trip relay

1731

what questions do you have for me?

1070

What is the difference between a site and a web?

790

Tell me the command to install jar file in local repository.

187

Define unmanaged code?

975

Which is the largest indian deer?

952

What is meant by javabeans?

1094