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

Database Errors Interview Questions

Questions Answers Views Company eMail

NNL-00560: Shows or sets the server's request-processing delay

1 2614

NNL-00561: register [-t] [-d

] [-h] [-l] : register an object with Oracle Names

1 3203

NNL-00562: unregister [-d

] [-l] : unregister an object with Oracle Names

1 2898

NNL-00563: timed_query [] : query all objects in the Names server's cache

1 3251

NNL-00565: set trace_file_name [] [] : set|show the server's trace file name

1 2557

NNL-00566: set|show log_file_name [] [] : set|show the log file name on one or more servers

1 2464

NNL-00567: reorder_ns [] : Generate the enhanced discovery file

1 2719

NNL-00568: delegate_domain : Delegate the given domain to the given nameserver

1 3167

NNL-00569: domain_hint : Provide hint of a nameserver for a given domain

1 3223

NNL-00570: save_config [] : saves server configuration to parameter file

1 3265

NNL-00571: set|show save_config_on_stop []

1 2964

NNL-00572: set|show save_config_interval [] [] : set time of next config save

1 3061

NNL-00573: load_tnsnames [, ... ] : load tnsnames into ONames

1 2463

NNL-00574: dump_tnsnames [] : dump ONames addresses into tnsnames file

1 3089

NNL-00575: list_objects: list all objects in a domain or subtree

1 2774

Un-Answered Questions { Database Errors }

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

1743

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

3987

why we are using shift key in unix shell script

3164

What is the use of NOLOCK locking hint?

1784

NZE-28868: Peer certificate chain check failed.

2799

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-26082: load of overlapping segments on table string.string is not allowed

1768

[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

2722

How to view the error log for any specific instance?

2483

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

NZE-28890: Entrust Login Failed

1877

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2445

When do you get "getwmicomexception"?

2679

ORA-26084: direct path context already finished

1949

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

1965

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