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-19207: scalar parameter string of XMLELEMENT cannot have an alias.

1 8375

ORA-19208: parameter string of function string must be aliased

1 4052

ORA-19209: invalid or unsupported formatting argument

1 3174

ORA-19210: column 'string', specified to be a key or update column for DBMS_XMLSTORE, does not not exist in table 'string'

1 3756

ORA-19211: column 'string', specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type

1 3182

ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()

1 3972

ORA-19300: Error occurred in uri processingstring

1 3103

ORA-19320: Host name not specified in HTTP URL

1 2847

ORA-19321: Could not open HTTP connection to host (string): port (string)

1 2925

ORA-19322: An error occurred while reading from host (string): port (string)

1 2991

ORA-19323: Invalid url string

1 3222

ORA-19330: Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator

1 2892

ORA-19331: Last argument to CREATE_DBURI operator must be a column

1 4633

ORA-19332: Invalid column in the CREATE_DBURI operator

1 3125

ORA-19333: Invalid flags for the CREATE_DBURI operator

1 3024

Un-Answered Questions { Database Errors }

IMP-00064: Definition of LOB was truncated by export

6413

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

3666

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2639

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

1941

what is new g/l functionality

2611

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1616

ORA-16516: The current state is invalid for the attempted operation.

8818

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

2801

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

1768

ORA-26084: direct path context already finished

1949

NZE-28890: Entrust Login Failed

1878

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

3989

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

2595

why we are using shift key in unix shell script

3165

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

1677

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