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

IBM Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-14155: missing PARTITION or SUBPARTITION keyword

 2 19226

ORA-02180: invalid option for CREATE TABLESPACE

 1 17143

ORA-02185: a token other than WORK follows COMMIT

 1 16508

ORA-24333: zero iteration count

 2 12776

ORA-26098: direct path context is not prepared

 1 2732




ORA-39070: Unable to open the log file.

 1 4320

ORA-01480: trailing null missing from STR bind value

 1 7973

LRM-00123: invalid character number found in the input file

 1 7479

ORA-12155: TNS:received bad datatype in NSWMARKER packet

 1 8840

PLS-00572: improper constraint form used

 1 4609

TNS-12537: TNS:connection closed

 1 4121

ORA-600?

 1 3846

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

 1704

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

 1793

Post New IBM Oracle Errors Interview Questions




IBM Oracle Errors Interview Questions


Un-Answered Questions

How can inflation be controlled?

127

Is rpc secure?

8

How can you set the priority for a work ques in blue prism?

1

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

87

What is the toughest time of (day, week, month, or year) for a person in the job? Why?

142




What is difference between inner join and self join?

52

What is jdbc connection string?

55

How to make a class or a bean serializable?

96

What is the use of Work Queues?

1

What do you understand by “preset” during the installation process of bridge bearings?

112

Tell me how you can list all routes for an application?

1

What are the different types of parallelism used in abinitio?

103

You're implementing a medieval strategy game in which pikemen should always walk in front of archers, and catapults should always be behind the archers. Explain how you could implement the movement system to ensure that you keep pikemen in front and catapults in the rear as much as possible. Explain how your answer might be different depending on whether or not the units simply need to end up in that configuration when they reach that destination, or if they need to maintain that formation while moving.

586

Why do we need to break a mirror, before patching, because when we go for patching, the server will be single user mode and at single user mode svc.startd demon wont be running hence SVM software also will be in disable state, there is no way it is going to impact the alternative mirror. So can you please let me know why we need to break the mirror

1747

What are some important characteristics of a soap envelope element?

80