What is the criteria while applying index to any column on
any table.
index syntax
-----------------
create index index_name on table_name (column_name)
| Is This Answer Correct ? | 0 Yes | 0 No |
7. Where would you look for errors from the database design?
How One can easily select all even, odd, or Nth rows from a table using SQL queries?
Can you join a table to itself?
What is pragma in pl sql?
What is the execution plan in sql?
What is pl sql block structure?
What is minus?
How many sql statements are used? Define them.
What is a file delimiter?
What is the difference between explicit and implicit cursors in oracle?
What is thread join () in threading?
what is difference between decode and case function?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)