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

What is the between Function and Procedure?

HCL,

3 6331

how can i lock the column in the table

Accenture,

2 7045

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

2 4965

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 3126

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

IBM,

13 19408

can you give me the syntax of named procedure??

2 4524

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

Excelacom, HCL,

2421

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

IBM,

1 3804

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

L&T,

2107

What are different types of refreshment techniques of materialised view

2 8175

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 12258

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

Ramco,

5 10415

12 RULES OF RDBMS

1 4433

What is the relation b/w view and trigger

Accenture, TCS,

3 16525

can i use global variables in stored procedure or function

L&T,

1 8247

Un-Answered Questions { Databases }

How to get a list of columns in a view using the "sp_columns" stored procedure?

1040

Explain different types of self contained sub query?

1037

How can we find out the current date and time in oracle?

1088

What is the simplest tool to run commands on oracle servers?

1009

Explain how to close periods in ar. : oracle accounts receivable

1312

Explain degree of a relation?

905

How to replace the Query Result 'Null Value' with a text ?

1042

What is mongodb host?

Explain indexed views and partitioned view with their syntax.

1146

What is oracle update statement with inner join ?

1059

How to create a test table in your mysql server?

1048

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

985

Explain storage manager?

1035

How to migrate paradox, dbase or foxpro database to firebird?

1026

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

558

For More Un-Answered { Databases } Questions Click Here