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

dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??

2297

how to find count rows in table without count function?

Oracle,

3 7124

i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?

Oracle,

5 7986

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

DELL, TCS,

4 9194

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

Infosys,

4 8559

Explain the Normalized Relations?

2754

what is the main difference between join and subqurey?

Oracle,

3 7771

What is Tax Categories?

2162

1. What is PO rate variance gain and loss?

Oracle,

3010

3. Steps in UAT?

Oracle,

2480

8. Supporting AP, AR and GL?

Oracle,

2362

What is supporting issues GL AP and AR?

Oracle,

2616

is database gud carrier option??

1 3678

i have some prob lem to tell me about my self in interview first round ...

2215

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2194

Un-Answered Questions { Databases }

What is the maximum size of an access database?

912

How to return the top 5 rows from a select query in ms sql server?

1209

What is the best alternative to microsoft access?

848

What is dbms in mysql?

1013

Is BCNF better than 2NF & 3NF? Why?

1104

What are information schema views?

1030

How to enter boolean values in sql statements?

1177

What is the difference between db-lib and ct-lib in sybase?

887

What is mutating trigger?

1073

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1098

Compare in and exists?

962

How do I manually create a database?

1273

Why query optimization is needed?

973

What are queries used for?

998

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

1020

For More Un-Answered { Databases } Questions Click Here