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

What is Files and Filegroups in SQL Server & it's implementation.

Zenith,

1 9399

what are the advantages of Oracle over other databases..? please give me reply...

2 11207

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 8117

What is the maximum nesting level of Stored Procedure and Triggers in Sybase?

L&T,

2 15006

What is the use 'return' keyword in Stored Procedure?

2 11872

hi in which phase of mload can i use .FILLER

IBM,

1 4974

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

IBM,

1 2925

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

1 3942

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

Apollo,

2 6357

what is single byte over head in oracle..?

1 2470

please explain database architecture..

Infosys,

1 12830

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 17006

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1 2332

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

Thomson,

5 9396

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

TCS,

10 21082

Un-Answered Questions { Databases }

How to start an oracle instance?

1094

Disadvantages of the indexes?

1216

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2696

Can delete statement be rollbacked?

1049

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?

1903

what are all the common sql function? : Sql dba

1123

Have you written applications to retrieve stored images in a table?

1083

Can we shrink data file in sql server?

1118

Were you involved in any data conversion, which one?

how to start mysql server? : Sql dba

1258

How to put more than 1000 values into an oracle in clause?

1103

How to enter binary string literals in ms sql server?

1235

What is sql server query analyzer?

1118

How to export data from database and import into another?

985

What are the different types of subquery?

1227

For More Un-Answered { Databases } Questions Click Here