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-22852: invalid PCTVERSION LOB storage option value

1 4983

ORA-22853: invalid LOB storage option specification

1 12714

ORA-22854: invalid option for LOB storage index

1 3433

ORA-22855: optional name for LOB storage segment incorrectly specified

1 3659

ORA-22856: cannot add columns to object tables

2 6087

ORA-22857: cannot modify columns of object tables

1 3456

ORA-22858: invalid alteration of datatype

1 6555

ORA-22859: invalid modification of columns

1 6472

ORA-22860: object type expected

1 3160

ORA-22861: invalid user-defined type

1 3107

ORA-22862: specified object identifier doesn't match existing object identifier

1 2968

ORA-22863: synonym for datatype string.string not allowed

1 4183

ORA-22864: cannot ALTER or DROP LOB indexes

1 14316

ORA-22865: more than one column specified

1 3203

ORA-22866: default character set is of varying width

1 3201

Un-Answered Questions { Database Errors }

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

2465

What is the use of NOLOCK locking hint?

1831

What is live lock, deadlock and what is Lock escalation?

2495

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

1813

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

1998

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

2714

ORA-26076: cannot set or reset value after direct path structure is allocated

2030

why we are using shift key in unix shell script

3227

ORA-26084: direct path context already finished

1994

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

2695

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

2176

ORA-16516: The current state is invalid for the attempted operation.

8872

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

2517

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

1664

IMP-00064: Definition of LOB was truncated by export

6465

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