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

why sql is used as interpreter frequently rather than a compile?

1 5650

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

HCL,

2280

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

L&T,

8 16918

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

Cognizant,

2099

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2502

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

Sapient,

2 5604

I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 3996

I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a

2328

how to create an user in oracle 10g.please give me an example..

1 4851

please explain about oracle

1 3724

What are wait events. Describe the wait event tables.

CTS,

1 7506

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 11984

how we can find nth max salary from an employe table by using my sql?

8 14265

what are the tools used for oracle 10g in real time.

IBM,

2441

Un-Answered Questions { Databases }

What are the difference between mongodb and mysql?

1355

What is the difference between view and materialized view in Oracle?

1156

How to do Data integrity testing? Who does this testing (Developer or tester)?

2113

Which database server is best?

1080

How many segment are present in Oracle Manufacturing

2320

How would you open an ms access database that has been converted to a current version?

833

How do I edit a stored procedure in mysql?

923

Does sql backup shrink transaction log?

983

internal architecture

2199

What does schema mean?

953

What is a Built_in subprogram ?

4001

By default, which index is created by mongodb for every collection?

Explain system rowset functions?

1004

Can I use a named pipe to bcp/dump data out or in in sybase?

1008

How do I add a column in postgresql?

855

For More Un-Answered { Databases } Questions Click Here