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)
Explain materialized views and how they are used.
What is use of package in pl sql?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain what are clusters?
How you can change a cross join into an inner join?
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
How does one get the view definition of fixed views/tables?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What is difference between delete and truncate commands?
What is apply operator in sql?
How to change system global area (sga) in oracle?
How we get sum of column.
What port does mongodb use?
How do I disconnect mysql workbench?
What are different types of statements supported by sql?