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 21083

write a qurey for finding the length of the sting.

6 15222

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 23031

what is oracle sql,pl/sql with interfaces

2 8557

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

1 2338

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

3 8815

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

8 22088

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

4 16384

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

1 3808

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 21065

List the differences between plsql - function & procedures

2 7607

What is pl/sql tables?

7 12679

What is a mutating table

5 11440

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

2 8992

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

3 9265

Post New TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions (108)

Un-Answered Questions

sir, I am from EEE branch.On feb 17 iam going to write an Exam for hindustan petrolium corporation Ltd.So plz send me the written exam pattern/Q's/interview questions.please mail to eee_dharmendra@yahoo.com

1922

Did you contributed the drupal site (any module)?

129

Tell some commonly used Excel VBA functions?

1121

Can you brief the hurdles you faced during Automation testing?

1133

what is actually contain test report? can anybody post the test report

2075

Can you please mail me the latest syllabus of UTTAR PRADESH DRUG INSPECTOR entrance exam and UTTAR PRADESH FOOD INSPECTOR entrance exam with the eligibility criteria for Uttar Pradesh domicile candidates.

2499

speak an minute where u reside

2503

How to use multiple submit buttons in asp.net mvc?

1294

Have you written applications to retrieve stored images in a table?

1081

could u pls anyone tel me .."which is the best instute that provides eficient practical knowledge and also real-time oriented knowldge to do a project in manual and automation testing..in hyd" pls send me to dis mail-id if u find any..? sinducute17@gmail.com

2252

The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

2422

Do you need any help with FEWA Electrical Supervisor exams?

1075

Which is the latest version of solidsworks?

1331

On a scale of one to ten, rate me as an interviewer now 26 which stack is used in 8086?

1051

Do you have the set of questions of operation round for Xioami mobile Process Trainer profile ?

1762