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

Find all employees in Dept “Marketing”.

2 4906

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.

2619

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,

3938

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

Satyam,

5 8468

how to replace double quotes by single quotes in sql server

CAC,

2 13302

what is the difference between securityand protection in dbms?

2 11638

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 6872

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 4697

what is for foreign key ??

CarrizalSoft Technologies, Sabic,

4 7621

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 11648

What is cluster table or non_cluster table?

1 4144

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

2566

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

2113

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

1823

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

1972

Un-Answered Questions { Databases }

What are the other commands to know the structure of a table using mysql commands except explain command?

1041

Why do we use coalesce function in oracle?

1125

How to pad with leading zeros an int or smallint in sybase?

853

How many types of triggers exist in pl/sql?

1075

What is rdbms table?

988

Is there a google equivalent to microsoft access?

814

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1067

What are system databases into sql server (2005/2008)?

1003

Can a database be shrunk to 0 bytes, if not, why?

1108

what are the authentication modes in sql server? How can it be changed? : Sql dba

1436

What is the difference between Stored Procedures and triggers?

1083

What is the difference between count 1 and count (*) in a sql query?

998

Explain about Microsoft access?

861

Is sql server 2016 free?

945

What is denormalization in a database?

1058

For More Un-Answered { Databases } Questions Click Here