Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 15530

write a qurey for finding the length of the sting.

6 11287

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 16491

what is oracle sql,pl/sql with interfaces

2 6389

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


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

3 6582

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

8 16374

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

4 13643

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

1 2533

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 15907

List the differences between plsql - function & procedures

2 5858

What is pl/sql tables?

7 8820

What is a mutating table

5 8084

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

2 7198

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

3 7076

Post New TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions

Un-Answered Questions

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?


What are the top cloud the basic characteristics of cloud computing?


lenz law application and define


What are the three parts of a jdbc url?


Did you ever built a production process in hadoop ? If yes then what was the process when your hadoop job fails due to any reason?


which dance form does you like most?


What exactly is a website?


Where can program checkpoints be stored for use in a restart?


what is ds administrator used for?


What is inheritance in simple words?


What is domain name system (dns)?


Can you write a class without specifying namespace?


What is inaddr_any?


What do you mean by query optimization?


Define reflection.