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 different types of index?

1077

What are user-defined functions (udfs) in sql server?

1011

Explain how many normalization forms?

1049

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1181

Explain boyce and codd normal form(bcnf)?

980

How important do you consider cursors or while loops for a transactional database?

990

In what version of sql server were synonyms released?

961

What are the aggregate and scalar functions?

1096

What is the need for group functions in sql?

1100

What is the difference between varchar and varchar types?

1084

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1018

What is the difference between coalesce() & isnull()?

1152

What is the difference between local and global temporary tables?

1157

What is bcp? When does it use?

959

What is the osql utility?

1005

Un-Answered Questions { Databases }

What is heap table in mysql?

990

Differentiate between a local and a global temporary table?

975

What is a covered index?

954

How to loop through result set objects using odbc_fetch_row()?

999

What is the difference between clustered and non-clustered indexes?

1110

What is meant by datasource?

948

Can you tell how to find the number of rows in a resultset using php?

918

What is the max number of columns in an oracle table?

1017

What is the difference between for auto and for nested?

1030

How to enter binary string literals in ms sql server?

1176

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

607

How many types of knowledge Modules? Where are used in km?

634

How to change the order of columns in Oracle SQL Plus ?

1071

What is awe?

1032

How to see free space of each tablespace?

1051

For More Un-Answered { Databases } Questions Click Here