Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 5761

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,

1 2348

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

1 2395

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

L&T,

8 17234

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

Cognizant,

2150

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

1 2560

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 5730

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 4086

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

1 2393

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

1 4951

please explain about oracle

1 3803

What are wait events. Describe the wait event tables.

CTS,

1 7621

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

1 12084

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

8 14617

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

IBM,

1 2514

Un-Answered Questions { Databases }

Why use identity in sql server?

1185

How do I remove duplicates in two columns?

1162

how to escape special characters in sql statements? : Sql dba

1097

What is the difference between upgrade and migration in sql server?

1163

What are the different SQL Server Versions you have worked on?

1071

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

Why and when do stored procedure recompile?

1042

What is the best sql course?

1031

How efficient you are in oracle and SQL server?

1234

Have you used lexical parameters in reports?

Is there some bulk load or other way to import a lot of data fast?

923

Are you familiar with user exits in reports?

How can I check that whether automatic statistic update is enabled or not?

1101

What is clustered index

1069

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2089

For More Un-Answered { Databases } Questions Click Here