SQL Tuning Quiz

Practice Quiz

DEPT table has index created on “dname ” column.

Oracle uses index while processing the below  sql statment :

SELECT deptno ,dname


A Table is having 20 columns. 10  reports  are created using this table.

For tuning purpose , how many indexes you suggest. Which is the best option.



About dbVidya

DB Vidya is a technology-driven firm. It is dedicated to providing Quality IT trainings and services worldwide. In this era of information technology where change is constant, DB Vidya, has carved a niche for itself by providing quality training by making use of the latest developments in technology.

Keep in Touch for latest Updates

Template Design © VibeThemes. All rights reserved.
Open Chat
Hello ,
Looking for additional Information?
Whatsapp Now !!!