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

What is join view in sql?

951

Does sql between include endpoints?

1021

What are the different type of joins in sql?

962

Is oracle and sql same?

1022

What is a common use of group by in sql?

1057

What is clustered and nonclustered index in sql?

951

What can I use instead of union in sql?

978

Is null operator in sql?

1048

What is sql injection owasp?

1073

What is sql entity?

1111

What is sql clause?

1058

How do I find duplicates in a single column in sql?

1032

Does view store data in sql?

973

Which sql statement is used to return only different values?

1017

Can we use having without group by in sql?

995

Un-Answered Questions { Databases }

How do you delete data from a table?

1054

What is trigger and types?

1032

What is difference between schema and table?

930

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2535

What is trace flag in sql server?

1038

What are the different types of database management systems?

1013

Can a foreign key have a different name?

950

Is it possible to insert comments into sql statements return in the data model editor ?

2575

How to specify transaction or query timeout?

1056

Enlist some commands of ddl, dml, and dcl.

987

Can we perform backup restore operation on tempdb?

1034

What are the attributes of cursor?

1062

What is inverted file ?

1411

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2419

Do prepared statements prevent sql injection?

958

For More Un-Answered { Databases } Questions Click Here