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

  • ABC aptitute test questions (20)
  • ABC interview questions (563)
  • ABC placement papers (2)
  • ABC technical test questions (48)



ABC Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-00340: IO error processing online log string of thread string

2 7355

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

1 2548

ORA-22913: must specify table name for nested table column or attribute

1 6699

Post New ABC Oracle Errors Interview Questions



Un-Answered Questions

what are the skip functions in Load Runner?

1067


Have you shadowed a dentist's office before?

383


What is the composition of Cast Iron Grade:GG P70 ?

2880


what are the Types of DBCombo boxes?

1050


Why do some of the servers show the same number of total groups and new groups?

991






rate of vat on gold purchase local & o.m.s. & rate of % in sale local & o.m.s.

504


Tell me about any quality efforts you have overseen or implemented.

918


how to put cable sizing and cable glands size for respective cable & Cable Lug size in a DB sectors???

880


Give the safety precaution when working in a high place.

893


Does CO have adverse effects on plants?

869


hai friends i did my bcom (distance with out inter)and iam pursuing mca(distance alagappa university)iam learning testing cource in ameerpet can i elgibel for testing jobs pls guide me … …and send details to rangavijetha@gmail.com..thanks

618


How to confiner single router two services provided. Both service provided are same Speed

1218


Hi, I am new in oracle(SQL), could anyone help me in writing a correct SQL. Below is the table structure. Table: Subsc Fields: 1. Sub_no (this field will hold values of subscriber nos, for e.g. S111111, S222222, S333333, S444444, etc.) 2. s_status (this field will hold values for different status of subscriber, for e.g. 'A', 'S', 'C', etc.) 3. cus_id (this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) Table: Bill Fields: 1. Bill_no this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) 2. b_status = (this field will hold values for different status of bill for e.g. 'O', 'C', 'S', etc.) Note: 1. The Sub_no is a Primary key of Subsc table. 2. The cus_id is a foreign in Subsc table (referred from Bill_no field of Bill table) 3. The Bill_no field is the Primary key of Bill table. Query A --> I wrote a query to select cus_id/Bill_no which is in status open (b_status = 'O') and having more than two active subscriber (i.e. S_status = 'A') in it ( i.e. more the two subscribers in same bill). select s.cus_id from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id having count(sub_no) = 2 Problem : The above query will give the cus_id (or rather bill_no) which are in open status (b_status ='O) and which are having TWO ACTIVE Subscribers (s_status ='A') in it. However, this query will also lists the cus_id/bill_no which are having more than TWO subscribers in it (but only two subscriber will be in Active status (s_status = 'A') and the others will be in s_status = 'C' or s_status = 'S'. Help needed: I want to write a query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it. B--> If I include the sub_no in the above query then NO row are returned. select s.cus_id, s.sub_no from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id, s.sub_no having count(sub_no) = 2 Help needed: I want to modify the above query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it ALONG with the sub_no. Thanks a lot in advance. Regards, Nitin

943


Is there any reason that we get shock on touching phase wire because the earth is at neutral potential? Is there any reason that the earth is at neutral potential because the neutral is earthed in apower station

809


3phase cable calculation formula by motor load

295






ABC Oracle Errors Interview Questions
  • C (8)
  • C++ (1)
  • STL (1)
  • OOPS (2)
  • C++ General (2)
  • MFC (1)
  • PHP (3)
  • Programming Languages AllOther (2)
  • CGI Perl (2)
  • JavaScript (1)
  • SNMP (1)
  • TCP IP (1)
  • Networking AllOther (3)
  • Visual Basic (4)
  • C Sharp (3)
  • ASP.NET (9)
  • VB.NET (3)
  • ADO.NET (1)
  • IIS (1)
  • BizTalk (1)
  • Dot Net Framework (3)
  • Dot Net WindowsForms (1)
  • Dot Net General (1)
  • Exchange Server (2)
  • WCF (1)
  • Oracle General (2)
  • Forms Reports (2)
  • SQL Server (14)
  • MySQL (2)
  • SQL PLSQL (4)
  • Windows AllOther (2)
  • Unix Commands (1)
  • Unix General (1)
  • Unix AllOther (1)
  • Solaris General (1)
  • Data Structures (1)
  • WinRunner (1)
  • Load Runner (3)
  • QTP (12)
  • Test Director (2)
  • Rational TestSuite (1)
  • Automation Testing AllOther (1)
  • Manual Testing (26)
  • QA Concepts (3)
  • Mobile Testing (1)
  • Test Cases (10)
  • Test Documents Reporting (3)
  • Testing AllOther (4)
  • Apache (1)
  • COBOL (3)
  • JCL (2)
  • DB400 (1)
  • Core Java (8)
  • Advanced Java (2)
  • Servlets (3)
  • HTML DHTML (2)
  • XML XSLT RSS (3)
  • Flash Action Scripting (1)
  • Cognos (1)
  • Informatica (4)
  • Data Stage (3)
  • SAS (2)
  • ETL (1)
  • Data Warehouse General (2)
  • HR Questions (2)
  • Design Patterns (2)
  • UML (1)
  • OOAD (1)
  • Project Planning (3)
  • Project Management (1)
  • Telecom Routers Switches (1)
  • SAP Basis (8)
  • SAP ABAP (4)
  • SAPScript (1)
  • SAP MM (2)
  • SAP PM (1)
  • SAP FI CO (6)
  • SAP HR (9)
  • SAP CRM (1)
  • SAP Security (4)
  • SAP Netweaver (3)
  • SAP B1 (1)
  • SAP AllOther (1)
  • Oracle Apps Financial (6)
  • Oracle Apps HRMS (1)
  • Software Quality Analysis (1)
  • Bio Technology (2)
  • Zoology (1)
  • General Physics (1)
  • Organic Chemistry (1)
  • Analytical Chemistry (2)
  • General Science (1)
  • Civil Engineering (16)
  • Mechanical Engineering (3)
  • Electrical Engineering (49)
  • Electronics Communications (8)
  • Chemical Engineering (2)
  • Instrumentation (1)
  • Power Plant Engineering (1)
  • Engineering AllOther (3)
  • Business Administration (1)
  • Marketing Sales (6)
  • Banking Finance (5)
  • Human Resources (6)
  • Personnel Management (2)
  • Industrial Management (2)
  • IT Management (4)
  • Business Management AllOther (2)
  • Audit (5)
  • CompanyAffairs CS (2)
  • Taxation (50)
  • Accounting General (42)
  • Accounting AllOther (34)
  • Advertising Media AllOther (1)
  • Architecture Design AllOther (2)
  • Call Centre AllOther (13)
  • UPSC General Studies (1)
  • SSC General Science (1)
  • SSC General Studies (1)
  • SSC AllOther (2)
  • POs (1)
  • BSRB Clerical (3)
  • BSRB AllOther (1)
  • Group I (2)
  • APPSC AllOther (6)
  • General Knowledge_Current Affairs (12)
  • Government AllOther (4)
  • Law AllOther (3)
  • Tourism Hotel AllOther (2)
  • Funny Interview Questions (1)
  • Everything Else AllOther (7)
  • English (4)
  • General Aptitude (9)
  • Puzzles (3)
  • Placement Papers (2)
  • CCNA (1)
  • CISA Certification (2)
  • ISTQB Certification (3)
  • Certifications AllOther (3)
  • H1B Visa (6)
  • USA Student Visa F1 Visa (2)
  • L1 Visa (4)
  • USA Visitor Visa B2 Visa (1)
  • USA Business Visa B1 Visa (3)
  • USA Fiance Visa K1 Visa (1)
  • USA Dependent Visa H4 Visa (1)
  • C Code (1)
  • C++ Code (5)
  • ADO.NET Code (1)
  • JavaScript Code (1)
  • GATE (1)
  • CAT (1)
  • MAT (1)
  • GMAT (1)
  • OPENMAT (1)
  • ICET (1)
  • Oracle Errors (3)
  • Scripts Errors (1)