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

Repair MS Access database without having program installed

HomeUs,

2 2976

Clipper / DBF error

1 2862

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

BT,

2170

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

TCS,

3 6987

How to read 2nd highest sal from EMP table?

IBM, TCS,

5 6155

I want to execute a piece of code before calling a procedure. How to achieve it?

Oracle,

1 4249

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

Maruti Suzuki,

2 4362

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

Maruti Suzuki,

2 3839

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

Maruti Suzuki,

2 3985

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

MasterCard,

1 3858

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

MasterCard,

1 3374

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

MasterCard,

2 3598

how to we delete a row using varray

CTC,

3 4666

if i am using dml statement in function. then i am writing select statement what was the output

MasterCard,

2 4368

difference between bind variable and variable

Attra,

1 3109

Un-Answered Questions { Databases }

Explain how are indexes update?

1064

How do you use workspace in sybase?

912

How to make remote connection in database?

1005

Do you know what are the properties of the relational tables?

1031

what command would you use to move the physical log?

197

What is the difference between microsoft excel and microsoft access?

852

What is 2NF?

840

Can binary strings be used in arithmetical operations?

937

What are the applications of database?

884

What is data type in oracle?

1125

How do we know if any query is retrieving a large amount of data or very little data?

975

What do you mean by cubes and olap cubes?

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4283

Explain the use of analyse option in exp command.

1128

How to change varchar(m) to varchar(n) in sybase?

962

For More Un-Answered { Databases } Questions Click Here