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

Repair MS Access database without having program installed

HomeUs,

2 3130

Clipper / DBF error

1 2929

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

BT,

2207

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

TCS,

3 7109

How to read 2nd highest sal from EMP table?

IBM, TCS,

5 6328

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

Oracle,

1 4324

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 4456

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 3947

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 4087

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 3930

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 3447

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 3689

how to we delete a row using varray

CTC,

3 4795

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

MasterCard,

2 4465

difference between bind variable and variable

Attra,

1 3198

Un-Answered Questions { Databases }

What is a domain in microsoft access?

936

What is varray?

1198

How to return the second 5 rows in ms sql server?

1108

How to use subqueries with the exists operator in oracle?

1071

What is mean by dbms?

1119

Explain isolation levels. : Transact sql

1111

How many anonymous blocks can be defined?

1255

How are sql commands classified?

1143

What is extended stored procedures?

1030

Define mongodb?

How do you rebuild an identity column?

999

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2828

Is truncate autocommit in oracle?

1153

What are all the common sql functions?

1086

What is a design view?

978

For More Un-Answered { Databases } Questions Click Here