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 18205

What cursor type do you use to retrieve multiple recordsets?

17 56025

What is normalization ?

9 15579

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

12 72270

State the difference between implict and explict cursor's?

7 17813





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

3 12616

What are wait events. Describe the wait event tables.

1 4848

How do u count no of rows in a table?

8 10610

When do we create bitmap indexes

2 7590

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

8 17122

function can return multiple value?how give give sample coding

2 13488

Difference between NVL, NVL2 and NULLIF

1 33233

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

2 8174

What are the Diff B/W Cursor and REF Cursor

3 10017

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

676

Post New CTS SQL PLSQL Interview Questions




CTS SQL PLSQL Interview Questions


Un-Answered Questions

Using alternate indexes in batch program?

65


What are the ways in which duplicate form submission can occur?

79


In order to select an automation tool for automating ur application, what r the things u need to consider? For eg i will go for automation; 1) When there is a lot of retesting and regression testing. 2) Return on investments. 3) Whether the tool supports the appln. 4)--------------, etc. Pls give me more number of points because my answer did not satisfy the interviewer. Very urgent pls

945


what is active directory?

1302


What is quality policy?

88






how pressure transmitter work, what is its principal to measure and how its generate signal. for pressure transmitterinstallation which precautions must be taken ??

798


Explain about critical pedagogy.

62


How do I remove a form control in excel?

1


What is the use of mockmvc?

1


Are you willing to relocate and work at flexible working hours?

146


What is the difference between datastage and datastage tx?

90


What is stateful session bean?

74


What is the shortcut key for data validation in excel?

1


what are the methods in object?

107


What are the exceptions in android?

74