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-34363: (MXDSS13) number other user writing

1 3238

ORA-34481: (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.

1 3086

ORA-34487: (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.

1 2884

ORA-34489: (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.

1 2870

ORA-34514: (MXOPERR) You cannot string string data in the expression that begins with 'string'.

1 3042

ORA-34656: (MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax

1 3150

ORA-34719: (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion

1 2739

ORA-34722: (NLSCHARSET05) CAUTION: Character data loss in character set conversion from string to string

1 3186

ORA-34726: (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string

1 2921

ORA-34802: (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.

1 2999

ORA-34871: (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.

1 2872

ORA-34896: (PPMONTHS00) At least 12 month names must be given. Only number were provided.

1 2911

ORA-34897: (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.

1 2869

ORA-34900: (PPWKDAYS00) At least 7 day names must be given. Only number were provided.

1 2709

ORA-34901: (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.

1 3469

Un-Answered Questions { Database Errors }

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

2655

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

2591

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

2101

why we are using shift key in unix shell script

3153

What is the use of NOLOCK locking hint?

1779

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

2425

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

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

3148

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

1764

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

1934

ORA-16626: failed to enable specified object

2210

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

1669

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

3658

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

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2717

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