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-02785: Invalid shared memory buffer size

1 3485

ORA-02786: Size needed for shared region is greater than segment size

1 2931

ORA-02787: Unable to allocate memory for segment list

1 3123

ORA-02788: Unable to find kernel process pointer in async process array

1 3173

ORA-02789: Maximum number of files reached

1 3258

ORA-02790: File name is too long

1 3166

ORA-02791: Unable to open file for use with asynchronous I/O

1 3333

ORA-02792: Unable to fstat() a file being used for asynchronous I/O.

1 2894

ORA-02793: Close of asynchronous I/O failed.

1 3011

ORA-02794: Client unable to get key for shared memory

1 3279

ORA-02795: Request list is empty

1 3299

ORA-02796: Done request is not in correct state

1 3231

ORA-02797: No requests available

1 3078

ORA-02798: Invalid number of requests

1 3325

ORA-02799: Unable to arm signal handler

1 2874

Un-Answered Questions { Database Errors }

What is Mutex error in Triggers?

3129

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2867

why we are using shift key in unix shell script

3237

NZE-28890: Entrust Login Failed

1932

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

2720

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

2500

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

ORA-26094: stream format error: input column overflow

2859

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

RMAN-05017: no copy of datafile number found to recover

2470

write a database figure to implement the master detained relationship.

3016

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

2715

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

1669

How will you Handle Error in SQL SERVER 2008?

2446

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2522

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