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

Do you think BCNF is better than 2NF & 3NF? Why?

Ernst Young,

1 1350

Write a query for primary key constraint with identity key word?

MindCracker,

1 1095

Can we return Data from 4(more than 1) tables in stored procedure?

HCL,

1 1139

Define Joins?

HCL,

1 1100

Suggest a method of joining two tables.

Ernst Young, Thomson Reuters,

1 1249

Give me any three differences between Truncate and Delete.

Genpact,

1 1194

What are the types of lock supported by ?

HCL,

1 1108

What is the name of the system variable that returns the number of rows affected by a SQL statement?

HCL,

1 1090

What is the difference between Stored Procedures and triggers?

HCL,

1 1153

How to update muliple row in single query?

MCN Solutions,

1 1140

Tell me about the approaches which you used to counter the DI problems.

EXL,

1 1453

What is nolock hint in sql server 2008

HCL,

1 1201

What is normalization? Explain its different types?

GE, Maveric,

1 1169

Different types of keys in SQL?

Infosys,

1 1156

What are Spatial data types in SQL Server 2008

Infosys,

1 1096

Un-Answered Questions { Databases }

What is a scheduled job or what is a scheduled task?

1029

List out the different types of locks available in sql server?

1041

What is the difference between upgrade and migration in sql server?

1170

what is bcp? When does it used? : Sql dba

1051

When should you use an instead of trigger?

1041

how to use regular expression in pattern match conditions? : Sql dba

1102

Is primary key always clustered index?

1085

How to put more than 1000 values into an oracle in clause?

1099

Suppose database is running slow, what will you do?

2586

what is schema? : Sql dba

1127

How raid can influence database performance?

1102

what is spatial nonclustered index

1050

What is a view in sql?

1035

What are the types of database explain each of them briefly?

1042

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

For More Un-Answered { Databases } Questions Click Here