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

Explain primary key?

982

What are partitioned views and distributed partitioned views?

1033

What are the basic functions for master, msdb, model, tempdb databases?

1054

Explain the concept of recursive stored procedure.

983

What do you mean by an execution plan? Why is it used? How would you view it?

946

What is dbcc? Give few examples.

1051

What is row_number function?

1028

What do you mean by an execution plan?

1132

What is a trace frag? Where do we use it?

1114

Explain use of expression builder.

1038

What is use of except clause? How does it differ from not in clause?

1038

What are cursors and when they are useful?

1109

What is raid and what are different types of raid levels?

1165

What do you understand by a view? What does the with check option clause for a view do?

1018

Define views.

1030

Un-Answered Questions { Databases }

Explain look up fields?

874

What do you mean by 'normalization'?

1082

Does sql profiler affect performance?

1004

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

1044

What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?

1477

What is left join example?

964

What is database design and development?

1026

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1034

How does select query work?

955

Does microsoft 365 have access?

863

What is the difference between left join and right join?

961

What is the size of partition table?

1057

Where the sql logs gets stored?

1010

How to call a function from a stored procedure in SQL Server ?

1045

how we will Show selected records sorted in an ascending (asc) or descending (desc).

1000

For More Un-Answered { Databases } Questions Click Here