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-09818: Number is too large

1 2641

ORA-09819: Number exceeds maximum legal value

1 3368

ORA-09820: Conversion of class string to numeric representation failed.

1 2737

ORA-09821: Numeric label is not valid

1 2742

ORA-09822: Translation of audit file name failed.

1 6802

ORA-09823: device name is too long

1 2515

ORA-09824: Unable to enable allowmacaccess privilege.

1 2876

ORA-09825: Unable to disable allowmacaccess privilege.

1 2996

ORA-09826: SCLIN: cannot initialize atomic latch.

1 2933

ORA-09827: SCLGT: atomic latch return unknown error.

1 2764

ORA-09828: SCLFR: atomic latch return error.

1 2971

ORA-09829: pw_createPorts: server call pws_start_instance failed.

1 2765

ORA-09830: snyAddPort: failed to perform a remote procedure call.

1 3015

ORA-09831: snyStartThread: failed to build the server port set.

1 2648

ORA-09832: infoCallback: bad message format.

1 2708

Un-Answered Questions { Database Errors }

What is the use of NOLOCK locking hint?

1784

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

2801

NZE-28890: Entrust Login Failed

1877

ORA-26084: direct path context already finished

1949

ORA-26029: index string.string partition string initially in unusable state

2155

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?

2721

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

1941

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

1743

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

1616

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

1706

What is SCD (Slowly Changing Dimensions)? What are its types?

2662

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

1965

what is new g/l functionality

2611

write a database figure to implement the master detained relationship.

2934

ORA-26094: stream format error: input column overflow

2797

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