Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

CTS SQL PLSQL Interview Questions
Questions Answers Views Company eMail

How many LONG columns are allowed in a table?

6 18684

What cursor type do you use to retrieve multiple recordsets?

17 56962

What is normalization ?

9 16007

What is an index and types of indexes. How many number of indexes can be used per table ?

12 73073

State the difference between implict and explict cursor's?

7 18259





how can we find the select statement is indexed or not?

3 12981

What are wait events. Describe the wait event tables.

1 5047

How do u count no of rows in a table?

8 10930

When do we create bitmap indexes

2 7760

sql query to get zero records from a table having n no of records

8 17858

function can return multiple value?how give give sample coding

2 13843

Difference between NVL, NVL2 and NULLIF

1 33582

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 8346

What are the Diff B/W Cursor and REF Cursor

3 10208

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

738

Post New CTS SQL PLSQL Interview Questions




CTS SQL PLSQL Interview Questions


Un-Answered Questions

What's the last thing you learned that you thought was really interesting? : insurance cold calling

80


Explain what are the steps to build the data warehouse?

147


Is it ok to delete downloaded program files?

116


How many commands are there in linux?

124


What is the use of the persistence layer in sap hana system?

27






In a barber shop there are 2 doors. customer come in 1 door, leave in other. minimum # of chairs. barber spend his life in cutting. always barber can cut 1 customer. few chairs in the shop. if barber busy customer waits, if chairs full, customer leave. if no customer, barber sleeps. treat barber and customer as 2 threads. you can use Semaphore class with arrive and depart and count as parameter.

1328


How to sort double array in java?

129


which dance form does you like most?

158


Is it cc or c in a letter?

131


What are the advantages of java?

116


Why we are using Macros instead of Function Modules

1148


will you be comfortable in relocating?

184


When creating your own loops always create a counter and throw an exception if it loops to much in blue prism. Is it true or false?

1


Which files are created during the session rums by informatics server?

156


what are the different theories of failure under static load, explain briefly?

167