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-01603: illegal grouping size in clause "string" of string

1 3128

ORA-01604: illegal number range in clause "string" of string

1 3145

ORA-01605: missing numbers in clause "string" of string

1 3561

ORA-01606: gc_files_to_locks not identical to that of another mounted instance

1 7110

ORA-01607: cannot add logfile to the specified instance

1 3183

ORA-01608: cannot bring rollback segment 'string' online, its status is (string)

1 3069

ORA-01609: log string is the current log for thread string - cannot drop members

1 6351

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

1 15768

ORA-01611: thread number string is invalid - must be between 1 and string

1 4817

ORA-01612: instance string (thread string) is already enabled

1 4629

ORA-01613: instance string (thread string) only has string logs - at least 2 logs required to enable.

1 6871

ORA-01614: instance string (thread string) is busy - cannot enable

1 3095

ORA-01615: instance string (thread string) is mounted - cannot disable

1 5437

ORA-01616: instance string (thread string) is open - cannot disable

1 3426

ORA-01617: cannot mount: string is not a valid thread number

1 7901

Un-Answered Questions { Database Errors }

What is the use of NOLOCK locking hint?

1837

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?

2768

How will you Handle Error in SQL SERVER 2008?

2446

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

1823

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

2269

When do you get "getwmicomexception"?

2735

ORA-26095: unprocessed stream data exists

3642

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

2788

ORA-26028: index string.string initially in unusable state

3916

NZE-28890: Entrust Login Failed

1932

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

2471

write a database figure to implement the master detained relationship.

3019

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

2722

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

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

2760

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