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-01693: max # extents (string) reached in lob segment string.string

1 3869

ORA-01694: max # extents (string) reached in lob segment string.string partition string

1 3309

ORA-01695: error converting rollback segment string to version 8.0.2

1 3307

ORA-01696: controlfile is not a clone controlfile

1 3609

ORA-01697: controlfile is for a clone database

1 6178

ORA-01698: a clone database may only have SYSTEM rollback segment online

1 4535

ORA-01699: tablespace 'string' is being imported for point in time recovery

1 2894

ORA-01704: string literal too long

1 5693

ORA-01715: UNIQUE may not be used with a cluster index

1 3084

ORA-01716: NOSORT may not be used with a cluster index

1 3774

ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT

2 10818

ORA-01719: outer join operator (+) not allowed in operand of OR or IN

2 9495

ORA-01720: grant option does not exist for 'string.string'

1 7306

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

ABC,

1 4382

ORA-01724: floating point precision is out of range (1 to 126)

1 4327

Un-Answered Questions { Database Errors }

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

2650

hp asking for replication floppy to do reinstall 25254 server assistant

2879

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

2105

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

2432

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2799

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

3988

write a database figure to implement the master detained relationship.

2934

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

1768

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

2696

what is the instrument that used in Mechanical Energy??

2680

why we are using shift key in unix shell script

3164

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

2212

What is the use of NOLOCK locking hint?

1784

IMP-00064: Definition of LOB was truncated by export

6413

what is new g/l functionality

2611

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