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-24395: cannot reinitialize non-existent pool

1 3366

ORA-24396: invalid attribute set in server handle

1 3539

ORA-24397: error occured while trying to free connections

1 3193

ORA-24398: connection pool already exists

1 2985

ORA-24399: invalid number of connections specified

1 5179

ORA-24400: error occured while creating connections in the pool

1 3181

ORA-24401: cannot open further connections

1 4063

ORA-24402: error occured while creating connections in the pool

1 3420

ORA-24403: error occured while trying to destroy the connection pool

1 3739

ORA-24404: connection pool does not exist

1 7273

ORA-24405: error occured while trying to create connections in the pool

1 2922

ORA-24406: API mode switch is disallowed when a call is in progress.

1 2942

ORA-24407: connection pool already exists

1 3270

ORA-24408: could not generate unique server group name

1 10229

ORA-24409: client cannot understand the object

1 3298

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.

2590

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

2716

ORA-16626: failed to enable specified object

2278

How will you Handle Error in SQL SERVER 2008?

2446

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2761

What is Mutex error in Triggers?

3132

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

2035

write a database figure to implement the master detained relationship.

3020

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

2868

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

2270

hp asking for replication floppy to do reinstall 25254 server assistant

2969

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2789

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 ??

1736

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

2701

What is the use of NOLOCK locking hint?

1837

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