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?

2160

to explain sql server 2000 architecture & authentication

HCL,

1 5268

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 9501

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 12557

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 12019

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

Satyam,

9 15883

about join

2 4798

about foregine

2 4188

How to find out the second largest element from mysql table

15 28519

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

2 5078

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

iFlex,

1 6120

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

IBM,

5 13407

How can u convert the Date to String?

Microsoft, TCS,

6 16892

What is Deadlock?

Satyam,

4 9000

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

5 11446

Un-Answered Questions { Databases }

How do I install mysql workbench?

915

What is view dbms?

926

Does group by or order by come first?

964

What you know in mapping of erd to dfd?

969

What is oracle thin client?

1029

Does mysql_real_escape_string prevent sql injection?

956

What is the default postgres database?

857

How to stop log file growing too big?

1025

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1010

What are data driven subscriptions?

115

Is truncate autocommit in oracle?

1093

What is the disadvantage of User defind function?

2301

Where is mongodb stored?

What is an oracle user account?

1000

How to find second highest salary from a table?

1027

For More Un-Answered { Databases } Questions Click Here