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-01186: file string failed verification tests

1 3885

ORA-01187: cannot read from file string because it failed verification tests

1 4720

ORA-01188: Block size string in header does not match physical block size string

1 3022

ORA-01189: file is from a different RESETLOGS than previous files

1 5569

ORA-01190: controlfile or data file string is from before the last RESETLOGS

1 11332

ORA-01191: file string is already offline - cannot do a normal offline

1 5532

ORA-01192: must have at least one enabled thread

1 6495

ORA-01193: file string is not the same file seen at start of recovery

1 5808

ORA-01194: file string needs more recovery to be consistent

1 4670

ORA-01195: online backup of file string needs more recovery to be consistent

1 5549

ORA-01196: file string is inconsistent due to a failed media recovery session

1 6865

ORA-01197: thread string only contains one log

1 2902

ORA-01198: must specify size for log file if RESETLOGS

1 4024

ORA-01199: file string is not in online backup mode

1 4139

ORA-01200: actual file size of string is smaller than correct size of string blocks

1 6722

Un-Answered Questions { Database Errors }

IMP-00064: Definition of LOB was truncated by export

6473

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?

2767

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

3916

NZE-28890: Entrust Login Failed

1932

what is the instrument that used in Mechanical Energy??

2740

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6721

What severity level errors are managed in TRY-CATCH block?

2269

What is the use of NOLOCK locking hint?

1837

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

2721

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

1823

How to view the error log for any specific instance?

2546

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.

2856

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

6794

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.

1708

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

2235

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