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

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)

Databases Interview Questions

Questions Answers Views Company eMail

How to drop a stored procedure in oracle?

1051

How to lock and unlock a user account in oracle?

1107

How to convert characters to numbers in oracle?

1065

What are the differences between blob and clob in oracle?

1089

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

953

How to drop an existing view in oracle?

946

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

1153

How to delete multiple rows from a table in oracle?

1061

How to create a table index in oracle?

1134

What is an oracle function?

1166

How to use subqueries in the from clause in oracle?

1113

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

1028

How to create a new table in oracle?

1158

How to resolve name conflicts between variables and columns?

1031

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

1098

Un-Answered Questions { Databases }

When to use null data driven subscription?

207

What is oracle block? Can two oracle blocks have the same address?

1017

What is an example of a database?

1079

How do I find users in mysql?

1105

What does the no logging option do? Why would we use it? Why would we be careful of using it?

554

What are the different types of replication are there in sql server 2000?

1043

What are sql commands?

1014

How do convert or display the date or time as string?

1051

What is trace flags — 5101 and 5102 in sybase?

935

how to show all tables with 'mysql'? : Sql dba

1118

Do you have any idea about the tcl commands?

964

What is the use of partition by in sql server?

933

How to get execution path reports on query statements?

988

What are the benefits of filtered indexes?

1040

How can I make sql query run faster?

1017

For More Un-Answered { Databases } Questions Click Here