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 5647

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 16897

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

Cognizant,

2094

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

2497

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 5600

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

2322

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

1 4849

please explain about oracle

1 3717

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 14250

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

IBM,

2441

Un-Answered Questions { Databases }

If any stored procedure is encrypted, then can we see its definition in activity monitor?

987

Have you heard about sixth normal form?

992

What command would you use to create an index?

1056

What are dml (data manipulation language) statements in ms sql server?

983

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7972

what are the properties and different types of sub-queries? : Sql dba

1034

What is oracle sid?

955

What is indexing in mysql?

965

How to connect html form to mysql database using php?

946

Explain about temporary stored procedure?

1018

What is oracle rowcount?

1084

How can I insert images into a Mysql database?

1051

Who is communication horizons?

935

Explain about the implementation of stored procedures?

878

How to display employee records who gets more salary than the average salary in the department?

1065

For More Un-Answered { Databases } Questions Click Here