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

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

TCS,

7 21924

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 11769

How do you switch from an init.ora file to a spfile?

TCS,

4 20145

Explain the difference between a data block, an extent and a segment.

2 10821

Give two examples of how you might determine the structure of the table DEPT.

2 11671

Where would you look for errors from the database engine?

IBM,

1 2905

Compare and contrast TRUNCATE and DELETE for a table.

7 16097

Give the reasoning behind using an index.

2 8797

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 7750

What type of index should you use on a fact table?

1 4059

Give two examples of referential integrity constraints.

2 8747

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1 2584

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 24761

What command would you use to create a backup control file?

2 5453

Give the stages of instance startup to a usable state where normal users may access it.

1 3506

Un-Answered Questions { Databases }

what are all the common sql function? : Sql dba

1113

how many tables will create when we create table, what are they? : Sql dba

1129

What are the two main functions of queries in databases?

1509

How to use values from other tables in update statements using oracle?

1139

how to start mysql server? : Sql dba

1249

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2297

what is sql server agent? : Sql dba

1162

List out the different types of locks available in sql server?

1037

what is the age limit for groups1 examination

2322

What are the properties of the transaction?

1059

What is subquery? Explain the properties of a subquery?

1046

Can you index views?

946

what is the difference between openrowset and openquery?

1174

What are the different SQL Server Versions you have worked on?

1071

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used?

1899

For More Un-Answered { Databases } Questions Click Here