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 difference between Procedure and Function

Accenture, Nagarro, TCS,

4 11538

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2223

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

Tech Mahindra,

6 10610

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

2503

how can we view column head in first page but not in remaining pages?

TCS,

2043

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 3695

What is the sql query to find the employee who has Nth maximum salary?

2 5335

how can we store any pdf file in oracle

2164

ow to bring suspect mode datbase online from scratch

1807

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2112

When do we create bitmap indexes

CTS,

2 9968

if i want to display the name of students such that to which city they belong must have count greaer than two

Atos Origin,

2232

How to read and create .LDC data files which are used by linguatic dictionary.

2532

define sql

Zensar,

3 6459

wat new abt truncate in sql server

HCL, HP,

2 6841

Un-Answered Questions { Databases }

How to encrypt data between dialogs?

1114

What is data type for image in mysql?

871

What are the benefits of using access?

916

How to print message in mysql trigger?

1516

What is the role of tables in database?

963

What is crud diagram?

952

What is nolock?

987

what are the acid properties in dbms?

1021

What is difference between mongod and mongodb?

How to return top 5 rows in oracle?

1066

What is the purpose of TNS?

1034

How to define output parameters in stored procedures?

1029

If a stored procedure is taking a table data type, how it looks?

6451

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1777

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1194

For More Un-Answered { Databases } Questions Click Here