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 20686

write a qurey for finding the length of the sting.

6 14988

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 22481

what is oracle sql,pl/sql with interfaces

2 8388

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

2262

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

3 8643

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

8 21695

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

4 16173

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 20635

List the differences between plsql - function & procedures

2 7472

What is pl/sql tables?

7 12389

What is a mutating table

5 11191

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

2 8832

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

3 9113

Post New TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions (108)

Un-Answered Questions

Can I learn spark without hadoop?

268

what is alternater & engine genral protection?

2287

Explain the concept of active learning and when it's useful.

What is csrf attack in asp.net?

1025

What is a birthday attack?

896

Which is better jsp or servlet?

1056

List out all the falsifying tokens in Javascript?

1114

How to test a string as a literal and as an object ?

1097

what is the Relationship between EJB and CORBA architecture?

3887

What is the major change or update in Scala 2.12?

How to handle exceptions thrown by application with another servlet?

1091

Mainly Related to Oracle, DBMS , Oracle Stored Procedures, Functions, Oracle 9i Architecture, Redo logs..., Views,

2310

Explain the working of 6 stroke engine?

1131

What is the contract attribute of the element?

3534

Where does the user specify the maximum number of instances with the auto scaling commands?

165