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 5783

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 2360

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

1 2397

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

L&T,

8 17253

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

Cognizant,

2158

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

1 2581

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 5740

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 4101

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 2403

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

1 4961

please explain about oracle

1 3816

What are wait events. Describe the wait event tables.

CTS,

1 7644

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

1 12109

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

8 14650

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

IBM,

1 2526

Un-Answered Questions { Databases }

How to use values from other tables in update statements using oracle?

1147

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

1061

What are the types of database explain each of them briefly?

1046

What are the source of constraints?

1006

What is a scheduled job or what is a scheduled task?

1029

What is clustered index

1081

how to start mysql server? : Sql dba

1258

Why and when do stored procedure recompile?

1052

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

1108

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1895

What is the latest version of postgresql?

946

What is self contained sub query?

1135

How to remove duplicate rows from table except one?

1077

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2696

Is primary key always clustered index?

1088

For More Un-Answered { Databases } Questions Click Here