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-38741: Formatted blocks value string is not valid.

1 2885

ORA-38742: Flashback log file has incorrect log reset status.

1 2646

ORA-38743: Time/SCN is in the future of the database.

1 4003

ORA-38744: file string is not the same file seen at start of flashback

1 3027

ORA-38746: error occurred while restoring data block (file# string, block# string)

1 3131

ORA-38747: corrupt before image (file# string, block# string)

1 3119

ORA-38748: cannot flashback data file string - file is in use or recovery

1 6613

ORA-38749: A media recovery has been started.

1 2980

ORA-38750: FLASHBACK DATABASE may not be performed using a dispatcher.

1 3181

ORA-38752: file string does not exist

1 3087

ORA-38753: Cannot flashback data file string; no flashback log data.

1 3871

ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

1 5865

ORA-38755: Flashback is already turned on for this tablespace.

1 2778

ORA-38756: Flashback is already turned off for this tablespace.

1 2798

ORA-38757: Database must be mounted EXCLUSIVE and not open to FLASHBACK.

1 8466

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

2751

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

3395

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

1949

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

3869

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

3183

write a database figure to implement the master detained relationship.

2952

What is Mutex error in Triggers?

3081

NZE-28868: Peer certificate chain check failed.

2814

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

2444

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2717

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

2680

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2547

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

8831

How will you Handle Error in SQL SERVER 2008?

2413

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

2814

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