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

What is the between Function and Procedure?

HCL,

3 6464

how can i lock the column in the table

Accenture,

2 7154

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 5060

Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 3202

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

IBM,

13 19869

can you give me the syntax of named procedure??

2 4625

How can we check whether A S M instance is up or down?

Excelacom, HCL,

2475

How can we tune if buffer busy wait issue comes in oracle?

IBM,

1 3885

How can we tune a oracle database if log file sync issue comes

L&T,

2156

What are different types of refreshment techniques of materialised view

2 8278

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 12526

how to get the salary in descending order with out using the keyword desc in sql

Ramco,

5 10595

12 RULES OF RDBMS

1 4526

What is the relation b/w view and trigger

Accenture, TCS,

3 16705

can i use global variables in stored procedure or function

L&T,

1 8327

Un-Answered Questions { Databases }

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

2027

What are the types of table?

1031

what is the difference between group by and order by in sql? : Sql dba

1190

How do I view tables in mysql?

1033

What is the limitation of mysql?

1014

What is big data database?

976

How do I clear a mysql database?

1016

What is difference between function and procedure in mysql?

1011

Which function is used to find the largest integer less than or equal to aspecific value?

600

What are different types of queries?

1001

List different types of sybase index.

915

What is the default postgres user?

852

How to open postgresql gui in ubuntu?

967

Which method is used to update multiple document?

How to change the ownership of a schema in ms sql server?

1265

For More Un-Answered { Databases } Questions Click Here