Skip to contentSkip to footer

Desarrollador Oracle Pl Sql Interview Questions

Salaries
Interviews

1,521 desarrollador oracle pl sql interview questions shared by candidates

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 91 - 100 interview questions

See Interview Questions for Similar Jobs

Desarrollador De Formularios E Informes De OracleDesarrollador De OracleDba De Oracle SeniorAdministrador De Base De Datos De Aplicaciones OracleAplicaciones Oracle DbaAdministrador De Base De Datos De Aplicaciones De Oracle SeniorDesarrollador De Aplicaciones Oracle SeniorConsultor De Oracle Business Intelligence Suite Edición EmpresarialDesarrollador De Aplicaciones Oracle JuniorAnalista Desarrollador De Objetos De Negocios Administrador De HadoopDesarrollador De Objetos De Negocio Trabaja Desde CasaMainframe Db2 Sistema De Gestión De Bases De Datos RelacionalesAnalista Financiero De OracleConsultor De Big Data De HadoopAnalista De Sistemas Financieros De OracleGerente De Base De Datos De Aplicaciones Y Productos Del SistemaDesarrollador De Oracle Pl Lenguaje De Consulta Estructurado Senior

Glassdoor has 1,521 interview questions and reports from Desarrollador oracle pl sql interviews. Prepare for your interview. Get hired. Love your job.