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 17917

write a qurey for finding the length of the sting.

 6 13005

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 18636

what is oracle sql,pl/sql with interfaces

 2 7209

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

 1781

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

 3 7439

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

 8 18448

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

 4 14535

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

 1 2983

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 17676

List the differences between plsql - function & procedures

 2 6404

What is pl/sql tables?

 7 10160

What is a mutating table

 5 9307

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

 2 7836

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

 3 7871

Post New TCS SQL PLSQL Interview Questions


TCS SQL PLSQL Interview Questions


Un-Answered Questions

What happens to voltage when current is zero?

779

what is bmg file and how to create that files?what will it contailn?

1898

What is Client-Server Computing?

1899

What is the maximum number of index per table?

572

What is report subscription?

93




After creating the test cases in excel and exported to td. How does test director know the headings?

629

what is data control language? : Sql dba

590

What is the maximum size of sql server database?

513

Define the term latent heat.

665

Explain what is the meaning of exploding a bom?

633

How to get the last index of a string in javascript?

508

What types of loops exist in php?

548

How the interaction between DB2, SQL, and QMF takes place?

1130

Which interface is responsible for transaction management in jdbc?

467

DEAR SIR,I GOT THE CALL LETTER FROM RRB, SECUNDERABD AS A JE-II SO PLEASE PROVIDE ME SOME MODEL QUESTION AND ANSWER PAPERS AND LAST YEAR QUESTION PAPERS

1626