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

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

Wipro,

4 8963

definition of cluster and non-clustered index?

CSS,

1 3141

how to get the index id?

Cognizant, TCS,

1 5731

What is normalization? dec 2009

Cognizant,

3 8183

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

2232

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

1 4220

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

2 10314

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

Cognizant, Infosys,

10 18806

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????

1 1999

how u can find the n row from a table?

Tech Mahindra,

19 30404

What is Primary Key?

Ramco,

4 10591

Difference between join and a subquery?

Base Automation, NMDC,

8 45482

Difference between sql and mysql?

1 2154

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

1 4360

What does TKPROF stand for?

5 14453

Un-Answered Questions { Databases }

Can you index views?

951

What versions of clipper does netlib support?

1079

How do I find query history in sql server?

1018

What are the steps in creating a database?

1002

Can we do dml on views?

1027

How did mongodb get its name?

Have you used lexical parameters in reports?

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2044

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1184

What is the latest version of postgresql?

946

How do I start sql server 2017?

1006

What are different types of constraints?

995

How raid can influence database performance?

1104

What is sql or structured query language?

1213

Explain “row_number()” in sql server with an example?

1066

For More Un-Answered { Databases } Questions Click Here