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 17818

write a qurey for finding the length of the sting.

 6 12908

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 18470

what is oracle sql,pl/sql with interfaces

 2 7165

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

 1767

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

 3 7399

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

 8 18361

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

 4 14473

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

 1 2949

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 17566

List the differences between plsql - function & procedures

 2 6370

What is pl/sql tables?

 7 10088

What is a mutating table

 5 9225

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

 2 7803

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

 3 7825

Post New TCS SQL PLSQL Interview Questions


TCS SQL PLSQL Interview Questions


Un-Answered Questions

What is the space complexity of selection sort?

541

In how many parts 'non-tax revenue' is divided?

643

What is aot build?

402

Do you have any offers from other companies?

754

What is meant by turnover?

626




what are debentures? What are their features?

576

In which situations we are using jms?

482

Why arraylist is not synchronized in java example?

460

What is the importance of a Button control?

864

How to hit application without hitting the web server?

1001

Which data structure is used in arraylist?

469

what type of questions asked for barclays technologies pune please send urgent

5220

What are the key innovations of sap s/4hana simple logistics?

57

How do you manage client-buying frequencies?

1850

What is the keyboard shortcut for paste special?

297