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-16177: media recovery is not required

1 3523

ORA-16178: Cannot specify remote destinations in archivelog manual mode

1 3255

ORA-16179: incremental changes to "string" not allowed with SPFILE

1 3972

ORA-16180: number processes specified for MAX_PARALLEL_SERVERS is too small

1 4169

ORA-16181: SGA specified for Logical Standby is too large

1 4152

ORA-16182: Internal error on internal channel during remote archival

1 3130

ORA-16184: DB_UNIQUE_NAME string hashes to the same value as DB_UNIQUE_NAME string

1 5402

ORA-16185: REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive

1 4141

ORA-16186: Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier

1 3147

ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes

1 14058

ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance

1 8064

ORA-16191: Primary log shipping client not logged on standby

1 4856

ORA-16192: Primary and standby network integrity mismatch

1 3379

ORA-16193: Primary and standby network encryption mismatch

1 3412

ORA-16194: Modifying DB_UNIQUE_NAME requires SID='*' qualifier

1 2704

Un-Answered Questions { Database Errors }

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

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

3668

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.

1651

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2721

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

1743

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

2801

ORA-26079: file "string" is not part of table string.string

1958

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

1708

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

2410

NZE-28868: Peer certificate chain check failed.

2801

ORA-26095: unprocessed stream data exists

3564

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

1768

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 SCD (Slowly Changing Dimensions)? What are its types?

2662

IMP-00064: Definition of LOB was truncated by export

6414

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