Skip to contentSkip to footer

Administrateur De Base Junior Interview Questions

Salaries
Interviews

1,791 administrateur de base junior interview questions shared by candidates

An analyst at Oracle is conducting a satisfaction survey, sampling from a list of 10,000 new users. The list includes 2,500 French users, 2,500 German users, 2,500 Italian users, and 2,500 Portuguese users, The analyst selects a sample of 400 users, by randomly sampling 100 users of each country. Is this an example of simple random sample?
avatar

Database Administrator

Interviewed at Oracle

3.5★
Aug 4, 2014

An analyst at Oracle is conducting a satisfaction survey, sampling from a list of 10,000 new users. The list includes 2,500 French users, 2,500 German users, 2,500 Italian users, and 2,500 Portuguese users, The analyst selects a sample of 400 users, by randomly sampling 100 users of each country. Is this an example of simple random sample?

We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??
avatar

SQL Database Administrator/Senior Developer

Interviewed at Morningstar

3.8★
Apr 4, 2011

We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??

Viewing 151 - 160 interview questions

Glassdoor has 1,791 interview questions and reports from Administrateur de base junior interviews. Prepare for your interview. Get hired. Love your job.