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 3361

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

1 3322

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

1 3002

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

1 3034

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

1 2933

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 3016

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

1 2718

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

1 2889

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

1 2960

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

1 2468

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 3214

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

1 2716

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

1 7255

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

1 3426

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

1 5730

Un-Answered Questions { Database Errors }

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

2495

why we are using shift key in unix shell script

3227

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

2576

ORA-26027: unique index string.string partition string initially in unusable state

6789

What is the use of NOLOCK locking hint?

1830

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6713

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2945

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2760

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1696

ORA-26079: file "string" is not part of table string.string

1998

What is the meaning of lock escalation and why/how to stop this?

2705

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

3435

ORA-26082: load of overlapping segments on table string.string is not allowed

1813

IMP-00064: Definition of LOB was truncated by export

6465

ORA-26094: stream format error: input column overflow

2853

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