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 the scripts in data base?

2171

to explain sql server 2000 architecture & authentication

HCL,

1 5281

In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id?

ISRO,

3 9514

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 2 Solution : emp1 names are updated in emp2, write a query?

8 12589

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 12035

oracle is compiler or interpretter,can any one tell me the answer?

Satyam,

9 15925

about join

2 4807

about foregine

2 4204

How to find out the second largest element from mysql table

15 28606

Is it possible to enter only time value into a column of a table in sql?

2 5093

i created a parameter list in reports. how to restrict that parameter list with parameters

iFlex,

1 6124

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

IBM,

5 13433

How can u convert the Date to String?

Microsoft, TCS,

6 16930

What is Deadlock?

Satyam,

4 9023

select top 5 * from emp order by newid() my question is , how this query get executed?

5 11478

Un-Answered Questions { Databases }

explain about light scans in informix?

124

Is postgresql a sql server?

949

What are built in functions?

1038

How to create a trigger for insert only?

1056

What is database clustering in mysql?

1045

What is the full form of ddl?

946

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2339

What is the difference between getdate and sysdatetime?

1026

Why should I use mysql?

958

How to create and drop temp table in sql server?

1067

Difference between connected and disconnected database in .net with sql server?

1112

How can you take database backup in mongodb?

Is it good to store images in database?

1015

Who is communication horizons?

948

What is the recovery model?

1008

For More Un-Answered { Databases } Questions Click Here