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

wat is mean by normalization?......programing defination i need...(i know basic defination)

Wipro,

4 8707

definition of cluster and non-clustered index?

CSS,

3035

how to get the index id?

Cognizant, TCS,

1 5651

What is normalization? dec 2009

Cognizant,

3 7979

hi, i am new to database cau give me link where can i get about databse..

2166

If we use where clause in the left outer join then how the query would behave/act?

1 4098

write sql program to get the detail of student in a class?

2 10149

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

Cognizant, Infosys,

10 18403

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

1928

how u can find the n row from a table?

Tech Mahindra,

19 29510

What is Primary Key?

Ramco,

4 10344

Difference between join and a subquery?

Base Automation, NMDC,

8 45092

Difference between sql and mysql?

2092

Its possible to use auto increment in oracle or not? If no means why?

1 4244

What does TKPROF stand for?

5 14219

Un-Answered Questions { Databases }

What are some examples of schemas?

980

explain what is odi?why is it different from the other etl tools.

619

What is the default postgres database?

851

How do I run sql profiler?

1066

What is the report model project?

141

Explain asa, asa ultralite.

861

How MySQL Optimizes DISTINCT?

1109

How to remove row affected and dashes?

911

What is blob datatype?

1128

What is the basic form of sql query?

943

Do you know what is difference between stored procedure and user defined function?

1091

how we use window authentication connection with sql server.?

1152

What are the different types of backup available in the oracle?

586

Does adding an index lock a table?

960

Does transparent data encryption provide encryption when transmitting data across the network?

1047

For More Un-Answered { Databases } Questions Click Here