Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

QSM-02001: clustered mv container table

1 2892

QSM-02002: DISTINCT aggregate measure in SELECT list

1 3318

QSM-02003: aggregate function nested within an expression

1 3027

QSM-02004: grouping column omitted from SELECT list

1 2613

QSM-02005: named view in FROM list

1 2752

QSM-02006: subquery in FROM list

1 3339

QSM-02007: multiple instances of the same table or view

1 2649

QSM-02008: non-join filter condition in WHERE or HAVING clause

1 3050

QSM-02009: non-inner join

1 2815

QSM-02010: join predicate with operator other than equals (=)

1 2771

QSM-02011: a HAVING clause is present

1 3149

QSM-02012: a CONNECT BY clause is present

1 2837

QSM-02013: SELECT list includes a RAW data type expression

1 2939

QSM-02014: GROUP BY expression other than a column

1 2731

QSM-02015: Index Organized Table (IOT) present in FROM list

1 2971

Un-Answered Questions { Database Errors }

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2230

ORA-26084: direct path context already finished

1949

hp asking for replication floppy to do reinstall 25254 server assistant

2882

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

2410

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.

2802

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

3385

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

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

3862

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

2801

what is the instrument that used in Mechanical Energy??

2680

IMP-00064: Definition of LOB was truncated by export

6415

When do you get "getwmicomexception"?

2682

why we are using shift key in unix shell script

3165

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

1968

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

2662

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