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 interval partition?

1 1133

What is the use of index in hive?

1 1073

What is memory optimized?

1 1154

Can two tables have same primary key?

1 1052

What is bitemporal narrowing?

1 1416

What is meant by temporal data?

1 1030

What is a table partition?

1 1239

What does desc stand for?

1 1147

What does bitemporal mean?

1 1136

How is data stored on a disk?

1 1100

Should I use mbr or gpt?

1 1082

What are system versioned tables?

1 1111

What is difference between group by and partition by?

1 1163

What is a ddl command?

1 1193

What is an invalid partition table?

1 1088

Un-Answered Questions { Databases }

If a cursor is open, how can we find in a pl/sql block?

1235

Suppose database is running slow, what will you do?

2590

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

How to convert numeric expression data types using the cast() function?

1142

how to escape special characters in sql statements? : Sql dba

1110

Who proposed the relational model?

1027

what is schema? : Sql dba

1137

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

1053

How raid can influence database performance?

1114

Is microsoft getting rid of access?

883

How do I remove duplicates in two columns?

1178

List the ways in which dynamic sql can be executed?

1083

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

What is the current mysql version?

1095

Can we do dml on views?

1032

For More Un-Answered { Databases } Questions Click Here