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

2290

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

6 19577

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

Accenture,

2 7818

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

Accenture,

2 8155

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 12449

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

Accenture, Polaris,

2 10274

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?

2091

how to delete duplicate rows from table

CSC,

9 14140

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

Secon,

2 5124

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

CSC,

2 10892

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 3679

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 26764

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

2 6244

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

2237

What is the difference between DELETE and TRUNCATE?

Johns Hopkins University, Tech Mahindra,

15 25306

Un-Answered Questions { Databases }

What is checkpoint in sql server?

1177

How can you create and drop view in mysql?

943

Give the query of getting last two records from the table in SQL SERVER?

976

What is raw datatype in oracle?

1157

What does the no logging option do? Why would we use it? Why would we be careful of using it?

567

What are the applications of database management system?

913

what are the advantages of mysql in comparison to oracle? : Sql dba

1018

What is flush privileges in mysql?

1007

What is oracle sid?

964

What is policy based management (pbm)? : sql server database administration

999

What is the current mysql version?

1030

what is a view? : Sql dba

1107

Is mongodb a documentdb?

What is transaction server auto commit?

1077

What are the functions used to encrypt and decrypt the data present in mysql?

1120

For More Un-Answered { Databases } Questions Click Here