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-38609: FI Not enough memory for tree counting, requires at least stringKB

1 2760

ORA-38610: FI "string" name prefix is reserved for frequent itemset counting

1 2966

ORA-38611: FI input cursor's item type is not supported

1 3162

ORA-38612: FI item length cannot exceed half of one database block.

1 2878

ORA-38700: Limit of string flashback database logs has been exceeded.

1 3492

ORA-38701: Flashback database log string seq string thread string: "string"

1 6183

ORA-38702: Cannot update flashback database log file header.

1 3300

ORA-38703: Type string in header is not a flashback database log file.

1 3113

ORA-38704: Checksum error in flashback database log file header.

1 3164

ORA-38705: Expected block size string does not match string in log header.

1 3045

ORA-38706: Cannot turn on FLASHBACK DATABASE logging.

1 9858

ORA-38707: Media recovery is not enabled.

2 8130

ORA-38708: not enough space for first flashback database log file

2 12422

ORA-38709: Recovery Area is not enabled.

3 23643

ORA-38710: Flashback log version string is incompatible with ORACLE version string.

1 3073

Un-Answered Questions { Database Errors }

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

1628

ORA-16627: No standby databases support the overall protection mode.

4001

IMP-00064: Definition of LOB was truncated by export

6428

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

2420

IMG-02003: 2FF03 - incorrect color histogram feature specification

1722

ORA-26030: index string.string had string partitions made unusable due to:

1949

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

2530

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

2117

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

2483

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.

2816

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

1781

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.

2886

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

2680

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

1758

write a database figure to implement the master detained relationship.

2952

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