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

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 3601

how to insert the values in 5 table at a time Using any single statement ?

Infosys, Value Labs,

6 11751

In which table collections errors are stored.

2418

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1764

What is the difference between online backup & offline backup?

CSC,

3 10918

what is the difference between catalog & nocatalog?

CSC,

3 21627

internal architecture

CSC,

2201

what r the types of backup?

CSC,

5 7245

How to call the function and Procedure in trigger?

IBM,

3 11583

how will u see whether the dabase is in archive log mode or not?

CSC,

2 4407

by issuing "alter tablespace begin backup;" what happens to tablespace?

CSC, Logica CMG,

5 9323

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1838

which background process will run @ the time of creation of catalog database

CSC,

1 4585

How to select the name of employee who is getting maximum sal with out using subquery

15 16071

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 7988

Un-Answered Questions { Databases }

How do I kill a mysql connection?

912

How can you log an error to the server event log from a stored procedure?

1111

Why mysql is used with php?

981

How do I find my mysql username and password?

961

Does uninstalling mysql delete database?

1028

What is delimiter sql?

1014

how to avoid cursors? : Sql server database administration

976

How to write date and time literals in oracle?

1002

Can you rollback after commit?

995

How to create a new login name in ms sql server?

1068

Explain what are the restrictions while creating batches in sql server?

1079

How do you change constraints in postgresql?

917

What is pl sql commands?

1049

How can I see all tables in sql?

1080

Explain neo4j vs. Oriented?

For More Un-Answered { Databases } Questions Click Here