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-25527: bad format of _DB_MTTR_SIM_TARGET

1 2828

ORA-25528: too many candidate MTTRs are specified in _DB_MTTR_SIM_TARGET

1 3304

ORA-25530: FAST_START_MTTR_TARGET is not specified

1 6078

ORA-25531: MTTR specified is too small: string

1 2973

ORA-25532: MTTR specified is too large: string

1 6416

ORA-25533: FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified

2 6908

ORA-25534: _MEAN_TIME_TO_CLUSTER_AVAILABILITY is specified

1 2905

ORA-25950: missing where clause in join index specification

1 2687

ORA-25951: join index where clause cannot contain OR condition

1 2841

ORA-25952: join index must only contain inner equi-joins

1 3366

ORA-25953: join index cannot be a functional index

1 2866

ORA-25954: missing primary key or unique constraint on dimension

1 5830

ORA-25955: all tables must be joined in the where clause

1 2863

ORA-25956: join index cannot be created on tables owned by SYS

1 2905

ORA-25957: join index where clause cannot contain cycles

1 2759

Un-Answered Questions { Database Errors }

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6652

why we are using shift key in unix shell script

3165

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

2662

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

2801

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

1967

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3157

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

2155

How to view the error log for any specific instance?

2486

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

2410

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2870

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

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

3668

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

2106

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

2432

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2520

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