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-00277: illegal option to the UNTIL recovery flag string

1 11480

ORA-00278: log file 'string' no longer needed for this recovery

1 4502

ORA-00279: change string generated at string needed for thread string

1 6191

ORA-00280: change string for thread string is in sequence #string

1 4414

ORA-00281: media recovery may not be performed using dispatcher

1 3445

ORA-00282: UPI string call not supported, use ALTER DATABASE RECOVER

1 3198

ORA-00283: recovery session canceled due to errors

1 10763

ORA-00284: recovery session still in progress

1 3997

ORA-00285: TIME not given as a string constant

1 3941

ORA-00286: no members available, or no member contains valid data

1 3119

ORA-00287: specified change number string not found in thread string

1 3448

ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE

1 3629

ORA-00289: suggestion : string

1 4074

ORA-00290: operating system archival error occurred. See error below

1 3171

ORA-00291: numeric value required for PARALLEL option

1 3397

Un-Answered Questions { Database Errors }

ORA-26084: direct path context already finished

1949

ORA-26094: stream format error: input column overflow

2797

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

2223

what is new g/l functionality

2611

ORA-16516: The current state is invalid for the attempted operation.

8817

What is live lock, deadlock and what is Lock escalation?

2432

ORA-26095: unprocessed stream data exists

3561

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

1706

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3154

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3383

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

1743

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

2650

What is the use of NOLOCK locking hint?

1784

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.

1648

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

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