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-13902: The specified file string is not a data file.

1 2915

ORA-13903: Invalid combination of string threshold value and operator.

1 3005

ORA-13904: The file has been dropped and recreated during the procedure call.

1 3409

ORA-13905: Critical or warning threshold have incorrect values

1 2807

ORA-13906: The tablepace is not of the right type.

1 2995

ORA-13907: Threshold value is invalid.

1 3329

ORA-13908: Invalid combination of metrics id and object type parameters.

1 2989

ORA-13909: Invalid combination of threshold value and operator.

1 2768

ORA-13910: Parameter string cannot be NULL.

1 3194

ORA-13911: Threshold not found

1 2977

ORA-13912: Critical threshold value is less than warning threshold value.

1 3083

ORA-13913: The threshold cannot be set when SYSAUX is offline.

1 2964

ORA-13914: Threshold notification failed.

1 4011

ORA-14000: only one LOCAL clause may be specified

1 5860

ORA-14001: LOCAL clause contradicts previosly specified GLOBAL clause

1 3095

Un-Answered Questions { Database Errors }

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2522

what is new g/l functionality

2614

ORA-26032: index string.string loading aborted after string keys

2110

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

2807

ORA-16626: failed to enable specified object

2218

NZE-28868: Peer certificate chain check failed.

2803

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1683

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

2658

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.

2804

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.

1656

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2643

what is the instrument that used in Mechanical Energy??

2684

How will you Handle Error in SQL SERVER 2008?

2403

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

8820

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

1770

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