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

What is a database schema in oracle?

1157

What is open database communication (odbc) in oracle?

1055

How to drop an index in oracle?

1122

What is a read only transaction in oracle?

1084

How to insert multiple rows with one insert statement in oracle?

1136

How to connect ms access to oracle servers?

1059

How to delete all rows a table in oracle?

1119

What is a parameter file in oracle?

1196

Can the query output be sorted by multiple columns in oracle?

1061

Can group functions be used in the order by clause in oracle?

1051

What is a static data dictionary in oracle?

1193

How to assign a tablespace to a users in oracle?

1092

How to drop an existing table in oracle?

1107

What is an oracle data file?

1163

How to revoke create session privilege from a user in oracle?

1073

Un-Answered Questions { Databases }

what is a database lock ? : Sql dba

1227

Describe in brief databases and sql server databases architecture.

1069

Are subqueries faster than joins?

1078

How to sort the query output in oracle?

1077

What is dbms_output put_line?

967

How to test subquery results with the exists operator?

1170

Difference between group by clause and having clause in SQL?

1030

What are the types of lock supported by ?

1095

Is insert autocommit in oracle?

1134

Explain the use of grant option in imp command.

1085

How do I change the max connections in mysql?

953

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

1170

Explain why an information gap exists in most organizations.

980

How do you handle your own transaction?

1055

What is equi join in sql?

1124

For More Un-Answered { Databases } Questions Click Here