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-19627: cannot read backup pieces during controlfile application

1 3063

ORA-19628: invalid SCN range

1 3133

ORA-19629: no files in specified archivelog SCN range

1 3061

ORA-19630: end of volume encountered while copying backup piece

1 2840

ORA-19631: archivelog record contains no file name

1 4068

ORA-19632: file name not found in controlfile

1 2718

ORA-19633: controlfile record string is out of sync with recovery catalog

1 9141

ORA-19634: filename required for this function

1 9054

ORA-19635: input and output filenames are identical: string

1 4384

ORA-19636: archivelog thread string sequence string already included

1 3632

ORA-19637: backupPieceCreate requires file name when using DISK device

1 2801

ORA-19638: file string is not current enough to apply this incremental backup

1 6207

ORA-19639: file string is more current than this incremental backup

1 4694

ORA-19640: datafile checkpoint is SCN string time string

1 3825

ORA-19641: backup datafile checkpoint is SCN string time string

1 3476

Un-Answered Questions { Database Errors }

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.

2797

When do you get "getwmicomexception"?

2678

ORA-26084: direct path context already finished

1946

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

1940

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2797

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

2210

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

3858

ORA-26027: unique index string.string partition string initially in unusable state

6742

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

2729

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.

2868

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

2647

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

3984

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

1766

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

2660

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