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-02140: agg(expr) requires correspondng SUM(expr*expr) function

1 2855

QSM-02141: the reason why the capability is disabled has escaped analysis

1 4315

QSM-02142: COUNT(*) is not present in the select list

1 3433

QSM-02143: SUM(expr) without COUNT(expr)

1 3005

QSM-02144: aggregate functions are present without a GROUP BY clause

1 3146

QSM-02145: GROUP BY clause is present but no aggregate functions are used

1 3241

QSM-02146: see the reason why REFRESH_FAST_AFTER_INSERT is disabled

1 3922

QSM-02147: default date format is sensitive to session settings

1 2749

QSM-02148: many to many subquery joins require 9.0 compatibility or higher

1 2667

QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher

1 2810

QSM-02150: select lists must be identical across the UNION operator

1 3365

QSM-02151: subquery or named view in FROM list and < 9.0 compatibility

1 2877

QSM-02152: subquery or named view in FROM list even after view merging

1 4601

QSM-02153: inline view or subquery in FROM list not supported for this type MV

1 4713

QSM-02154: MV is not fast refreshable even with view merging

1 3428

Un-Answered Questions { Database Errors }

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2597

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

2802

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

why we are using shift key in unix shell script

3166

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

2662

What severity level errors are managed in TRY-CATCH block?

2224

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1679

ORA-26095: unprocessed stream data exists

3568

What is the use of NOLOCK locking hint?

1786

How to view the error log for any specific instance?

2486

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.............

2802

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

2434

IMP-00070: Lob definitions in dump file are inconsistent with database.

1744

ORA-26079: file "string" is not part of table string.string

1958

When do you get "getwmicomexception"?

2682

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