Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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)

Databases Interview Questions

Questions Answers Views Company eMail

How to drop a stored procedure in oracle?

1106

How to lock and unlock a user account in oracle?

1162

How to convert characters to numbers in oracle?

1112

What are the differences between blob and clob in oracle?

1135

What privilege is needed for a user to create tables in oracle?

993

How to drop an existing view in oracle?

992

What happens if you set the sga too low in oracle?

1223

How to delete multiple rows from a table in oracle?

1117

How to create a table index in oracle?

1186

What is an oracle function?

1243

How to use subqueries in the from clause in oracle?

1165

What privilege is needed for a user to create indexes in oracle?

1085

How to create a new table in oracle?

1231

How to resolve name conflicts between variables and columns?

1080

What happens to the current transaction if the session is ended?

1136

Un-Answered Questions { Databases }

What is indexing in sql and its types?

1141

What is cartesian join in sql?

1196

What is localhost in mysql?

1062

How to set a transaction to be read only in oracle?

1139

What is the difference between "is" and "as" while creating procedure?

852

explain engines?

956

What is oracle latest version?

1153

Who are end users in dbms?

1035

What are the 3 types of behavioral triggers?

1313

what is normalization? : Sql dba

1137

What does the file extension accdb stand for?

1017

Explain what you mean by 3 tier architecture.

1127

How would you identify the shared_pool_size parameter that needs to be adjusted?

How many types of indexes are there in sql?

1044

How do you say mysql?

961

For More Un-Answered { Databases } Questions Click Here