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 20698

write a qurey for finding the length of the sting.

6 14997

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 22496

what is oracle sql,pl/sql with interfaces

2 8395

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

2263

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

3 8648

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

8 21704

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

4 16179

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

1 3709

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 20641

List the differences between plsql - function & procedures

2 7477

What is pl/sql tables?

7 12397

What is a mutating table

5 11205

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

2 8838

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

3 9119

Post New TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions (108)

Un-Answered Questions

What is slug in laravel?

768

What are valid operations on pointers?

1203

Which is better scala or python?

What are the implications of implementing database.stateful?

529

How to redirect https to http url through .htaccess?

965

Python list of lists, changes reflected across sublists unexpectedly

1010

What happens when a value is not entered for a manual and mandatory condition type and does a header condition type have an access sequence?

1075

What is software process?

1180

Do you know what is cross-site request forgery (csrf) and how rails is protected against it?

867

Which dd parameters are required?

1191

How do you alphabetize a list?

560

what is meant by s0c-07 system abend codes?

1083

Is integer a class?

1089

Sir we have maintaint RG 23 Part I Excise Register manually but we can maintaint excise register in Tally erp 9 we tray but tally not show properly RG 23 Part I Excise register like manual. please guide & solve the problme.

1867

In cement making,what is meaning of blend,fineness,density.

3525