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

  • CA aptitute test questions (1)
  • CA interview questions (87)
  • CA placement papers (1)
  • CA technical test questions (20)



CA Oracle General Interview Questions
Questions Answers Views Company eMail

What are main difference between Stored Procedure and Functions.

6 20737

Post New CA Oracle General Interview Questions



Un-Answered Questions

in ‘C’ language for Matrix Multiplication fails” Introspect the causes for its failure and write down the possible reasons for its failure.

4069


Write all combinations of test cases for calculater on + symbel

909


Name the indicator diagram.

686


oracle 1st round What are the different types of joins? Explain normalization with examples. What cursor type do you use to retrieve multiple recordsets? Diffrence between a "where" clause and a "having" clause What is the difference between "procedure" and "function"? How will you copy the structure of a table without copying the data? How to find out the database name from SQL*PLUS command prompt? Tadeoffs with having indexes Talk about "Exception Handling" in PL/SQL? What is the diference between "NULL in C" and "NULL in Oracle?" What is Pro*C? What is OCI? Give some examples of Analytical functions. What is the difference between "translate" and "replace"? What is DYNAMIC SQL method 4? How to remove duplicate records from a table? What is the use of ANALYZing the tables? How to run SQL script from a Unix Shell? What is a "transaction"? Why are they necessary? Explain Normalizationa dn Denormalization with examples. When do you get contraint violtaion? What are the types of constraints? How to convert RAW datatype into TEXT? Difference - Primary Key and Aggregate Key How functional dependency is related to database table design? What is a "trigger"? Why can a "group by" or "order by" clause be expensive to process? What are "HINTS"? What is "index covering" of a query? What is a VIEW? How to get script for a view? What are the Large object types suported by Oracle? What is SQL*Loader? Difference between "VARCHAR" and "VARCHAR2" datatypes. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table. Difference between "ORACLE" and "MICROSOFT ACCESS" databases. How to create a database link ? PL/SQL interview questions... Normalize many to many relationships Difference - Equijoin and union What is TEMP table space in Oracle, what is rollback segment How do we find row chaining? Pattern matching operators Features in oracle 9i and 10g Why truncating table is faster than delete copy commit syntax Convert Zulu time zone to US Eastern time zone Difference - union and union all Difference - Group by, Order by clause Which Ranking functions are available? Difference - Decode, NVL, NVL2 Tradeoffs of using partitioned tables How can we call stored procedure in SQL query What are the restrictions on calling PL/SQL from SQL Why EXISTS is preferable to distinct Give 2 examples of avoiding unnecessary parsing.

2359


Select query optimisation

87






how can maintain the power factor and why and this is how do work tell us

713


For measuring weight of 2cm3 piece of density 4gm/cm3 which spring balance is best suited what is the range and least count how we calculate

387


WHAT TYPES OF ESSAYS ARE GIVING IN BANK OF AMERICA? CAN ANY ONE HELP ME

604


i have taken gre exam twice... first time i got 287( quant:154 & verbal: 133) second time i got 288(quant:149 & verbal:139) is there possibility to take universities -----quant:154& verbal:139....TOTAL=293 can u plz give me information regarding this............. if it is possible for some universities plz give me 5 best universities plz.........

629


explaine me what the stock market points & how to decide increase in points.

816


whats te normal transformer current rating

798


all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?

1405


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

933


In DAO we are writting sql queries , how it is possible with creating and closing database connections.

797


How to calculate dry of volume of concrete constant?How it comes 1.54 or 1.57

460






CA Oracle General Interview Questions
  • OOPS (1)
  • C++ General (8)
  • VC++ AllOther (1)
  • TCP IP (1)
  • Networking AllOther (1)
  • C Sharp (1)
  • ASP.NET (1)
  • Oracle General (1)
  • Oracle AllOther (1)
  • SQL Server (1)
  • SDK (1)
  • Linux AllOther (1)
  • Operating Systems General Concepts (2)
  • WinRunner (3)
  • Load Runner (1)
  • QTP (3)
  • Manual Testing (7)
  • DB2 (1)
  • Advanced Java (1)
  • Struts (1)
  • Web Related AllOther (1)
  • Business Objects (2)
  • Theoritical (4)
  • SAP Basis (1)
  • SAP FI CO (4)
  • Requirement Management (7)
  • Risk Analysis (3)
  • Estimation Analysis (4)
  • Planning & Integration (7)
  • Software Quality Analysis (5)
  • Software Integration & Release (3)
  • Electrical Engineering (2)
  • Electronics Communications (1)
  • Banking Finance (2)
  • Audit (2)
  • Taxation (5)
  • Accounting General (6)
  • Accounting AllOther (9)
  • Law AllOther (1)
  • Placement Papers (1)
  • SQLServer Errors (1)