What are the most common interview questions on ETL Testing for experience?

1189

What is a nvl function? How can it be used?

1089

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1829

How to convert characters to numbers in oracle?

1112

Is rowid unique in oracle?

1042

What are the system predefined user roles?

1094

How to connect to a remote server?

1187

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2100

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1991

What are the attributes of the cursor?

1057

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2140

what is the difference between substr and instr function in oracle?

1140

Explain the use of constraints option in exp command.

1079

How do you find current date and time in oracle?

1099

What is a snapshot in oracle database?

1070