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-12901: default temporary tablespace must be of TEMPORARY type

1 8149

ORA-12902: default temporary tablespace must be SYSTEM or of TEMPORARY type

1 4098

ORA-12910: cannot specify temporary tablespace as default tablespace

1 7240

ORA-12911: permanent tablespace cannot be temporary tablespace

1 9513

ORA-12912: Dictionary managed tablespace specified as temporary tablespace

1 3326

ORA-12913: Cannot create dictionary managed tablespace

1 5774

ORA-12914: Cannot migrate tablespace to dictionary managed type

2 4059

ORA-12915: Cannot alter dictionary managed tablespace to read write

1 4079

ORA-12916: Cannot use default permanent tablespace with this release

1 6192

ORA-12918: Invalid tablespace type for default permanent tablespace

1 4695

ORA-12919: Can not drop the default permanent tablespace

1 11836

ORA-12920: database is already in force logging mode

1 8514

ORA-12921: database is not in force logging mode

1 3657

ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running

1 4016

ORA-12923: tablespace string is in force logging mode

1 2884

Un-Answered Questions { Database Errors }

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

3916

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

8883

What is the meaning of lock escalation and why/how to stop this?

2716

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

1769

ORA-16626: failed to enable specified object

2278

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2584

ORA-26084: direct path context already finished

2001

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

What is the use of NOLOCK locking hint?

1837

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

2524

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

4042

ORA-26095: unprocessed stream data exists

3642

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

2035

NZE-28890: Entrust Login Failed

1932

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

2300

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