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-01774: Dump undo option specified more than once

1 3572

ORA-01776: cannot modify more than one base table through a join view

1 9238

ORA-01779: cannot modify a column which maps to a non key-preserved table

1 7334

ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT

1 3447

ORA-01782: UNRECOVERABLE cannot be specified for a cluster or clustered table

1 3370

ORA-01783: only one RECOVERABLE or UNRECOVERABLE clause may be specified

1 3458

ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled

1 3470

ORA-01792: maximum number of columns in a table or view is 1000

1 4886

ORA-01799: a column may not be outer-joined to a subquery

1 8963

ORA-01804: failure to initialize timezone information

2 18511

ORA-01841: (full) year must be between -4713 and +9999, and not be 0

2 7807

ORA-01854: julian date must be between 1 and 5373484

1 12136

ORA-01858: a non-numeric character was found where a numeric was expected

1 5625

ORA-01859: a non-alphabetic character was found where an alphabetic was expected

1 3239

ORA-01861: literal does not match format string

1 6914

Un-Answered Questions { Database Errors }

How will you Handle Error in SQL SERVER 2008?

2446

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

2787

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.

2856

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

1823

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

2866

write a database figure to implement the master detained relationship.

3018

NZE-28890: Entrust Login Failed

1932

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

2181

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

3440

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

2236

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

2721

mount: mount to NFS server failed: System Error: Connection timed out

3713

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

2760

what is the instrument that used in Mechanical Energy??

2740

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

2471

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