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

Find all employees in Dept “Marketing”.

2 5092

C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.

1 2686

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

TCS,

1 4043

what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms).

Satyam,

5 8715

how to replace double quotes by single quotes in sql server

CAC,

2 13451

what is the difference between securityand protection in dbms?

2 11786

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 7126

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

2 4845

what is for foreign key ??

CarrizalSoft Technologies, Sabic,

4 7839

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

TCS,

9 12008

What is cluster table or non_cluster table?

1 4264

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

1 2639

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

1 2203

How to do Stored procedure testing? Who does this testing (Developer or tester)?

1 1894

What is the role of tester in discovery(in Checklist)?

1 2030

Un-Answered Questions { Databases }

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

What are different types of constraints?

995

Is it possible to have clustered index on separate drive from original table location?

1034

Does group by remove duplicates?

1112

What are the two main functions of queries in databases?

1525

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

2701

Are you familiar with user exits in reports?

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

1108

How raid can influence database performance?

1114

What is the latest version of postgresql?

951

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

931

Suppose database is running slow, what will you do?

2590

What is in place upgrade in sql server?

1123

How do I find the sql server version?

1099

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

For More Un-Answered { Databases } Questions Click Here