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

Database Errors Interview Questions

Questions Answers Views Company eMail

RMAN-06114: changed controlfile copy available

1 3092

RMAN-06115: changed backup piece available

1 3540

RMAN-06116: cannot crosscheck unavailable object

1 3064

RMAN-06117: cannot do DELETE EXPIRED on an object which is not expired

1 2939

RMAN-06118: a backup controlfile older than SCN string must be used for this recovery

1 3020

RMAN-06119: uncataloged datafile copy

1 2999

RMAN-06120: uncataloged archive log

1 2911

RMAN-06121: uncataloged controlfile copy

1 2787

RMAN-06122: CHANGE .. UNCATALOG not supported for BACKUPSET

1 6004

RMAN-06123: operation not supported without the recovery catalog or mounted controlfile

1 3514

RMAN-06124: error while looking up datafilecopy key: number

1 3061

RMAN-06125: error while looking up archive log key: number

1 2981

RMAN-06126: skipping offline file string

1 2994

RMAN-06127: skipping read-only file string

1 3015

RMAN-06128: skipping inaccessible file string

1 3542

Un-Answered Questions { Database Errors }

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?

2723

ORA-26084: direct path context already finished

1949

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2803

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

2656

write a database figure to implement the master detained relationship.

2936

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

1969

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

1768

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

1620

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

1710

hp asking for replication floppy to do reinstall 25254 server assistant

2886

what is new g/l functionality

2612

NZE-28868: Peer certificate chain check failed.

2803

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

2230

why we are using shift key in unix shell script

3167

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

6746

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