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-01186: file string failed verification tests

1 3806

ORA-01187: cannot read from file string because it failed verification tests

1 4607

ORA-01188: Block size string in header does not match physical block size string

1 2921

ORA-01189: file is from a different RESETLOGS than previous files

1 5471

ORA-01190: controlfile or data file string is from before the last RESETLOGS

1 11213

ORA-01191: file string is already offline - cannot do a normal offline

1 5450

ORA-01192: must have at least one enabled thread

1 6381

ORA-01193: file string is not the same file seen at start of recovery

1 5719

ORA-01194: file string needs more recovery to be consistent

1 4580

ORA-01195: online backup of file string needs more recovery to be consistent

1 5456

ORA-01196: file string is inconsistent due to a failed media recovery session

1 6772

ORA-01197: thread string only contains one log

1 2832

ORA-01198: must specify size for log file if RESETLOGS

1 3943

ORA-01199: file string is not in online backup mode

1 4053

ORA-01200: actual file size of string is smaller than correct size of string blocks

1 6623

Un-Answered Questions { Database Errors }

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

2448

ORA-26029: index string.string partition string initially in unusable state

2155

When do you get "getwmicomexception"?

2680

ORA-26084: direct path context already finished

1949

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3383

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

2731

why we are using shift key in unix shell script

3165

what is new g/l functionality

2611

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-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3154

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2230

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

1941

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

2662

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 the use of NOLOCK locking hint?

1784

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