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

Oracle (3253)
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 the purpose of the partition table?

1 1105

How does index help in query performance?

1 1110

What is db journal file?

1 1196

What is range partitioning?

1 1046

What is the size of partition table?

1 1111

How many disk partitions should I have?

1 1066

How many sectors are in a partition?

1 1144

How many types of tables are there?

1 1019

What are all ddl commands?

1 1157

What is the best partition size for windows 10?

1 1086

Does truncate table reset auto increment?

1 1079

How do temporal tables work?

1 1050

What is benefit of creating memory optimized table?

1 1054

Why is sharding used?

1 1083

Why do you partition data?

1 1080

Un-Answered Questions { Databases }

How do I remove duplicates in two columns?

1178

How raid can influence database performance?

1114

how to start mysql server? : Sql dba

1260

Disadvantages of the indexes?

1219

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

What are the types of database explain each of them briefly?

1053

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How efficient you are in oracle and SQL server?

1251

Can you index views?

953

What is in place upgrade in sql server?

1123

What is a scheduled job or what is a scheduled task?

1033

Suppose database is running slow, what will you do?

2590

What is the difference between case version and decode version?

1104

What are the properties of the transaction?

1069

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

For More Un-Answered { Databases } Questions Click Here