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 about ur projets on teradata???

Wipro,

1742

what is checksum in sql server.........???

TCS,

1646

what is try_catch block in procedure

1683

how to retrieve data from different tables ,place this data in different excel worksheets.

Gap Inc,

1 2723

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1470

What is AUTH_ID and AUTH_USER in pl/sql ?

INDUS,

2148

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

United Healthcare,

1638

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

ICICI,

4 4729

how to write customizations in po

Ernst Young,

1575

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

CTS,

1 2604

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

Societe Generale,

1 3548

how to handle exceptions in post production

1375

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1346

What is Lock table in SQL?

Wipro,

1423

How to get maxsal , minsal, ename department wise in single query

1513

Un-Answered Questions { Databases }

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1552

What is named calculation? : sql server analysis services, ssas

946

Why should one not prefix user stored procedures with ‘sp_’?

1004

What is difference between database and website?

1000

How is data stored in postgresql?

795

Name the three major set of files on disk that compose a database in Oracle?

1083

Explain what is log shipping?

1088

What is the difference between sql and t sql?

987

Can we use threading in pl/sql?

991

What is ssl in sql server?

1031

Tempdb is full. How would you clear it?

852

what are rollup and cube in t-sql? : Transact sql

1061

What is tablesample?

1053

Are database administrators in demand?

530

What is a snapshot log?

967

For More Un-Answered { Databases } Questions Click Here