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-34001: (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.

1 2901

ORA-34019: (MSCGADD03) workspace object is not a LIST PARTITION TEMPLATE.

1 3059

ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.

1 2730

ORA-34059: (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object.

1 2701

ORA-34061: (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.

1 2951

ORA-34141: (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.

1 2686

ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.

1 2961

ORA-34145: (MXCGPUT03) You cannot use the APPEND keyword with SURROGATE workspace object.

1 2967

ORA-34164: (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.

1 2691

ORA-34177: (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.

1 2584

ORA-34179: (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.

1 2853

ORA-34181: (MXCHGDCL21) workspace object is not a partitioned VARIABLE.

1 2704

ORA-34183: (MXCHGDCL22) Partition number already exists.

1 3422

ORA-34210: (MXCHGDCL18) You cannot change workspace object to a dimension composite because one or more surrogates has been defined for it.

1 2789

ORA-34243: (MXDCL11) You can only use the string keyword when defining a COMPOSITE.

1 3510

Un-Answered Questions { Database Errors }

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

2425

why we are using shift key in unix shell script

3152

IMG-02003: 2FF03 - incorrect color histogram feature specification

1703

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

2789

How will you Handle Error in SQL SERVER 2008?

2396

hp asking for replication floppy to do reinstall 25254 server assistant

2875

what is the instrument that used in Mechanical Energy??

2672

ORA-26084: direct path context already finished

1944

ORA-26076: cannot set or reset value after direct path structure is allocated

1960

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2717

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

1947

RMAN-05017: no copy of datafile number found to recover

2410

mount: mount to NFS server failed: System Error: Connection timed out

3658

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2208

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.

2868

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