A reader went through an interview at eBay and shared the questions asked.
- Let’s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don’t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?
- I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?
- With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
- What is cursor and where do you use them?
3 Comments on eBay interview questions and answers
1. Execute with no log
2. Use materialised view
3. Instead of exporting to excel file export it to a txt file edit it and then modify it and convert it to excel.
4.A cursor is a temporary location like buffer in the memory where the result of a query is stored for further processing. While DML statements use implicit queries explicit ones can be defined for manipulation in PL/SQL blocks.
1. Copy the 5000 records that are needed using a Select into statement. Then drop the first table and rename the new table.
3. Specify the editing requirements in DTS transformations. You can filter, change the data as you like during the DTS
1. Create a new table by selecting the 5000 records from the table.
Drop the old table. Rename the new table to old table.
2.
3.
4. Cursor hold the results of the executed query. We use cursor when we have to read the result of the query for further processing.