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

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

1 3674

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

Infosys, Value Labs,

6 11985

In which table collections errors are stored.

2465

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

1810

What is the difference between online backup & offline backup?

CSC,

3 11078

what is the difference between catalog & nocatalog?

CSC,

3 21755

internal architecture

CSC,

2255

what r the types of backup?

CSC,

5 7428

How to call the function and Procedure in trigger?

IBM,

3 11708

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

CSC,

2 4519

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

CSC, Logica CMG,

5 9485

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

1889

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

CSC,

1 4681

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

15 16503

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 8185

Un-Answered Questions { Databases }

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1054

Can you use microsoft access on a mac?

854

How to insert multiple rows with one insert statement in oracle?

1140

What are the important tasks of common oracle dba?

599

What are the different acid properties?

1128

what is tripstop report?

1914

What is Replication?

1109

What are the triggers associated with image items?

1095

1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

1829

Give the order of sql select?

1190

Explain unique key in sql.

1066

What is the phantom problem?

1047

How to start the command-line sql*plus?

1119

Explain about Joins?

1039

What is the maximum number of columns in sql table?

1237

For More Un-Answered { Databases } Questions Click Here