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 5648

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 16912

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

2498

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 5601

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 3992

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 4850

please explain about oracle

1 3721

What are wait events. Describe the wait event tables.

CTS,

1 7505

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

1 11981

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

8 14257

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

IBM,

2441

Un-Answered Questions { Databases }

Can we use mysql and mysqli together?

989

What is the non-clustered index in sql?

1064

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2857

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1145

What is the difference between a form and a report in access?

885

What are the most common interview questions on ETL Testing for experience?

1144

How to provide default values to stored procedure parameters?

1068

What is unique key in mysql?

991

What does GEQO stands for in PostgreSQL?

1391

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2969

Explain the difference between drop and truncate commands in sql?

1053

What is edb postgres?

815

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

941

What is difference between 2 tier and 3 tier architecture?

781

Explain the difference between function and stored procedure?

945

For More Un-Answered { Databases } Questions Click Here