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-37023: (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.

1 2695

ORA-37026: (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.

1 2472

ORA-37027: (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.

1 3368

ORA-37028: (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.

1 2971

ORA-37030: (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.

1 2462

ORA-37031: (XSMLTMAINT02) You cannot MOVE, DELETE, or add SESSION values of dimension workspace object in MULTI mode.

1 2932

ORA-37032: (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.

1 3017

ORA-37035: (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.

1 3106

ORA-37040: (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.

1 2662

ORA-37041: (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.

1 3061

ORA-37042: (XSACQUIRE_DEP_DEADLOCK) Cannot wait to acquire composite, concat, dimension map, or internal partition workspace object since doing so would cause a deadlock.

1 2821

ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

1 2818

ORA-37044: (XSACQUIRE_OLDGEN) Cannot acquire object workspace object without resync.

1 2483

ORA-37060: (XSMCSESS08) number is not a valid custom member in dimension workspace object.

1 2661

ORA-37070: You may not execute OLAP DML programs in a parallel query session.

1 3025

Un-Answered Questions { Database Errors }

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

2410

ORA-26030: index string.string had string partitions made unusable due to:

1941

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2455

IMP-00064: Definition of LOB was truncated by export

6415

[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

2731

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

2658

IMP-00070: Lob definitions in dump file are inconsistent with database.

1747

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2539

When do you get "getwmicomexception"?

2682

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

6746

How will you Handle Error in SQL SERVER 2008?

2403

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

2232

why we are using shift key in unix shell script

3167

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

1970

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2807

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