Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-36881: (XSSRF00) The OLAP DML ROW2CELL function can only be used in a LIMITMAP.

1 3264

ORA-36882: (XSSRF01) The second parameter of an AW single row function cannot be NULL.

1 3252

ORA-36883: (XSSRF02) The first parameter of an AW single row function cannot be NULL.

1 2938

ORA-36884: (XSSRF03) The value of the first parameter of the AW single row function is incorrect.

1 2979

ORA-36902: (XSAGDNGL43) In AGGMAP workspace object, the MODEL workspace object is not a model over a base dimension of the AGGMAP.

1 2882

ORA-36904: (XSAGDNGL44) In AGGMAP workspace object, RELATION workspace object occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.

1 2942

ORA-36906: (XSAGDNGL45) 4. Model only includes one non-step dimension in the equations.

1 2649

ORA-36908: (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.

1 2834

ORA-36910: (XSAGDNGL47) In AGGMAP workspace object, DYNAMIC MODEL workspace object can only edit the top level of its matching relation hierarchy.

1 2902

ORA-36912: (XSAGDNGL48) In AGGMAP workspace object, MODEL workspace object cannot be simultaneous.

1 2402

ORA-36930: Cannot start a recursive call to Oracle OLAP because a ROLLBACK past an UPDATE to an attached analytic workspace has been performed.

1 3162

ORA-36950: (XSFCAST22) The list of string values cannot have more than number members. You supplied number.

1 2648

ORA-36952: (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.

1 7199

ORA-36954: (XSFCAST24) The cycle number must be between 1 and number. You specified number.

1 3363

ORA-36956: (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.

1 5664

Un-Answered Questions { Database Errors }

what is the instrument that used in Mechanical Energy??

2683

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...

2742

ORA-26094: stream format error: input column overflow

2808

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1620

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1683

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3385

what is new g/l functionality

2614

What severity level errors are managed in TRY-CATCH block?

2225

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2522

What is Mutex error in Triggers?

3071

ORA-16626: failed to enable specified object

2218

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2232

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2805

hp asking for replication floppy to do reinstall 25254 server assistant

2886

What is live lock, deadlock and what is Lock escalation?

2434

For More Un-Answered { Database Errors } Questions Click Here