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

Explain the family trees and connection by clause

2355

What is the difference between views and stored procedures? Can we have input parameters for views?

6 19812

Which databases are part of SQL server default installation? Explain the usage of each?

Accenture,

2 7947

What all db objects can be found in MSDB database of a SQL Server instance?

Accenture,

2 8307

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

Accenture,

3 12673

What is Query Execution Plan? How does it help optimize or tune a database driven application?

Accenture, Polaris,

2 10421

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

1 2144

how to delete duplicate rows from table

CSC,

9 14476

can a table has a column that has only view data and in other columns we can change data?

Secon,

2 5245

What is the diff between Static Queries and Dynamic queries give me some examples

CSC,

2 11022

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 3803

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 27050

what is the main difference between constraints(like primary key etc..)& joins?

2 6365

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

1 2301

What is the difference between DELETE and TRUNCATE?

Johns Hopkins University, Tech Mahindra,

15 25919

Un-Answered Questions { Databases }

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1953

how to escape special characters in sql statements? : Sql dba

1113

what is spatial nonclustered index

1054

What are the two main functions of queries in databases?

1525

How do I create a trace in sql server?

1116

How do I find the sql server version?

1099

What is temporary table in sql server? Why we use temp table?

1017

Is there some bulk load or other way to import a lot of data fast?

931

what is sql server agent? : Sql dba

1181

Are you familiar with user exits in reports?

What is subquery? Explain the properties of a subquery?

1056

How to define array in mongoose schema?

Can we use distinct and group by together?

1133

What are different types of constraints?

997

what is dbms? : Sql dba

1061

For More Un-Answered { Databases } Questions Click Here