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 17787

write a qurey for finding the length of the sting.

 6 12898

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 18460

what is oracle sql,pl/sql with interfaces

 2 7160

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

 1765

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

 3 7395

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

 8 18347

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

 4 14469

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

 1 2945

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 17557

List the differences between plsql - function & procedures

 2 6370

What is pl/sql tables?

 7 10088

What is a mutating table

 5 9218

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

 2 7799

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 advantages of having in-built acvvvf (without seperate inverter in the control panel)in the drive system of elevators?

2814

Define dma? : Dot net architecture

544

is embeded technology is necessary for every electronics engineer?

1525

Explain drupal flow?

81

Do you know how backlink tools work?

461




Which built-in method returns the calling string value converted to lower case?

702

how will reduce the voltage. if 12volt/250ma transformer toreduce 6 volt

1517

How to synchoronize the generator (with gcb,GT) to grid????? ????? from Grid iam getting power (rated 400kv/20kv) through GT and its goes to UAT.,,ST.,, now my generator(rated 20kv ) ready.,, now iam closing my GCB.,, in GT iam suddenly giving 20kv on that Gt.,, what will happend

1614

How to get execution statistics reports on query statements?

560

What will happen if a column containing char type data is changed to the nchar data type?

611

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

535

What is inbound proxy and out bound proxy?

544

what do you understand by flashback feature of oracle?

547

Can oem windows 10 be reinstalled?

449

What is the ideal duration for a sprint?

1