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

Database Errors Interview Questions

Questions Answers Views Company eMail

QSM-01021: materialized view, string, not found in the hint list

1 2979

QSM-01022: a more optimal materialized view than string was used to rewrite

1 2815

QSM-01023: materialized view, string, has GRANT errors

1 3185

QSM-01024: materialized view, string, has unknown compile errors

1 2837

QSM-01025: materialized view, string, not found

1 2840

QSM-01026: query rewrite is disabled for, string

1 4286

QSM-01027: materialized view, string, is unusable

1 3311

QSM-01028: materialized view, string, is currently being refreshed

1 2894

QSM-01029: materialized view, string, is stale in ENFORCED integrity mode

1 4449

QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode

1 2905

QSM-01031: materialized view, string, is stale in TRUSTED integrity mode

1 3105

QSM-01032: materialized view, string, not found

1 2831

QSM-01033: query rewritten with materialized view, string

1 4784

QSM-01034: materialized view, string, needs a dimension level to join table, string

1 2707

QSM-01035: a row level security policy exists on this table

1 2726

Un-Answered Questions { Database Errors }

What severity level errors are managed in TRY-CATCH block?

2223

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

3668

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

what is the instrument that used in Mechanical Energy??

2680

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

2701

ORA-26029: index string.string partition string initially in unusable state

2155

ORA-26094: stream format error: input column overflow

2801

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6652

IMP-00064: Definition of LOB was truncated by export

6415

What is the use of NOLOCK locking hint?

1786

what is new g/l functionality

2611

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

3862

What is Mutex error in Triggers?

3066

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

2434

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

1679

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