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

Write a sql query to delete duplicate records from a table called table1

1054

Which data type columns are the best candidates for full-text indexing?

985

What stored procedure can you use to display the current processes?

910

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1050

What is database replication?

1162

Can you force a query to use a specific index?

965

How you can get a list of all the table constraints in a database?

981

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

954

Write a sql query to sort on different column name according to the parameters passed in the function?

920

What will happen if a column containing char type data is changed to the nchar data type?

1115

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1159

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

1027

How you can move data or databases between servers and databases in sql server?

1065

What is a fill factor?

1101

How can you find out which stored procedures are recompiling?

932

Un-Answered Questions { Databases }

What is the usage of nvl function?

1069

Why place tempdb and log on low numbered devices?

845

How to present flrehird.log file from filling up the disk partition?

How to write optimized query in mysql?

1006

what are the difference between clustered and a non-clustered index? : Sql dba

1053

What is the best database management system?

999

How many types of users in dbms?

918

What is meant by a deadlock situation?

1122

What is the parameter mode that can be passed to a procedure?

1069

What do you understand by mirroring and mention the advantages of the mirroring?

1077

What is the difference between null value, zero, and blank space?

1222

How do I shrink an ldf file?

997

How to set up local postgres database?

862

How do I know if localdb is running?

971

What are foreign keys in database?

984

For More Un-Answered { Databases } Questions Click Here