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 2990

Clipper / DBF error

1 2869

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

BT,

2172

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

TCS,

3 6995

How to read 2nd highest sal from EMP table?

IBM, TCS,

5 6170

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

Oracle,

1 4254

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 4369

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 3848

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 3991

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 3868

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 3383

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 3606

how to we delete a row using varray

CTC,

3 4681

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

MasterCard,

2 4380

difference between bind variable and variable

Attra,

1 3117

Un-Answered Questions { Databases }

what is profile in odi?

655

How do I open a mongodb file on a mac?

You need to migrate the ms access database tables to oracle. What steps will you take?

822

How can one get sql*loader to commit only at the end of the load file? : aql loader

1062

What is scalar user-defined function?

1110

What is access good for?

802

What is data type in sql?

969

Explain drop constraint oracle?

1075

How are the stats updated in postgresql?

862

What do you understand by integration services in sql server?

968

Who owns mysql database?

1047

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

794

How do I setup a database connection?

1014

What are the functions of rdbms?

1003

What do you understand by row chaining?

For More Un-Answered { Databases } Questions Click Here