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 17463

What cursor type do you use to retrieve multiple recordsets?

17 54839

What is normalization ?

9 15024

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

12 71279

State the difference between implict and explict cursor's?

7 17318

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

3 12154

What are wait events. Describe the wait event tables.

1 4581

How do u count no of rows in a table?

8 10188

When do we create bitmap indexes

2 7393

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

8 16313

function can return multiple value?how give give sample coding

2 13098

Difference between NVL, NVL2 and NULLIF

1 32493

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

2 7994

What are the Diff B/W Cursor and REF Cursor

3 9723

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


Post New CTS SQL PLSQL Interview Questions

CTS SQL PLSQL Interview Questions

Un-Answered Questions

how to analyze a crash using logcat?


What are different types of autowire?


tell me do you know new input type attribute in html5


1. what are the steps for gathering requirements in business blue print? 2. if we doesnt meet user requirements in a standard universe then what will we do? give me a scenario for developing a universe based on standard universe? 3.give me some standard universes which u have worked earlier? 4.give me some classes, objects which u have worked so far? u have ever created custom classes, objects? give me scenario? 6.have u ever exported the universe? y u have exported give me a scenario for exporting ? 7.which s prefferable for reporting either Webi or CR? give me a scenario for each one at what time u gone to webi and CR? can we schedule the reports daily, weekly, monthly ? 9.give me a scenario for LOV , slice & dice, drill, cross tab, variables, breaks, alerters, ranking? 10. what are roles in ur current project? 11. give me a senario for creating xcelcius?


What are the prerequisites for starting in deep learning?


What the difference between three phase contactor (coil 110vac) & three phase SSR (control voltage 110Vac)? May I use contactor in place of SSR?


How to retrieve data from an cursor to a record?


Explain constraints in sql?


How to find operating system in the client machine using javascript?


If iam developing an application that must accomodate multiple security levels though secure login and my web appplication is spanned across three web-servers (using round-robbin load balancing) what would be the best approach to maintain login-in state for the users?


Explain how to prepare culture-specific formatting in .net.


Explain the importance of finally over return statement?


Explain high-order bytes.


What is passive earth pressure ?


How does overpopulation effect ecological balance?