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-00089: invalid instance number in ORADEBUG command

1 3533

ORA-00090: failed to allocate memory for cluster database ORADEBUG command

1 4153

ORA-00091: LARGE_POOL_SIZE must be at least string

1 3730

ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC

1 4349

ORA-00093: %s must be between string and string

1 3215

ORA-00094: %s requires an integer value

1 4060

ORA-00096: invalid value string for parameter string, must be from among string

1 4564

ORA-00097: use of Oracle SQL feature not in SQL92 string Level

1 4571

ORA-00099: timed out while waiting for resource, potential PDML deadlock

1 3594

ORA-00100: no data found

1 3916

ORA-00101: invalid specification for system parameter DISPATCHERS

1 4692

ORA-00102: network protocol string cannot be used by dispatchers

1 3231

ORA-00103: invalid network protocol; reserved for use by dispatchers

1 3702

ORA-00104: deadlock detected; all public servers blocked waiting for resources

1 3498

ORA-00105: too many dispatcher configurations

1 3731

Un-Answered Questions { Database Errors }

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

1667

IMP-00064: Definition of LOB was truncated by export

6469

What is the meaning of lock escalation and why/how to stop this?

2711

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

2714

How will you Handle Error in SQL SERVER 2008?

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

2753

write a database figure to implement the master detained relationship.

3011

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

2864

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2253

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

2179

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1700

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

8879

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

3226

ORA-16626: failed to enable specified object

2275

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

1734

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