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 8723

definition of cluster and non-clustered index?

CSS,

3035

how to get the index id?

Cognizant, TCS,

1 5653

What is normalization? dec 2009

Cognizant,

3 7993

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 4104

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

2 10153

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

Cognizant, Infosys,

10 18415

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

1930

how u can find the n row from a table?

Tech Mahindra,

19 29545

What is Primary Key?

Ramco,

4 10358

Difference between join and a subquery?

Base Automation, NMDC,

8 45116

Difference between sql and mysql?

2099

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

1 4247

What does TKPROF stand for?

5 14233

Un-Answered Questions { Databases }

What is the difference between DataRow.Delete() and DataRow.Remove()?

1230

Is mysql a backend?

933

How do I order by ascending in sql?

1026

What is n tier architecture with example?

764

What are the source of constraints?

933

What are “phantom rows”?

1666

What is the driver name for postgresql?

814

What are the 3 modes of parameter?

1156

Why the trigger fires multiple times in single login?

1214

What conditions he must fullfil before being accepted as a publisher?

999

Is mongodb atlas free?

What is a database instance?

597

Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?

947

How to convert binary strings into integers in ms sql server?

1034

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4015

For More Un-Answered { Databases } Questions Click Here