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

Explain the family trees and connection by clause

2275

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

6 19543

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

Accenture,

2 7806

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

Accenture,

2 8138

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 12433

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

Accenture, Polaris,

2 10252

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?

2081

how to delete duplicate rows from table

CSC,

9 14093

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

Secon,

2 5110

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

CSC,

2 10876

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 3660

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 26724

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

2 6231

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).

2224

What is the difference between DELETE and TRUNCATE?

Johns Hopkins University, Tech Mahindra,

15 25236

Un-Answered Questions { Databases }

What is dba in sql? : SQL DBA

1045

Calculate difference between 2 date / times in oracle sql?

1044

What is external database?

872

How do you concatenate strings in mysql?

1008

How is data stored in a database?

937

What is difference between unix timestamp and mysql timestamp?

1018

What is 32-bit nuances?

Who created postgresql?

768

How to find the unique values if the value in the column is repeated?

995

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

Explain aggregate functions?

1089

explain about light scans in informix?

123

What are difference between Cluster index and Non-Cluster index?

1082

What is sql and explain its components?

1074

What is split brain syndrome in rac?

For More Un-Answered { Databases } Questions Click Here