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

Database Errors Interview Questions

Questions Answers Views Company eMail

NID-00129: Invalid DBID for datafile "string", expecting number, found number

1 3071

NID-00130: Mismatched CHECKPOINT_CHANGE# in datafile "string", expecting string, found string

1 3390

NID-00131: Control file is not current

1 16671

NID-00132: CHECKPOINT_CHANGE# in datafile "string": string in the future of controlfile: string

1 2916

NID-00133: Database should have only consistent datafiles

1 4363

NID-00134: Datafile "string" is not consistent

1 2607

NID-00135: There are number active threads

1 9836

NID-00137: All datafiles that are not dropped should be readable

1 12443

NID-00138: Block verification failed for datafile string (number)

1 3214

NID-00139: Mismatched dbname for datafile string, expected string, found string

1 3409

NID-00140: Specified database name string does not match previous name used string

1 3105

NID-00141: No database name specified, previous attempt used string

1 3068

NID-00142: Only changing database name, previous attempt changed dbid to number

1 2881

NID-00143: Mismatched controlfile string

1 2962

NID-00144: New name for database string is the same as current name string

1 4952

Un-Answered Questions { Database Errors }

What is Mutex error in Triggers?

3064

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

2801

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

1616

why we are using shift key in unix shell script

3165

ORA-26084: direct path context already finished

1949

what is new g/l functionality

2611

ORA-26094: stream format error: input column overflow

2798

How to view the error log for any specific instance?

2486

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.

2799

ORA-16626: failed to enable specified object

2218

ORA-26028: index string.string initially in unusable state

3862

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

1941

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

1966

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.

1650

ORA-26095: unprocessed stream data exists

3562

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