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-29337: tablespace 'string' has a non-standard block size (string)

1 3107

ORA-29338: datafile string is in an undesired state (string, string)

1 2869

ORA-29339: tablespace block size string does not match configured block sizes

1 4378

ORA-29340: export file appears to be corrupted: [string] [string] [string]

1 3303

ORA-29341: The transportable set is not self-contained

1 6808

ORA-29342: user string does not exist in the database

1 3200

ORA-29343: user string (mapped from user string) does not exist in the database

1 3537

ORA-29344: Owner validation failed - failed to match owner 'string'

1 3122

ORA-29345: can not plug a tablespace into a database using a different character set

1 4679

ORA-29346: invalid tablespace list

1 3149

ORA-29347: Tablespace name validation failed - failed to match tablespace 'string'

1 3694

ORA-29348: You must specify the datafiles to be plugged in

1 4996

ORA-29349: tablespace 'string' already exists

1 7923

ORA-29351: can not transport system, sysaux, or temporary tablespace 'string'

1 3320

ORA-29352: event 'string' is not an internal event

1 3453

Un-Answered Questions { Database Errors }

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

1628

How will you Handle Error in SQL SERVER 2008?

2413

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

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

1949

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

1962

hp asking for replication floppy to do reinstall 25254 server assistant

2901

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?

2729

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

4001

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

2420

What is the use of NOLOCK locking hint?

1798

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

6755

What is Mutex error in Triggers?

3081

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

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2746

How to view the error log for any specific instance?

2494

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