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-00382: %s not a valid block size, valid range [string..string]

1 3140

ORA-00383: DEFAULT cache for blocksize string cannot be reduced to zero

1 3390

ORA-00384: Insufficient memory to grow cache

1 5426

ORA-00385: cannot enable Very Large Memory with new buffer cache parameters

1 4954

ORA-00390: log string of thread string is being cleared, cannot become current log

1 2944

ORA-00391: All threads must switch to new log format at the same time

1 2955

ORA-00392: log string of thread string is being cleared, operation not allowed

1 5493

ORA-00393: log string of thread string is needed for recovery of offline datafiles

1 3460

ORA-00394: online log reused while attempting to archive it

1 3588

ORA-00395: online logs for the clone database must be renamed

1 3008

ORA-00396: error string required fallback to single-pass recovery

1 3131

ORA-00397: instance recovery process terminated with error

1 3547

ORA-00398: abort thread recovery due to reconfiguration

1 2963

ORA-00399: corrupt change description in redo log

1 5314

ORA-00400: invalid release value string for parameter string

1 8197

Un-Answered Questions { Database Errors }

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

2105

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2870

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

2448

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

2696

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

2651

How to view the error log for any specific instance?

2486

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

2639

what is new g/l functionality

2611

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

2662

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

2801

what is the instrument that used in Mechanical Energy??

2680

ORA-16626: failed to enable specified object

2218

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.

1649

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

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

1743

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