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-01088: cannot shut down ORACLE while active processes exist

1 3434

ORA-01089: immediate shutdown in progress - no operations are permitted

1 7211

ORA-01090: shutdown in progress - connection is not permitted

1 6796

ORA-01091: failure during startup force

1 3752

ORA-01092: ORACLE instance terminated. Disconnection forced

1 4147

ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

2 11506

ORA-01095: DML statement processed zero rows

1 3502

ORA-01096: program version (string) incompatible with instance (string)

1 5203

ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 8651

ORA-01099: cannot mount database in SHARED mode if started in single process mode

1 3194

ORA-01100: database already mounted

Oracle, Wipro,

3 37866

ORA-01101: database being created currently mounted by some other instance

1 4205

ORA-01102: cannot mount database in EXCLUSIVE mode

1 4706

ORA-01103: database name 'string' in controlfile is not 'string'

4 27643

ORA-01104: number of controlfiles (string) does not equal string

1 7248

Un-Answered Questions { Database Errors }

What is Mutex error in Triggers?

3129

What is the use of NOLOCK locking hint?

1837

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2255

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

2758

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

2269

ORA-26095: unprocessed stream data exists

3642

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

2470

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

2786

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

2522

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

2720

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2864

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.

2579

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

1990

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

2235

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

2181

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