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

Why cross join is used?

1 1152

How do I edit a stored procedure?

1 1067

How do I debug a stored procedure?

1 1192

Can we use views in stored procedure?

1 1101

What are stored procedures used for?

1 1070

Can we debug stored procedure?

1 1087

Can we alter stored procedure?

1 1067

Is left join same as join?

1 1055

What are the types of subqueries?

1 1121

Is trigger a stored procedure?

1 996

How do you optimize a stored procedure query?

1 1064

Is a view faster than a stored procedure?

1 1035

Is stored procedure faster than query?

1 1043

What is procedure and function?

1 1060

What is procedure function?

1 1159

Un-Answered Questions { Databases }

Suppose database is running slow, what will you do?

2590

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

What is current version of mysql?

1064

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2088

What are the advantages of database?

1009

When should you use an instead of trigger?

1042

how to use regular expression in pattern match conditions? : Sql dba

1105

what is spatial nonclustered index

1052

Which statement is used in a select query for partial matching?

1239

What are the properties of the transaction?

1069

Design database draw er diagram for a certain scenario ?

4643

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2346

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 kind of problems occurs if we do not implement proper locking strategy?

1493

How to Change a users password from unix shell.

1210

For More Un-Answered { Databases } Questions Click Here