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 14965

What cursor type do you use to retrieve multiple recordsets?

17 51126

What is normalization ?

9 13669

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

12 67919

State the difference between implict and explict cursor's?

7 15747





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

3 10543

What are wait events. Describe the wait event tables.

1 3580

How do u count no of rows in a table?

8 8992

When do we create bitmap indexes

2 6785

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

8 13814

function can return multiple value?how give give sample coding

2 11861

Difference between NVL, NVL2 and NULLIF

1 29109

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

2 7258

What are the Diff B/W Cursor and REF Cursor

3 8790

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

384

Post New CTS SQL PLSQL Interview Questions



Un-Answered Questions

Which of these techniques is not useful for partition testing at the class level Option 1 attribute-based partitioning Option 2 category-based partitioning Option 3 equivalence class partitioning Option 4 state-based partitioning

5625


What are the enzymes produced by streptococci?

860


How will account an advance of Rs.10000/- which is a permanent prepayment, can I make payment for this?

106


How to draw transparent text onto a TBitmap ?

615


I checked in modified code into vSS . Now I have another working area and which has older version. Now I wanted to findout the difference between VSS and older version in another working area which is not the VSS area. Now the question is after getting difference between the VSS and another working area. There will be some files difference. How do I take only difference files recursively into some other area.

1094






What icon is used in WinRunner to get an explanation of the syntax of TSL?

746


Why it is recommended to add verification checks to your all your scenarios?

773


What does those terms actually mean included in the j.d.k i.6?

841


what is meant by artwork review and handling procedure with an example?

797


What is the ESI sheet?and its role in real time

745


Hi, I would like to check if my understanding is correct I have a negative amount for provision of income tax in my balance sheet from my previous financial year.What are the accounting treatments for income tax paid and then refunded to you for the current year? Is this correct? For payment Dr provision of income tax cr bank For tax refund Cr provision of income tax Dr bank Do I need to input anything in income tax expense acct?

335


What is real time power factor control panel(RTPFC)?

1967


why only j2me is used for mobile???

699


There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?

929


Why Ethanol is Used for Standardization of GC Head space?

2522






CTS SQL PLSQL Interview Questions
  • C (31)
  • STL (1)
  • OOPS (10)
  • C++ General (12)
  • ActiveX (1)
  • Delphi (1)
  • PHP (2)
  • Programming Languages AllOther (15)
  • JavaScript (2)
  • VB Script (2)
  • JSP (1)
  • Shell Script (2)
  • Ruby on Rails (1)
  • AngularJS (2)
  • UDP (1)
  • Networking Administration (2)
  • Networking AllOther (3)
  • Visual Basic (2)
  • C Sharp (8)
  • ASP.NET (22)
  • VB.NET (3)
  • COM+ (1)
  • IIS (1)
  • Crystal Reports (3)
  • BizTalk (1)
  • Dot Net Framework (2)
  • Dot Net General (5)
  • Microsoft Related AllOther (1)
  • Oracle General (11)
  • Architecture (1)
  • Database Management (2)
  • Oracle AllOther (1)
  • SQL Server (14)
  • MySQL (1)
  • DB Architecture (2)
  • DB Administration (6)
  • SQL PLSQL (17)
  • Databases AllOther (3)
  • Windows Threads (1)
  • Windows General (1)
  • Windows AllOther (5)
  • Linux Commands (2)
  • Linux Threads (1)
  • Unix Commands (8)
  • Unix AllOther (1)
  • Solaris Commands (4)
  • Solaris AllOther (2)
  • RTOS AllOther (1)
  • Operating Systems General Concepts (3)
  • Data Structures (2)
  • WinRunner (9)
  • Load Runner (11)
  • QTP (90)
  • Test Director (4)
  • Rational TestSuite (1)
  • Silk Test (2)
  • Automation Testing AllOther (4)
  • Manual Testing (145)
  • QA Concepts (12)
  • Mobile Testing (2)
  • Test Cases (12)
  • Test Documents Reporting (2)
  • Testing AllOther (9)
  • Servers AllOther (1)
  • COBOL (27)
  • JCL (19)
  • CICS (5)
  • DB2 (19)
  • IMS (1)
  • Natural (1)
  • MVS (3)
  • VSAM (6)
  • QSAM (1)
  • IBM MainFrame AllOther (4)
  • RPG400 (27)
  • DB400 (1)
  • IBM AS400 AllOther (17)
  • Core Java (41)
  • Advanced Java (1)
  • EJB (3)
  • Servlets (6)
  • Struts (6)
  • JDBC (7)
  • J2EE (3)
  • Weblogic (8)
  • Java Networking (2)
  • Java J2EE AllOther (5)
  • Java Related AllOther (2)
  • MQSeries (1)
  • Middleware AllOther (1)
  • HTML DHTML (2)
  • Web Related AllOther (5)
  • Teradata (8)
  • Business Objects (13)
  • Cognos (17)
  • Informatica (74)
  • Crystal Enterprise Suite (2)
  • Ab Initio (10)
  • Data Stage (40)
  • SAS (11)
  • Micro Strategy (1)
  • ETL (3)
  • Data Warehouse General (5)
  • HR Questions (21)
  • Design Patterns (1)
  • Project Management (1)
  • Version Control AllOther (2)
  • SAP Basis (8)
  • SAP ABAP (28)
  • SAP SD (14)
  • SAP MM (1)
  • SAP FI CO (24)
  • SAP CRM (1)
  • SAP SRM (4)
  • SAP Business Warehouse (3)
  • SAP Security (7)
  • SAP Business Objects BO BOBJ (2)
  • Siebel (2)
  • Oracle Apps Technical (7)
  • Oracle Apps Financial (1)
  • Cryptography General (1)
  • WebMethods (4)
  • SeeBeyond (17)
  • JCAPS (2)
  • Civil Engineering (1)
  • Mechanical Engineering (1)
  • Electrical Engineering (18)
  • Electronics Communications (22)
  • Aeronautical Engineering (1)
  • Industrial Engineering (1)
  • Engineering AllOther (3)
  • Business Administration (1)
  • Banking Finance (4)
  • Human Resources (1)
  • Business Management AllOther (1)
  • Audit (1)
  • CompanyAffairs CS (1)
  • Taxation (1)
  • Accounting General (5)
  • Accounting AllOther (11)
  • Call Centre AllOther (11)
  • UPSC Political Science (1)
  • RRB (1)
  • BSRB Clerical (1)
  • Group I (4)
  • Group II AllOther (1)
  • APPSC AllOther (2)
  • General Knowledge_Current Affairs (2)
  • Tourism Hotel AllOther (1)
  • Everything Else AllOther (4)
  • English (5)
  • General Aptitude (102)
  • Puzzles (10)
  • Placement Papers (28)
  • CCNA (4)
  • Sun Certifications (3)
  • CISA Certification (1)
  • Oracle Certifications (2)
  • Certifications AllOther (7)
  • H1B Visa (3)
  • L1 Visa (3)
  • USA Dependent Visa H4 Visa (1)
  • Australia Visa (1)
  • C Code (1)
  • C++ Code (2)
  • J2EE Code (1)
  • GATE (1)
  • IIT JEE (1)
  • MAT (1)
  • GMAT (1)
  • C C++ Errors (1)
  • Oracle Errors (4)
  • SQLServer Errors (1)