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-00367: checksum error in log file header

1 10692

ORA-00368: checksum error in redo log block

1 6118

ORA-00369: Current log of thread string not useable and other log being cleared

1 3643

ORA-00370: potential deadlock during kcbchange operation

1 3565

ORA-00371: not enough shared pool memory, should be atleast string bytes

1 13951

ORA-00372: file string cannot be modified at this time

1 6511

ORA-00373: online log version string incompatible with ORACLE version string

1 2973

ORA-00374: parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]

1 4143

ORA-00375: unable to get default db_block_size

1 4028

ORA-00376: file string cannot be read at this time

1 5687

ORA-00377: Frequent backups of file string causing write operation to stall

1 2949

ORA-00378: buffer pools cannot be created as specified

1 3036

ORA-00379: no free buffers available in buffer pool string for block size stringK

1 5233

ORA-00380: cannot specify db_stringk_cache_size since stringK is the standard block size

1 3006

ORA-00381: cannot use both new and old parameters for buffer cache size specification

1 3749

Un-Answered Questions { Database Errors }

How to view the error log for any specific instance?

2546

mount: mount to NFS server failed: System Error: Connection timed out

3716

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

ORA-16626: failed to enable specified object

2278

ORA-26027: unique index string.string partition string initially in unusable state

6794

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

NZE-28890: Entrust Login Failed

1932

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

2270

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2779

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

2590

ORA-26094: stream format error: input column overflow

2859

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

2502

What is Mutex error in Triggers?

3132

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.

2948

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

2716

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